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.