Fiscal Year Time intelligence filter

Hi in my multidimensional Cube I am using a Year-Week-Day Date Calendar hierarchy.

I need to create a Fiscal year calculation from June to end of May.

I could use something like (year-1).day+??:year.day+?? but this wouldn't work for when there is a leap year.

Does one have a Time Intelligence formula that would be able to handle a fiscal year for a Year-Week-Day Date Calendar hierarchy.

Thanks

April 1st, 2015 3:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics