SSAS sharing confirm dimension ACROSS MANY FACT TABLES

Hi All,

I'm building a SSAS cube for a large energy company which has more than million records in fact tables.
I have Date dimension and Customer Dimension.

These two dimensions are confirm accross four measure groups. the two measure groups granualarity is 'Year_Month' and other two granualarity is day.

Now after adding all the measure groups together, I'm getting so many attribute key errors - more than 10000 errors, however, the attribute keys available both fact and dimension tables.

Why this behavior. please help to sole this issue.

thanks
keplanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
keplanConnect With a Mentor Author Commented:
If I built the hierarchy (calendar) that I have lowest level is date, but  two fact tables lowest level is year month. How does I restrict this to drill further from month to date for those measure groups.
0
 
keplanAuthor Commented:
any help on this please
0
 
keplanAuthor Commented:
may be NULL or not matching attribut keys as many fact measures?
0
 
Ryan McCauleyData and Analytics ManagerCommented:
Is there a specific error you're seeing? Also, can we get the table schema layout? I don't see a problem with this - we have a shared calendar and different measures use different granularity without issue - so I'm not sure what specific problem you're seeing.

Attribute errors would occur with a value in the fact table doesn't have a matching key in the dimension table - are you sure the columns your joining on have data that matches exactly?
0
 
keplanAuthor Commented:
xd
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.