We are trying to create hierarchy for one of the dimension which contains 10 LTSs, each LTS represents Bridge-->Dimension join in physical layer. So, each LTS contains inner join between Bridge and Dimension tables.
We performed the following.
Right click on Dimension and select Create logical dimension--> Dimension with Level-Based hierarchy.
The error is "Admintool is unable to create the structure for the dimension <<Dim name>> "
Can anybody help..
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.
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.