Hi,
I have a Time Dimension on my cube like this.
Year
Term
Quarter
Month
I am creating a Summary Report. My requirement is that when I run the report, my cross tab summary report should show Monthly data for the current Fiscal year.
Example: If I run the report on Feb 23, it should display data for the Fiscal Year 2008 with months starting from 2008 April to 2008 Feb.
Can one anyone suggest me on this.
Let me know if you need some more information.
Thanks,
Gicy