Monday, February 1, 2010

OBIEE/Essbase: how to handle missing facts

A question which I never covered in my blog yet since it was too basic and should normally work at all times when you import an Essbase cube:
How do I get a fact to display in the BMM layer after importing a cube?

The question came up here and basically has its origin in a bizarre cube outline. Correctly defined cubes will never face this (and hence no one covered it yet, though I already spoke about changing the measure hierarchy).

Let's look at an import without a working "fact" (in OBIEE terms...).



No fact columns...but why? Let's open the properties of the physical cube table and check the properties of the hierarchy "Account" (my measure hierarchy).



Now that's just wrong. The "fact" must be the measure hierarchy. Let's change that.



Better. Now we're still missing the actual fact columns (i.e. the members of the measure hierarchy in the Essbase outline.). In my case that should be Costs, Gross Sales, Net Sales, Returns and Sales.




Repeat that for the other four.



Now drag-and-drop the whole thing to your BMM layer.



Done.

No comments:

Post a Comment