November 14, 2011 at 10:34 am
I'm having a heck of a time with this one. Each of our doctors (providers) has a panel of patients who are assigned to them. They also see patients who are assigned to other doctors. Each month we want to show:
1) how many patients were assigned to them
2) how many encounters they had (for their patients as well as other providers)
3) how many patients they saw (the encounters above)
In my DSV I have a FactEncounter table, and DimPatient, DimProvider, and DimDate tables.
FactEncounter -> DimPatient, DimProvider, DimDate
DimPatient -> DimProvider
For #1 above the patients assigned to them must have been seen by someone within the time period.
I'm not sure where I'm going wrong but I can never get the numbers to come out right.
November 14, 2011 at 11:00 am
Can't help without seeing the code.
And since this is most likely mdx, can't help at all.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply