April 13, 2015 at 12:33 pm
Situation:
I am currently working on a 2008r2 Analysis Services project in which I have no control over the Data Source structure. Please do not inform me to refine the database as it is not an option.
---
Current Structure:
Table A:
Table A contains a key and some dimensions such as gender, race
Table B:
Table B contains the same keys as table A (there are duplicates of these keys, intentionally), Dates, and measures. This table has duplicate keys but unique records because the date distinguishes different times in the year a person came to our business.
---
Goal:
I am trying to create a cube in which these two tables are joined. I would like to see how many times a person of a certain gender (Table A.dimension) came into my shop for a oil change (Table B.measure) in a certain month (Table B.date)
---
Attempts:
My only success was to make an intermediate dimension that had the keys and join the dimensions to measure groups on a referenced type of relationship. Data looked good, but the size of my cube became to large because there are so many records. I was able to complete this action in Analysis Services 2000 and am unsure why it is so difficult in BIDS.
---
Can anyone please help?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply