OBIEE, OBI Apps, ODI, Informatica, Essbase, BI Publisher...you name it. The OBI suite entails them all and more.
I will talk mainly about its technical aspects, interesting findings and noteworthy solutions, but will definitely throw in some random weirdness.

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.