GP Feature of the Day
Module: Analysis Cubes for Microsoft Dynamics GP (Microsoft SQL Server 2005)
Why this feature is cool!
- Significantly improve your ability to analyze data and share the information across your organization.
- Enables you to schedule the processing of packages, using the package job scheduler, which was added to the SQL 2005 module for Release 10.0.
- Allows you to view information in the format you prefer.
- Enables you to define the ways that data is analyzed and to analyze it from multiple angles.
- Allows you to view data in a familiar Excel environment.
- CD2 will include Cubes modules for both SQL 2000 and SQL 2005 in Release 10.0.
What does it look like? (Figure 1 & 2)
Fig 1: PivotTable creation wizard
Fig 2: Resulting Excel report
