Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ceosp on 22 Dec 2015 07:33:16 AM

Title: OLAP Calculated column using Special Categories
Post by: ceosp on 22 Dec 2015 07:33:16 AM
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
Title: Re: OLAP Calculated column using Special Categories
Post by: japwah on 30 Dec 2015 09:04:43 AM
Create a calculated member with the expression

<current month> - <last month>
Text only | Text with Images