I have a fact table which describe the disease student¡¦s number of each
gender in grade,

There two measures, DisNum is the disease student numbers of each disease
like Fever and Cough, StNum is the student numbers of each gender in each
grade



Grade Gender Disease, [DisNum] [StNum]

----------------------------------------------------------------------------
---

1 M Fever 12 50

1 M Coughr 2 50

1 F Fever 13 60

1 F Cough 12 60

2 M Fever 11 55

2 M Cough 14 55

2 F Fever 25 53



When I roll up to grade, the DisNum is aggregated with sum, but the StNum
must sum with distinct Grade Like

Grade Gender Disease, [DisNum] [StNum] [DisRate]

----------------------------------------------------------------------------
---



1 49 50
49/110



1 M Fever 12 50

1 M Cough 2 50

1 F Fever 13 60

1 F Cough 12 60

2 50 108
50/108

2 M Fever 11 55

2 M Cough 14 55

2 F Fever 25 53



How can I do with the sum of [StNum]?

Since [StNum] is not dependent on the [Disease] dimension, it should
ideally have a separate fact table, without the [Disease] column (a SQL
view would work for this purpose). Then 2 separate cubes could be built,
one with [DisNum] and the other with [StNum] measures. These 2 cubes
could be combined in a virtual cube with both measures.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank very much,
Are there any example about virtual cube which combined from two cube?

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com>
???????:uijNLLlsEHA.2300 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

The sample Foodmart database includes a Virtual Cube:
"Warehouse and Sales"

Here is some [MS] documentation on virtual cubes:

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agcubevarieties_7j8z.asp


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!