on 2006 Feb 20 9:41 AM
Hi Experts,
What is offset variables...?
where it is used..?
and how to define this one..?
give fulll details with an example.
Thanx in Advance.
Vasu.
Hi,
First I shall start will the example -
I need a simple report say -
Customer, Product, Current yr sales, prev yr sales, prev to prev yr sales, prev to prev to prev yr sales.
so I want to see like this last five year.
For this kind of reporting I shall be usind Offset variables, see how do I get these sales key figures-
1. KF1 - 0Sales Key figure + time Variable restricting it to current year (2006).
2. Prev year - KF1 offset variable qith "-1" (minus 1)
3. prev to prev year - KF1 offset variable qith "-2" (minus 2)
Similarly for other years as well.
How to define it - create a new key figure - by right click on KF section in BEx & choose "New Selection" -- now take 0Sales (KF) to right & Time ( year in this case) to right, set value to time as current year
Define another Key figure as mentioned above & right click on variable by "-1".
it should help.
regards
VC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Offset variables are used in reporting.
Example:
You have created a variable for fiscal year period. The user enters the fisacal year period, say 001.2006.
now in the report you need to show data for 001.2005 also, them on the variable created you can set and offset (variable -1) where it will fetch data for 001.2005. Like this based upon single variable value you can set offsets for diff periods to get data for diff periods.
I hope this will help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.