3 Replies Latest reply on Feb 1, 2010 10:50 AM by Christian Berg

    Issue in integrating Essbase cubes with OBIEE

    sandy45252
      Hi

      I am trying to use Essbase cubes as datasource in OBIEE for generating reports,but the issue is in generating , No columns in fact table of cube in BMM layer.
      Outline of cube is
      Revel(cube)
      (Hierachies)
      Time Time <5> (Label Only)
      Item <54> (Label Only) (Two Pass)
      DepInst <20> (Label Only)
      SFA_Flag <2>
      Deduction_Flag <2>
      Rating_Category <6>
      PD_Band <9>
      Product <17>
      Entity <4>
      CR_Agency <5>


      I am confused how to generate reports without measures in fact table.

      Regards
      Sandeep
        • 1. Re: Issue in integrating Essbase cubes with OBIEE
          Christian Berg
          Is this you issue? [http://hekatonkheires.blogspot.com/2009/08/essbase-cube-imports-do-not-correctly.html]

          Or did you just not specify any measure hierarchy?

          And a friendly suggestion: OBIEE/Essbase is NOT a piece-of-cake. You should read up on the available documentation and information before starting.
          • 2. Re: Issue in integrating Essbase cubes with OBIEE
            sandy45252
            Hi Berg

            My issue not exactly the same as listed in link :http://hekatonkheires.blogspot.com/2009/08/essbase-cube-imports-do-not-correctly.html

            I have tested in my client and server i am not getting the measures.When i drag the cube into BMM layer its splitting into facts and dimensions. After looking in the dimensions i realized that all calculation part (measures) they built it has Dimension(name:ITEM),so i am unable to see measures in fact. In BMM layer i made this dimension as fact and tried to create reports but not use. Suggest me any ways.



            Regards

            Sandeep
            • 3. Re: Issue in integrating Essbase cubes with OBIEE
              Christian Berg
              Hi Sandeep,

              in that case it's as I thought:
              Or did you just not specify any measure hierarchy?
              You tried this...
              In BMM layer i made this dimension as fact and tried to create reports but not use.
              ...which isn't the way. First of all your cube seems to be built quite bizarre since it doesn't even provide a default measure hierarchy so I'd have your Essbase guys check that.

              As for the OBIEE side: the key is the physical layer. BMM's already too late. In the physical cube object, you must define one of the hierarchies as the measure hierarchy (since your cube doesn't seem to provide it; see above):

              [http://hekatonkheires.blogspot.com/2010/02/obieeessbase-how-to-handle-missing.html]

              Cheers,
              C.