planning layout

[Former Member]

Hi ,

I want to use the excel macros to create a new worksheet from the standard sem-bps1 and have to make some calculations in it and save the data back into the cube after calculations.i am unable to find where to start and how to do it.Is the sheet which is produced from sem-bps1 wil be automatic or we have to save it.

Anybody please help me in this regard.i had gone through help.sap.com but coudnt get clear information.

thanks and regards,

chandu

[Former Member]

Hi Chandu,

Refer to the sections

"Creating New Sheets" and

"Influencing System Behavior with Macros" in the below link

http://help.sap.com/saphelp_sem40bw/helpdata/EN/d6/b13edf8b8211d3b7360000e82debc6/frameset.htm

Hope it helps