Skip to Content

Webi report on Essbase cube with dynamic calc members as parameters

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 14, 2013 at 05:16 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2013 at 11:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded