Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jojo_jacob
Starting Member
24 Posts |
 Posted - 2004-05-12 : 08:52:22
|
| I have a measure which is only at a higher level of the hierarchy. For example, Level1 -> Level2 -> Account dimension has a measure at Level1 (which can not be allocated to the lowest granularity). Also, this dimension is a Parent-Child. How can I build a cube which refelects both the measures (at the least granularity and and at the higher level)? The idea of a Virtual Cube is also welcomed. Thanks. |
|
|
|
|
|
Measures in different granualrities