Hi Guys,
In one of the queries, I have time-characteristic 0FISCPER (restricted on 0I_FPER variable) in the columns section. I have few key figures in my rows section of the query. When i executed the query (filter char. - Fiscal year variant restricted to July - June, 4 special periods i.e. V6), i get separate columns for each month as required. On execution, the following output appears (with user-entry values for 0FISCPER being 001/2005 - 012/2005):
July 2005 August 2005 ..... June 2005
The output i am expecting is:
July 2004 August 2004 ... June 2005
I have problem only with the column description. The data appears correctly. i.e. Data for July 2004 appears correctly but with heading July 2005 instead of July 2004. I created text variables on 0FISCPER for all the months of 2004. But no help.
Any help will be greatly appreciated.