cancel
Showing results for 
Search instead for 
Did you mean: 

Insert rows and columns

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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