If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Measure value with only subset of dimensions

Started by dssd, 15 Jan 2013 10:35:40 PM

Previous topic - Next topic

dssd

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

CognosPaul

#1
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.

dssd

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