January 6, 2011 at 5:41 am
Hi
Below is my scenario for a data quality report
Each distinct Account
Have different fields which has data quality issues (example; fields employee name, region name)
Data issues can be multiple error types (example; missing, invalid, inconsistent)
I would like to produce a fact table which allows sum of sales of account for different type of fields and error types.
ie. sum of sales of dimension field type and error type
Would I have to use many to many dimension?
Thanks so much
January 6, 2011 at 11:45 am
At first glance, I would say 'yes' you will. I would recommend you read over Marco Russo's great whitepaper on M2M dimensions in SSAS, it gives several examples of usage and I would think yours matches reasonably closely to at least one of them.
Steve.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply