on 06-16-2008 11:01 AM
Hi Experts,
I am specifying a variable offset -2, for the Variable 0I_FPER , Now I want display the previous periods data
also in query , How can i do that
Eg: Var (0I_FPER) X = 003.2008
X-1 = 002.2008 X-2 = 001.2008
now I want to display like below
X-2 X-1 X
001.2008 002.2008 003.2008
Can any body help me....
Thanks in Advance......
Regards,
Nagamani
Hi Nagamani,
Create three different resricted key figures.
Restrict 1st figure with your key figure + variable of 0I_FPER
Restrict 2nd figure for Key figure + variable of 0I_FPER - 1.
Restrict 3rd figure for Key figure + variable of 0I_FPER - 2.
Thanks
Dipika
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dipika and Venkat,
Thanks for your Quick Reply,
Problem has been resolved...
Regards,
Nagamani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here to use variable offsets you need to have period and year objects seperately. Otherwise the offset doesnt work properly. Try to have period and year objects seperately, else you can use a customer exit to get the desired results.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.