This content has been marked as final. Show 6 replies
You have to go with Alias for any of dim table, that would avoid circular joins
ok, But i need to join Lines table with 2 more leaf tables. it's like a snowflake schema
See we get snow flake in Physical layer and if you follow best practices you wont get the same in BMM layer.
You going to map them physically or going with Mulitiple logical sources in BMM.
hope this helps, if helps pls mark.
i have done MLTS, but i am able to join one dim and Fact,the second dim i am not able to join with fact
you model your physical joins (using aliases for self joins if necessary) to align with the reality of how they join - a snowflake in your case.
You then flatten the snowflake into a star in the business model layer by bringing your dimension which is remote to the same logical table as its nearest join, hence your logical table will have two physical sources.
Hope this helps,
If i am creating Aliases i am getting extra records in my report.