Period Comparison and Column Header Question / Dimensional

[jfitzgerald]

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?

 

[MFGF]

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

Regards,

MF.

[jfitzgerald]

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).