End
Analyst Budgeting Solution
Distributed
Budget
Workbooks
GL
Analyst
Database
Write Back
Author builds
Budget Template
Workbook
Generator
Datamart
Generator
Data
marts
Analyst Reporting improves the financial and management reporting process as follows:
1.
Universal Filter
Automates generation & maintenance of financial data warehouse
Includes non-GL data
Transaction load
Summarises accounting balances
Scheduled process
2. Benefits of DMG
Can be scheduled to run after hours
Can run datamart per department
Can work offline from main database
Security
Access / SQL
Summarise or limit contect ie allow people to only view some of the a/c parts
History / archiving uses
2.
Financial Data Warehouse (Reporting Database)
Based in MS SQL Server RDBMS
Can incorporate data from multiple data sources
Has a multidimensional format
Is able to hold multiple data versions
3.
Analyst Author
Creates reusable templates
Wizard-driven template design
Self-maintaining format
Full use of Excel formatting
Full use of Excel charts and graphics
4.
Analyst Reporting
Creates Excel reports
In-built accounting intelligence
Variance analysis
On the fly calculation
5.
Report Delivery
Excel report
Workbook Generator
Analyst Web Reporting
Optional OLAP analysis using MS OLAP Services
6.
Data Mart Generator
Creates tailored data marts
MS SQL Server & Access
Summarise reporting structures
Scheduled process
Clone original database
7.
Analyst Manager
Reorganise reports by adding rollups
Add new dimensions to database
