SQL Reporting Services
Analysis Cubes for Microsoft Office Excel
This is a core component of the GP financial system which leverages the power
of SQL Server. It helps you to define and extract key data and present in an
easy to analyse mode to enable accurate, strategic decision-making.
Predefined library of OLAP (On Line Analytical Processing) data cubes allow you to
"slice and dice" valuable data held in Dynamics GP by any dimension you can imagine, such as time, product group, region, GL code, employee, department, sales, GP
and so on. It is particularly useful for sales and purchasing analysis, and is also excellent for cross-company reporting.
By sharing and increasing transparency of financial information via the Business
Portal compliance with regulations, such as Sarbanes-Oxley, can be distinctly
improved.
