Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
Robert_Kli
Robert_Kli
1 Post
ACCEPTED ANSWER

Pinned topic How to choose previous year by report parameter if I use TM1 source?

‏2012-10-25T08:34:53Z |
Hello,

My environment:
Cognos BI 10.1, TM1 9.5.2, Windows 2008 Server R2, CM: SQL2008.

I'm trying to build a report which will show current and previous year turnover.
The time dimesion in fact consist of two separate dimensions: YEARS and PERIODS.
Both are defined in TM1. The year dimension is simple:
Years
|_ 2012
|_ 2013
|_ 2014
I'm selecting current year turnover by tuple function:

tuple([Turnover];[Dim1];[SelectedYear];[SelectedMonth])


Where:
DIM1..N - some dimensions members;

[SelectedMonth]
is calcualted as

[Cube].[PERIODS].[PERIODS]->?pMonth?


[SelectedYear]
is calcualted as

[CUBE].[YEARS].[YEARS]->?pYear?


So I'm choosing the month and year as a report parameters, and it works fine.

Now, I'd like to get the same but for previous year. How to do it?

The

PrevMember([SelectedYear])
didn't returned expected result

[2012]
while

[2013]
was choosen.

If it will be helpfull: each YEARs dimension member has an attribute (text) PrevYear.

Can somebody suggest anything?
Regards,
Robert