Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 6 dimensions and 2 measures in the policy table. And have to create an adhoc report on that. Also need to show only current fiscal year data in report. Please suggest senario for that.
Not clear what your exact requirement is.
Why not use set analysis in your expressions to restrict it current FY?
please elaborate with screenshots and some sample data
If Dilip's suggestion helped you, please be sure to give them credit by using the Accept as Solution button. If it did not, please provide further information, so we may try to assist further, and if you did figure out another solution, please consider documenting that and marking that as the accepted solution, so others can learn from it.
Regards,
Brett