Home » Fusion Middleware & Colab Suite » Business Intelligence » Can a hierarchy of columns from fact table be constructed?
icon3.gif  Can a hierarchy of columns from fact table be constructed? [message #487049] Wed, 22 December 2010 04:06 Go to next message
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?
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 Go to previous message
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.
Previous Topic: Values on top of each vertical bar graph
Next Topic: Linking pivot tables in a dashboard
Goto Forum:
  


Current Time: Thu Mar 28 06:24:05 CDT 2024