Hi

I have a facttable which looks like this (simplified)

Id Dim1 Dim2 Measure1 Measure
1 M A 100
2 M B 200
3 V A 50

Measure1 is changing over both dimensions but Measure2 is only changing for Dim1

I created a cube with only Measure1 in it which just is a aggregates with sum

I wanted to create a second cube for Measure2, because of the granularityproblem
The problem I have is how do I get Measure2 not summed up for Dim2 but just take the non-changing lowest level value

I tried to set the 'all'-level of my Dim2 to one of my lowest level members. This works fine in the second cube but when I combine both cubes in a virtual cube this doesn't work anymore because than one dimension is two different kinds of 'all member'-formulas

Has somebody an idea how I solve this

Thanks
Edwin.

When you create separate cube for Measure2, simply don't include Dim2 in it
at all - i.e. you will have just Dim1.
Then virtual cube should just "magically" work.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Edwin" <anonymous (AT) discussions (DOT) microsoft.com> wrote

a virtual cube this doesn't work anymore because than one dimension is two
different kinds of 'all member'-formulas.