I have 0FISCPER(Fiscal Year/Period) in my Data Columns.
Please correct me if I`m wrong, but I`d need to have another variable to capture the Fiscal Year as well right ?
So, is it possible for me to create a Fiscal Year variable and put it in the Header so, user can just nagivate the years using the Header and the appropriate Fiscal Year/Period(Variable 0FISCPER) will follow ?
I don't think it is possible. Fiscal year/period and Fiscal year are two different characteristics and have different variable values. It is not possible to pass values between the two.
From what I understand you want something like
Fiscal year 2005 or 2006 and so on and based on the year selected you would like the values of the sub columns of
Fiscal year/period to change to Nov 2005 or Nov 2006
which is not available as a standard feature in BW.
Since the variable on 0FISCPER is of type Fixed Value, it needs to be maintained by an administrator at the Planning Area(not by every user). This is quite common in BPS.
Alternatively you can use variable type User Exit. Here you can use ABAP code to take the period from system date.
Hope this helps.