Filtering by hierarchy members
Hi,
I make SSAS project for spa and I've got problem with reports. I’ve got two categories of patients
self-payers payed by Insurance company, that has two subcategories:
a.
IC pay all
b.
IC pay only medical treatment
I’ve got three measures:
Sum of price for IC medical care.
Sum of price for accommodation. Totally different measures for self-payers
How can I create reports for it? I want to report self-payers and IC’s separately. I’ve got self-payers as special Insurance Company. I’m using ragged hierarchy here. Data of named query for dimension looks like
this .
And with hideMemberIf option, attribute hierarchy looks like
this .
Payment_Option (if IC pays all or only medical treatment) must be identified by IC, so it looks like
this .
So what is the best approach, if I want to separate reports for Self-payer patients (totally different measures for self-payers + Sum of price for accommodation) and reports for each IC? For each IC report I want to prices for each patient,
where will be IC-all (Sum of price for accommodation + Sum of price for IC medical care) and IC part will be (Sum of price for IC medical care)?
Thank you for help.
January 31st, 2011 8:21pm