This content has been marked as final. Show 11 replies
I don't see this that would make it snowflake more like what I think as conforming dimensions. You need to make sure the grain of the measures is at what level , the they are same grain then you should be good however if they are different then you would start seeing null values.
Fact Measures use the same, conformed dimensions like Dim1 and Dim a if you trying to generate from multiple facts, the BI server was able to automatically stitch them together into a single result set. If they came from the same fact table that's easy as its only one single table, but if you are pulling from different fact tables, the conformed dimensions would allow them to be stitched into the same report
Conformance means that these sources can be mapped to a common structure – the same levels – and also the same data members.
Mark if helps.
@SSVS - Hi, thanks for your inputs.I always thought that if I would be connecting Dim1 to fact 2,that would be the scenario for conforming dimensions....Please can you clarify on this?
@DNK - Hi NK, Do you mean I can link dim1 and dim a in physical layer and then just add dim 1 as an LTS for Fact 2 in BMM layer? Thanks for your reply.
Not Sure What exactly you wanted to achieve
I guess You are trying to pull columns from from all tables F1,F2,Dims a,bc,123
U might be getting some Nulls right?
If you have above said situation let me know I will explain u.
Answer for ur question is
Dim1 can be joined to dim A if they have keys in common.
Go to dim1 LTS in BMM Add table dim A
and any way you will have join from Dim1 to Fact(Dim-Fact Relation ship)
How BI Server parses the SQL if you pull columns from Dim1,DimA,Fact is
Dim1.Akey=Dima.Akey and Dim1.Bkey=Fact.BKey
Hope this Helps
Edited by: DNK on Mar 22, 2013 9:38 AM
Edited by: DNK on Mar 22, 2013 9:42 AM
Sorry for not being too clear before...
I actually have to join both dim1 and dim2(part of f1) to dim a(part of f2).
dim1,2,a are present as seperate dimension tables in my BMM layers.I have defined both the joins in Physical layer.now, to maintain star schema, I just need to add dima as an LTS in either dim1 or dim2?Do I need to make any other changes in BMM as well?
Thanks DNK, the links were quite helpful!
My report selects data from F1,D1,D2,D3,DA only...doesn't involve F2 at all....now as per the join conditions D1,D2,D3 join to F1 and DA joins to D1,D2.So all the tables are now joined to fetch correct data.Also, I have defined DA as an LTS in D1 in BMM.I guess no need to add DA in LTS for D2 now?