Hi,
I have data based on calendar year (Jan to Dec) /Calendar Month in my SQL server database i.e. I have sales revenue stored by calendar year and Calendar Month wise in the fact table.
But the user wants to see the sales revenue on Fiscal year which spans from Apr to Mar. How can in convert the calendar year to Fiscal year /Fiscal Quarter and Fiscal Month at Universe level as i need to give the drill down functionality too .
your kind response is awaited.
Thanks,
Charu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.