Non-conforming Dimensions modelling
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