Question:
We are on BW 2.1. I need to display the columns on a report in the following scenario:
If I run my report for, where in selection screen , year = 2004 the columns in the report should be:
Column 1: Plan amount 2004 ( first column displays the year the report
is run for)
Column 2: Plan amount 2005 ( column 1 + 1 year)
Column 3: Plan amount 2006 (column 1 + 2 year)
If I run my report for, where in selection screen, year = 2005 the columns in the report should be:
Column 1: Plan amount 2005 ( first column displays the year the report
is run for)
Column 2: Plan amount 2006 ( column 1 + 1 year)
Column 3: Plan amount 2007 (column 1 + 2 year)
How do I do this? Please explain in detailed steps....I am new to BW.
Thanks a bunch!
Answer:
You can use restricted Key Figures..
create 3 Restricted KF
the KF1 will be restricted to the Year variable
the KF2 will be restricted to the Year variable but with offset = 1
the KF3 will be restricted to the Year variable but with offset = 2
Hope it helps you.
MM
Answer:
There were two things that I had to do.
1. Create the KF's as suggested in the previous post.
2. Create a text variable to be able to have the column names reflect the fiscal year.
Thanks a lot for responding back.