Skip to Content
avatar image
Former Member

Reporting on Fiscal Year In Webintelligence

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers