Print Page - How to Find the previous Fiscal Period?

Title: How to Find the previous Fiscal Period?
Post by: sg on 10 Jul 2009 10:03:17 AM

Hi,

I have a FISCAL PERIOD PROMPT in my report with the values 2008 FP1,2008 FP2 upto 2009 FP9 . Now i need to remove the prompt and when i run the report it should show by default the previous fiscal period as 2009 FP9.

I have a dimension called "INVOICE.DATE" and hierarchy "INVOICEDATE.FISCALPERIOD"

Any help in this regard would be highly appreciated. Let me know if any more information is required.

Thanks,
Sg

Title: Re: How to Find the previous Fiscal Period?
Post by: cschnu on 13 Jul 2009 01:52:32 PM

Use the Maximum Aggregate function and then minus 1

If you want to have it only be the default selection to run the report I think you will have to look into javascript, because i don't believe you can make a default selections from an expression.

Title: Re: How to Find the previous Fiscal Period?
Post by: sg on 14 Jul 2009 01:33:19 AM

Thank you very much for the reply. I will try doing the same.

Thanks,
Sg

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sg on 10 Jul 2009 10:03:17 AM