Ryan1 (6/18/2014)
Koen Verbeeck (6/17/2014)
The views being what they are, you can only create 1 dimension which holds all the attributes of view 1.I figured as much, but how does one do this?
As you would create any other dimension and measure group in SSAS.
Record key is the surrogate key for the dimension.
When you create the dimension, you simple select all fields from view 1, with record key being the key column.
When you create the measure group, you select all fields from view 2, except the date field.
In the dimension usage tab, you link the measure group to the dimension by using a regular relationship, where recordkey of view1 equals record key of view 2.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP