Wednesday, October 10, 2012

[Hyperion] Creating Database Connection


Creating Database Connection with Essbase

You required one Grid to view report. When insert grid in to report, you need to build database connection.  




 

Click “New Database connection”

Select database type “Essbase”





Enter Database connection name and search for the application you want to use.

Once all settings complete click ok.



Once connection build successfully click ok...

 


Creating Simple Report

Once Grid is connected with the database. You will have all available Dimensions in POV and attribute dimensions in separate group box. You can create MDX query by using all available dimension.




Drag and Drop the dimensions in the required fields.

Select pages, columns and rows fields.





Sample Product Sales Report Web Preview



No comments:

Post a Comment