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