1 Reply Latest reply: May 7, 2012 7:06 AM by HyperionNewbie RSS

    Essbase Integration with OBIEE

    user8783298
      Greetings,

      We are trying to integrate Hyperion Essbase with OBIEE.

      In OBIEE do we have an option to split the member name. For example "S124"
      should be "124" and "S" should be ignored in the reports

      In OBIEE do we have an option to get all the Level 0 members (bottom of the
      hierarchy). We cannot use Generation here. Please see the example

      Store
      ....East
      ..........MI
      .............S124
      .............S157
      ..........Fl
      .............S230
      ....West
      ..........S450

      We want a report for all the stores. They are not at the same generation here.

      Thanks,
      SN
        • 1. Re: Essbase Integration with OBIEE
          HyperionNewbie
          Hi,

          OBIEE with Essbase has lot of work arounds and it is not straight forward for complex requirements.
          It is better to check your question in OBIEE forum, but to my knowledge you have an provision to show level 0 members which can pull you level 0 data in the final layer.
          Also there are functions which can split the member names by character count. Else you can ignore it on final column in your reporting. How about using an Alias option ?

          Hope this helps.