Capstone's Management and its Consultants represent a diverse skillset of technology and Business
Capstone helps utility client consolidate reporting applications
The Need
Convert all the existing Business Objects reports 6.5 into Hyperion 8.3 reports to enhance reporting capability and user experience. .
The Solution
- Created a metrics chart to split the Business Object Universe into Hyperion data model. Created the mapping document to convert all the tables,alias, joins, business formula into Hyperion format.
- Converted all the Business Objects 6.5 reports into Hyperion 8.3 reports.
- Converted Business Object Universe into 7 data models. The 7 data models add value in terms of creating efficient reports, avoid query loop and allow users to query multiple facts at a time.
The Result
- Timeline is the major gain for this project. Converted around 72 reports including 7 data models with end to end testing and support.
- The Hyperion data models were an added value, that can be used in future ad-hoc reporting and in future development.
- Educated the client/users to use the Hyperion tool. Also, provided suggestions and solution for various complex client/ users questions.
• Consolidation of Reporting Tools