hi,
I have a question with multiple fiscal years. we have multiple hospitals and each hospital has different fiscal year.
for example hospital number 420 fiscal year starts with 09(September) and 410 starts with 10(October) so on..
I need to get the discharges for a hospital based on fiscal year
for hospital number 420 I have filter below:
[Business View].[performance Call].[fiscal year Month] between
cast(cast(substring(?yearmo?,1,4),integer) -1, varchar(10)) + '-09'
and ?yearmo?
in below [fiscal year Month] column is for example 2017 - 07 which data type is character not as date.
for this filter when I run the report for 2017-07 my report runs from 2016-09 to 2017-07
so my question is how to make this filter to run for all hospitals where fiscal year as 10, 11 so on
please share your ideas if helps me a lot..
I don't really get what you try to show. Consider you can best describe what you want to show, for instance in a user story format.
As for your issue, the first thing that comes to mind to me is to make the start month of the fiscal year an attribute of your hospital dimension. Then you can make your filter based on that attribute value.