November 24, 2014 at 2:24 am
Hi. I would be very grateful if someone could help me with this issue.
I have an SSAS cube with two fact tables - one that lists complaints and one that lists sales. I can then calculate a complaint rate by dividing the number of complaints by the number of units sold.
I have a dimension (complaint category) which has a regular relationship with the complaints fact table and "no relationship" with the sales fact table. This means that I cannot see any complaint rates when using the complaint category dimension - only the complaint rate of the total row:
Row Labels | Complaints | Units Sold | Complaint Rate
-------------------------------------------------
Cat A | 100 | <blank> | <blank>
Cat B | 200 | <blank> | <blank>
-------------------------------------------------
Total | 300 | 10,000 | 3%
I would like to show the total units sold against Cat A and Cat B and calculate the complaint rate accordingly when there is no relationship. Something like this:
Row Labels | Complaints | Units Sold | Complaint Rate
-------------------------------------------------
Cat A | 100 | 10,000 | 1%
Cat B | 200 | 10,000 | 2%
-------------------------------------------------
Total | 300 | 10,000 | 3%
I think I could do this with a many-to-many dimension but that seems very inefficient. Is there an easier way to do this?
Thanks!
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply