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

How can I make two member as one? (source : TM1 / Cognos 10.2.1)

Started by ersin.gulbahar, 18 Nov 2014 06:19:13 AM

Previous topic - Next topic

ersin.gulbahar

Hi ,
I have 2 member. And I want to make them one item and calculate measures according to it. Please look at the image which is attached .

Lynn

You could try this expression for your C element.

aggregate ( currentMeasure within set set ( [A], ) )

cognos810

Hello Ersin.gulbahar,
You can use this expression to create a member..I have used A,B and C as members in your screenshot..

member(
<Measure item that you need to total>,
'C',
'C',
<HIERARCHY FOR MEMBERS A AND B>
)

Then add the set of member A and B i.e. SET([A],) in your slicer for the query.

Hope it helps,
-Cognos810