Ryan1 (6/17/2014)
Attached is what my dimension usage tab looks like.Gender, Automobile, and Customer is from view one which contains only data that is directly linked to dimensions.
Dates is a dimension in table two. View two contains many columns of measures(SUM).
Glancing at this I would say that table one should be on this tab however it seems as if the data is having issues only with measures. Any help is greatly appreciated. Thank you.
Apart from Dates, not a single dimension is linked to your measure group. Click on each gray box, set the relationship type to regular and specify the granularity and on which keys to join.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP