2 Replies Latest reply: May 7, 2012 10:06 AM by user8783298 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
          Satya Ranki Reddy
          Hi,

          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

          A. In OBIEE we have two option,

          Right("s124",3)

          The out put like 124

          Or

          Use substring function -- substring(your column value from 2 for 4)


          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

          A. Can please explain some more extend with anothe example am not getting your requirement.


          Hope that help's

          Thanks,
          Satya
          • 2. Re: Essbase Integration with OBIEE
            user8783298
            Greetings,

            Thanks for the reply.

            Right or Substring function are not working on Essbase Dimension members.

            We have a ragged hierarchy in Essbase. The dimension members in a hierarchy are not symetric. We have different levels in each Hierarchy as mentioned the example of previous post.

            When you import the cube in OBIEE, it comes as Generations. However, we need to report on Level 0 Members of the Hierarchy.

            Is that possible?

            Thanks,
            SN