In AdventureWorks sample. considering Fact "Internet Sales" and "Date" dimension, now there are 3 columns in "Internet Sales" Fact table ShipDateKey,OrderDateKey and DueDateKey which are mapped to DateKey column of Date dimension.
My question is if i drag and drop any measure from Internet Sales and use Date dimension on rows then how SSAS answers query result and which fact and dimension column relationship it use. i.e. which column amongst 3 i.e. ShipDateKey,OrderDateKey
and DueDateKey it will use for response.
View Complete Post