Mapping fiscal year/ period to 0BILL_DATE at query level
There are two existing reports which are based on two different infoproviders.
In one cube 0fiscper is mapped to 0BILL_DATE and another cube 0fiscper is mapped to 0CREATEDON.
Fiscalyear variant is : V3 ( Apr - Mar )
There is one debit memo request in R/3 , in which " Created on " date is 01.10.2007 comes in Fiscal year/period ( 007.2007 ) and " Billing date " field is 28.09.2007 comes in Fiscal year/period ( 006.2007 ).
when user execute these reports , obviously same information abt this document fall in different fiscal periods because of the mapping at cube level.
Users want me to change one report in which fiscal year ./ period should also refer to " Billing date " so both reports shows the doc information in same period.
If i change this at cube level will effect too many other queries depending on this cube.
How can i achieve this at query level?
Message was edited by: