This content has been marked as final. Show 3 replies
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.
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.
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):