03 Mei 2012 7:09How can the Aggregation Type = None setting be emulated using pure MDX?
- Diedit oleh Josh Ashwood 03 Mei 2012 7:10
03 Mei 2012 15:47
Calculatestatement from the beginning of your MDX Script. Without this statement, no aggregation will take place within the cube and you'll only see data at the intersection of the leaves of every dimension, as if every measure had
03 Mei 2012 21:52
That will do the entire cube. Not just a single measure.
Can you think of a way of being able to do a single measure, using an MDX Calculated Member?
- Diedit oleh Josh Ashwood 03 Mei 2012 22:12
03 Mei 2012 22:51
I don't think you have any other choice than to scope your measure. Unfortunately, you'll probably need to have quite a few scope statements but you might be able to shorten it all using the DESCENDANTS function. something like this:
SCOPE([Measures].[Your Measure Here]);
SCOPE(DESCENDANTS([Your Dimension].[All],[Your Dimension].[Name of the leaf level],BEFORE);
--Repeat for all your dimensions
You'll have to and inner scopes for all you dimensions. I haven't tried it, but in theory, it should work
Let me know if it does!
05 Mei 2012 10:20Thanks David, using SCOPE was the approach that worked. We did end up with quite bit of code though!