This content has been marked as final. Show 4 replies
Give it shot by this doing this.
1) Disable all LTS except 1 then create hierarchy.
2) Create a new logical dimension in the BMM say DimensionXYZ. add your original dimension attributes as a derived attributes into DimensionXYZ. Now create a hierarchy on this newly derived DimensionXYZ.
How BI server can understand ,if you add 10 physical tables in the logical tables.OBIEE is saying we create one hierarchy to one table only..
mark if helpful/correct..
I tried both options.
First option working fine.
Second option also working.
Can't we create hierarchy if we have multiple LTSs for the dimension table?
Here we have created 10 LTSs for supporting 10 bridge tables. We are joining same dimension table with multiple bridge tables in physical layer. And each bridge is joined with corresponding fact table. when id comes to BMM layer, we created single dimension which contain LTSs for each bridge table, and we joined the dimension to fact.