Skip to Main Content

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!

Non-conforming Dimensions modelling

Andy NierhausApr 19 2013 — edited Apr 19 2013
Hi

I am using BIEE version 11.1.1.6

I am struggling to model a situation where I do have 2 fact tables F_1 & F_2 and 3 dimensions D_1, D_2, D_3
D_3 is the only conformed dimension

D_1 is only connected to F_1, D_2 is only connected to F_2.

Content levels for measures in F_1 are set to Total for D_2.
Content levels for measures in F_2 are set to Total for D_1.

In Answers I can't create a report where I filter on one or both of the non-conformed dimensions.

I assume it's still possible to use non-conforming dimensions in analysis
and filter the analysis on values from the non-conforming dimension? (The part of the analysis that can be filtered by these values, measures not connected to the non-conforming dimension will of course not be filtered).

Are there any rules to follow in 11.1.1.6 modelling non-conforming dimensions besides setting measure content level to Total for the non-conforming dimension?

Thanks for your help
Andy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details