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

total (currentMeasure within set ...)

Started by ratnalein, 17 Sep 2012 09:18:02 AM

Previous topic - Next topic

ratnalein

Hallo everyone,

I have 3 data elements:

1. Top = topCount ([DataSet];?Top x?;NumExp)
2. SetForRest = except([DataSet];[Top])
3. Rest = member (total(currentMeasure within set [SetForRest]);'Rest';'Rest';[SchemaName].[DimensionName].[DimensionHierarchy])

Goal:
Top + Rest

So, my goal is to summarize Top and Rest.  My first move to do so looks like this:

total(currentMeasure within set[Top])

This will summarize the value from all the Top members

My question:
How can I additionally take Rest into it?  I tried this, but it didn't work:
total(currentMeasure within set[[Top],[Rest]])

Thank you..

Regards,
Ratna

Greg

It looks like Top + Rest = DataSet so why don't you just calculate total( currentMeasure within set [DataSet] ) ?

tjohnson3050

I agree with Greg, you shouldn't have to try and total the two sets when you already have the set [DataSet].

However, assuming you didn't, the way to do that calculation would be:

total(currentMeasure within set( set([Top],[Rest])))

It looks strange, but after you say you want to aggregate the current measure with a set, you need to provide a valid set, in this case defined by another set command.

ratnalein

Hallo Greg and tjohnson3050,

thank you for the hints, it worked with good performance.  I learnt someting -> "sometimes you have to think simple" :P

Regards,
ratna  ;)