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

Simple question from newbie

Started by Ister, 24 Jun 2014 02:53:56 AM

Previous topic - Next topic

Ister

Hello!

I have Dimensional Model in Report Studio, there are 1 dimension and 2 Measures ([Measure 1], [Measure 2]).
There are such elements in Dimension: [Element 1], [Element 2], [Element 3], [Element 4].
And I need to create calculated measure which will use [Measure 1] for [Element 3] and [Measure 2] for all other elements.

I tried that way: if [Dimension] = [Element 3] then ([Measure 1]) else ([Measure 2])
but it doesnt work.

Thanks!