Skip to Content
0

Reporting on Fiscal Year In Webintelligence

Oct 05, 2017 at 07:20 AM

15

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers