OraFAQ Forum: Business Intelligence » Can a hierarchy of columns from fact table be constructed?

Home » Fusion Middleware & Colab Suite » Business Intelligence » Can a hierarchy of columns from fact table be constructed?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can a hierarchy of columns from fact table be constructed? [message #487049]

Wed, 22 December 2010 04:06

obiee
Messages: 2
Registered: December 2010

Junior Member

I deleted all references of Dimension table from the Hierarchy, and the Hierarchy now contains columns from fact table only. Now, consistency check gives another error (Dimension CustomersDim is not associated with any dimension tables ) instead of the previous error.
Inclusion of any Dimension table column revert the previous error (Internal Assertion: Condition i + 1 < numKeys).
What can be the workaround?
Can a hierarchy of columns from fact table be constructed?

Report message to a moderator

Re: Can a hierarchy of columns from fact table be constructed? [message #488786 is a reply to message #487049]

Tue, 11 January 2011 02:50

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

As far as I am aware, it's not possible to create a hierarchy based on fact columns. Hierarchies are for dimensions only.

Report message to a moderator

Previous Topic:	Values on top of each vertical bar graph
Next Topic:	Linking pivot tables in a dashboard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 03 19:50:48 CDT 2026