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

OLAP Calculated column using Special Categories

Started by ceosp, 22 Dec 2015 07:33:16 AM

Previous topic - Next topic

ceosp

Hi!

Anyone knows how to create a calculated columns using Special Categories? Ex.:


<measure>  | <last month> | <current month> | <current month-last month>
-------------------------------------------------------------------------------
<member1> | <value11>     | <value12>       | <value12 - value11>
<member2> | <value21>     | <value22>       | <value22 - value21>
<...>


How do I calculate <current month-last month>?

Thanks, Carlos

japwah

Create a calculated member with the expression

<current month> - <last month>