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: OBIEE Admin Error
Next Topic: not able to install obiee completely
Goto Forum:
  


Current Time: Sun Aug 20 13:58:08 CDT 2017

Total time taken to generate the page: 0.01026 seconds