EPMInsertCellsBeforeAfterBlock

[Former Member]

Hello,

Can someone please help me understand the use of the function "EPMInsertCellsBeforeAfterBlock", with an example?  Thanks!

Regards,

VS

[sap_user62]

Hello,

EPMInsertCellsBeforeAfterBlock : It inserts cells before or after a block of members

for a specified dimension.

For Eg: If we have Account in Rows and Time and Category in Columns.

We have all the months of 2012 in columns and in the inner column we have Category - Actual and Plan. We want to see a variance for actual and budget for each month.

                    2012.01          2012.02

Account1      Actual    Plan  Actual   Plan

Account2

Create a empty column after Plan and put the formula C2-D2(or what ever is your column) and use the EPMInsertCellsBeforeAfterBlock in that column -- giving the dimension as "Category".

Check this guide too

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

[Former Member]

Thanks for your response.  It helped me a lot.

[Former Member]

Hi VS,

This function is used when we want to add another ROW/COL  After/Before the Ranges we will use it.Other wise we can use Local Member also but this Function is great than Local Member .

use those two u can easyly understand what is the diff between EPMInsertBeforeAfterBlock and Local Member.

Thanks,

Vinos Kumar.