I have a cube with 5 dimensions. One set of measures needs 4 dimensions while the other set needs all 5. If I build a report with the first set of measures then what memeber of the 5th dimension does the report consider. Would it be the root? How does it effect my value of the measure.
Can i have it in a way such that the measure only considers 4 dimensions and gives me the right data. For eg;g
Date Country Product Type Flag
Measure 1 is only for first 4 dimensions. Measure 2 is for all the dimensions. Essentially for Measure 1 Flag is seen as green in the scope. What is the impact if i do a tuple of Measure 1 and first 4 dimensions
If a measure is tupled with a member outside of it's scope, it will simply ignore that unscoped member.
So if you were to put both Measure 1 and Measure 2 in the context of Flag, Measure 2 would be sliced while Measure 1 would not.
consider the following pseudo MDX:
with calcMeasure as 'measure2/measure1'
select
{measure1,measure2,calcMeasure} on 0
, flag.members on 1
from cube
Even though measure1 is inside the context of Flag, it would still be showing data for all of the cube.
| M1 | M2 | CM
-----------------------------
Flag 1 | 10 | 1 | 0.1
Flag 2 | 10 | 5 | 0.5
Flag 3 | 10 | 13 | 1.3
EDIT: The measure will use the default member for the tuple, not the root. In most cases, however, the default member is also the root.
That would also be the case if we dont use a tuple right. Say my data is
Country Date Product Measure1
US 0103 P1 10
US 0103 P2 20
Country Date Measure2
US 0103 50
if i drag Country, date and measure it would be 30 in first case and 50 in second case because Product is out of scope in second right. this is MDX