on 08-31-2009 7:17 PM
Hey Team,
Heres what i'm doing to insert rows/columns..
1)for example on Time Dimension(with 4 quarters)..lets say i want to have a delta between 2nd and 3rd quarters.
2)i insert a column, name it, put the reqd formula in the first cell.
3)change the colkeyrange to exclude tht column and run the report..(have a concatenated range instead of a continuous one)
did i miss any step?
4)i expand. now i have 9 coulumns and the delta is moved to the 5th col instead of 5 columns and delta in 3rd col as i created it....the number of columns goes on increasing with "expandall"'s.
5)if i put a noexpand in the Memberset for Time..i can retain the 5 columns which i created
but with this I cannot change my year....which i want to ahve the ability to change the year.
any ideas/pointers where i might be messing up things or missing a step...
thnx
tb
Hi
This problem can now be handled with the help of multiple expansions available in input schedules.
Now you can split the ranges in EVDRE sheet.
In your example, it will be ...have multiple(4) expansion ranges for 4 qtrs and in between each qtr have some columns left for delta calculation.
hope this helps.
you can go through help.SAP.com for further material on this.
hope this helps
thanks
sridhar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.