As part of the BI360 Suite, financial reports can be created. But what’s the point of creating the financial reports unless trained eyes from your organization are analyzing the numbers to find the strengths and weaknesses of your business.
A very valuable, yet underused part of the BI360 Suite is the Report Publisher. Through the use of the Report Publisher, you can publish financial reports and budgeting/forecast forms in static Excel workbooks based on a BI360 template designed in the Report Designer. In addition, you can integrate the security settings that have already been configured for your organization to safely and securely distribute reports throughout different members in your organization. Finally, the Report Publisher can easily be configured in the built-in Windows Task Scheduler so that you can schedule the previous month’s financial report or the current month goal to be distributed on a set date. There are many more features like the output format or the report delivery method that you can utilize to customize the distribution of your reports.

LOS ANGELES, California, March 19, 2012 – Solver, Inc., a global leader in Business Intelligence for Microsoft Dynamics AX, GP, NAV, SL and other enterprise resource planning (ERP) systems, today announced the scheduled release of web-based reporting for BI360.

“Companies are reinventing themselves with the Cloud,” said Nils Rasmussen, CEO of Solver. “Whether making it easier for business users to access reports on the Web and mobile devices, or, eliminating the burden of IT, companies are innovating, and Solver is at the forefront of this new era when it comes to live, web-based ERP reporting.”

BI360 Reporting in the Cloud will give users the ability to create and run reports live (real-time) from their ERP system or the BI360 data warehouse, all within their web browser. This exciting new platform will provide decision makers with more access to business trends and in-depth reports. Users of BI360 Reporting can use a web browser on any computer or mobile device to run ERP reports and drill down to detail. The solution is also optimized for hosted environments with Software-as-a Service (SaaS) pricing, for companies that already are hosting their ERP system and that want a true web-based reporting experience. Solver plans on releasing BI360 Web Reporting in the summer of 2012.

About Solver

Solver provides BI360, the leading Business Intelligence suite for Microsoft Dynamics AX, GP, NAV, SL, Sage MAS 500 and X3, Epicor Prophet21, and other ERP systems. Solver is a Microsoft Gold ISV Partner and the winner of the Microsoft BI Partner of Year Award. BI360 is sold through a world-wide network of resellers and is ideal for companies looking to find a user friendly, yet highly functional Reporting, Budgeting, Dashboard and Data Warehouse solution to give them deep insight and actionable information across all facets of their organization.

For any questions, visit Solver’s website or contact Solver at info@solverusa.com.

Binary Stream’s Multi-Entity Management (MEM) solution provides the ability to process transactions from different corporate entities within a single company database.  By utilizing a centralized database intercompany transactions can be automated and master files can be shared across entities (ie General Ledger Accounts, Customers, Vendors, etc). 
This consolidated Dynamics GP database has all the information Executives, Managers and Analysts need to review their business; the only question is how do you access this information for analysis?
Solver has recently announced support for Multi-Entity Management with BI360!  With REAL-TIME access to the consolidated Dynamics GP database, you are able to further extend the power of MEM by producing consolidated or entity specific information at the General Ledger and the Sub-ledger levels (eg. Segmented reporting, Top 20 customers, Top 10 vendors, Projects by Entity, etc).  Real-time access also increases efficiency, by not waiting for IT to update a middleware system in order for reports or analysis to begin.  Since BI360 also ‘pulls’ information directly from Dynamics GP into Microsoft Excel, you are able to produce dynamic boardroom quality reports, charts and graphs that contain a ‘single version of the truth’.
BI360 and MEM make a powerful combination for any multi-entity company.
For more information on either of these products, please contact:
Solver at info@solverusa.com
or
Binary Stream at sales@binarystream.com

In most mid-sized and larger organizations with multiple divisions, classic BI tools have never been good at satisfying both local division needs (detailed reporting, local budget models, etc.) as well as corporate HQ needs. In the screenshot below, you can see an interesting methodology where a company can install the BI360 data warehouse (DW) at each division as well as at corporate HQ and then transfer whatever interesting detail/summary they want from the local DWs to the central DW. Historically, this would often not be a feasible model when companies had to build homegrown, custom data warehouses from scratch, because it could get very expensive. With a pre-configured data warehouse like the BI360 DW however, it is very fast and low cost to install it anywhere in the organization where a data mart or data warehouse is needed. There are many other benefits with this multi-level DW architecture, including the ability to then use the same report writer, budgeting and dashboard (like BI360) technology everywhere, thus reducing training cost, license cost and more.

One of the most common issues with reports containing a large volume of data is the report run time can take a longer time than expected. BI360 Version 3.5 has a new feature that has been added to enable parallel queries so that the SQL Server can be utilized to its maximum capabilities. Once enabled, your reports will run as fast and efficient as possible and deliver improved productivity.
By default, Report Designer, Player, and Composer do not perform parallel queries. Thus, the queries are processed one by one.  However, users can enable this by setting the Maximum Concurrent Queries to a value other than 0 in the Administration Tool (under System Settings).

Executing queries in parallel can optimize performance when generating a report in the BI360 Reporting applications. The optimal number of parallel queries depends on a number of variables such as memory on the server running the SQL server, the number of processors on the server, and other SQL Server related options. In parallel processing, each query can utilize a processor without degrading the performance of the SQL Server. Thus, if there is a Quad Processor, the initial maximum value should be set to four.
A high number does not automatically imply the best performance. Dependent on the different variables mentioned above, a peak will be reached at a certain value. The peak could also be dependent on the nature of the report since the number of generated SQL Statements play an important role. A simple report that would generate only one query would therefore not experience any performance improvements by using this option. The best way to find the peak is to simply test different values and different reports.
For certain customers, they have experienced 80% – 90% increase in efficiency when generating their reports.