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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics