Print Page - Period Comparison and Column Header Question / Dimensional

Title: Period Comparison and Column Header Question / Dimensional
Post by: jfitzgerald on 19 Sep 2011 09:56:28 PM

Getting a Period (month or quarter) from a prompt,
then a Calculated Member for the prior period:

[Cube].[Time].[Year]->?p_Period1?-1

How does one Print this value in a layout calc for the Header?

Title: Re: Period Comparison and Column Header Question / Dimensional
Post by: MFGF on 20 Sep 2011 06:45:59 AM

I would use a singleton instead of a layout calculation, and use the same expression.

Regards,

MF.

Title: Re: Period Comparison and Column Header Question / Dimensional
Post by: jfitzgerald on 21 Sep 2011 11:41:47 AM

I think I found the solution to this problem.

I changed the Calculated Member to a Set using the same expression (meaning the set really only contained a single member).

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jfitzgerald on 19 Sep 2011 09:56:28 PM