Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Degenerate Dimension

BIDeveloperNov 22 2010 — edited Nov 23 2010

While performing modeling in BMM layer I am hitting an issue.

I have two fact tables Revenue and Charges. Both has Sales Order Number as common column (Sales Order Number) is available in both the fact tables.

Now I want to create a report across both the fact tables.

The approach I am taking is to first create common degenerate dimension from both the fact tables (Sales order Number column is mapped to both the fact tables.
But when I try to create a dimension hierarchy by right clicking on degenerate dimension it throws an error saying 'AdminTool is unable to created a structure for dimension'. I believe this is because Sales Order Number is not unique in any of the fact tables.

Desired model should be able to use Sales Order Number across both fact tables.

Thank you,
DP.

Edited by: BIDeveloper on Nov 22, 2010 4:53 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2010

Added on Nov 22 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

3 comments

963 views