Position Local member formula in Columns

[Former Member]

Hi All,

I hope everyone is doing great. I want to insert Total column in my report --- Report have multiple columns -- Col 1 , Col 2 and then Total ..

I don't want to create manually local member for all the Column.. There is a way that you create one local member and it get added to all the columns.

For instance prod 1, Prod 2, Total,   --- Same dimension prod 3, Prod 4 Total , I need to add total in all the columns--

Any ideas

Thank you

Neil

[Former Member · Accepted solution]

Hi Neil,

there is a simple and standard way for achieving your requirements. BPC itself provides the solution for you.The number of columns doesn't matter at all. It will show the sum for all your columns. As confirmation please see the screen below to make sure I met your requirements:

Report:

The report above shows the desired result without any manual entered local member. For achieving this simply create a report with a dimension in rows (here entity) and your dimension PRODUCT in columns. Select in your REPORT member selection the desired products to be summed up - here I took ProductA and ProductB. Now go to the sorting properties for the product dimension in EPM Editor and make the settings as follows:

1. Enable Member Sorting

2. Group by Property HLEVEL

3. Select AFTER tab

4. Set flag Create Local Member Named - After (once you set the flag the local member formula will automatically filled by system)

5. Press OK

Now you got a report with ProductA and ProductB in columns plus a TOTAL column. After these steps create a new report with sharing row axis. Select the new products - I took ProductA and ProductC. Repeat the sorting settings described above and you will get the report shown in screen.

There are several ways to achieve your calculation elements. One thing is to create a property in product dimension wich identifies the calculation elements. Referring in sorting properties to that property (instead of HLEVEL) will enable you to have just one report instead of two or more with the same result as shown above.

Hope this will help you,

Karsten

[Former Member]

Hi Neil,

As per my understanding you can check "Active Local Member Recognition" in the report Options tab & then you can insert the formula in one cell of the column then it will create for the rest of them.....

I hope this will help you but if you had any further quries kindly show your requirment clearly in a Excel sheet so that we can understand & We can make a try to give you correct solution....

Aravind

[Former Member]

Hi Karsten,

Thanks for your very detail explanation issue is resolved.

Neil

[former_member186338]

Hi Neil,

You have to explain what do you have in your row axis... If you have base members and you want to have sum of all base members then you create a local member after the row axis:

=SUM(EPMSELECTEDMEMBERS(DIMNAMEFORROWAXIS))

Vadim

[Former Member]

Hi Neil,

There is no automated way that if you create one and it will create the rest for you.

What you can do it by activate local member recognition, that will help you to speed up a little bit.

Andy

[Shrikant_Jadhav]

Hi Neil,

Your requirement is not clear but if you want to add local member after column axis, you create local member after column axis.

For more information kindly refer below link page no. 150 16.4 Local Members

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

Shrikant