Webi report on Essbase cube with dynamic calc members as parameters

[manish_umarwadia2]

Hi Experts,

     We are trying to create a webi report on a Essbase cube in BI 4.0.We installed the Essbase client and created an OLAP connection and a business layer on top of it.We saved it as an .UNX universe.The connectivity works fine without any errors or issues.

     When we use this universe to pull data, we are getting data for the parameter members which are configured as 'stored' members and we don't get any data for the parameter members which are configured as 'dynamic calc' members. But whereas in the Excel Add-in which connects to the Essbase DB , we get data.

     Our question is can Webi pull data for the 'dynamic calc' members or not? or is there anything we are missing.Please assist.

Thanks!

[marc_daniau · Accepted solution]

The Essbase demo cubes that comes with Hyperion have dynamic calcs in their outline. The UNX universes work fine against those cubes. Let us know if your outline have something specific.

[Henry_Banks]

Hi,

I've moved this question to the Semantic Layer forum as i think this will be more fuitful.

I haven't checked these documents for relevance to your problem exactly, but there are some excellent Essbase UNX use-case document (linked below) that may go some way to helping answer your issue.

http://scn.sap.com/docs/DOC-21193

http://scn.sap.com/docs/DOC-29733

https://scn.sap.com/docs/DOC-33077

Regards,

H