I am using SQL 2000 and have a virtual cube. I want to calculate a percent based on a value in one cube by a count of rows in another cube. For example, Cube1 has population by county and Cube2 has hospital admit data by patient and illness. How do I calculate the percent of 'Broken Arms' by county population?
I can get the percentage before any dimension filter (ie 'Broken Arms') is applied so I can get percent of county population that have had an illness. But when I want to look at a certain illness (ie Brokens Arms) we loose the values from cube containing the population by county.
Can that be done?
Do we need to use MDX logic?
I can get the percentage before any dimension filter (ie 'Broken Arms') is applied so I can get percent of county population that have had an illness. But when I want to look at a certain illness (ie Brokens Arms) we loose the values from cube containing the population by county.
Can that be done?
Do we need to use MDX logic?