Selecting certain/multiple Cost Center Nodes in a report

[Former Member]

Hello Gurus,

I have a requirement where in I have to be able to add certain Hierarchy nodes or multiple nodes so that the Planning can be made for that Period or Term.

The Hierarchy node that I have to be able to select is for Cost Center.

Cost Center has multiple nodes

Cost Center 1

     Cost Center 1.1

     Cost Center 1.2

     Cost Center 1.3

Cost Center 2

     Cost Center 2.1

          Cost Center 2.1.1

          Cost Center 2.1.2

          Cost Center 2.1.3

     Cost Center 2.2

          Cost Center 2.2.1

          Cost Center 2.2.2

          Cost Center 2.2.3

          Cost Center 2.2.4

Cost Center 3

     Cost Center 3.1

          Cost Center 3.1.1

          Cost Center 3.1.2

          Cost Center 3.1.3

In my report the User/I should be able to select only Cost Center 2.2 and its children.

Rest of them the user shouldn't have access to. For this scenario I have excluded those members other than CC 2.2 so even when User selects them, the report will show BLANK.

For Cost Center 2.2 I am able to see the data using Context Member option by referencing it in the Dimension Axis.

Unfortunately I am unable to choose multiple Cost Center nodes; like CC 2.2.1 and CC 2.2.2.

I can see CC 2.2 and I can drill down to see the children. But I want to provide the option where I should be able to select multiple children instead of just the Parent and Plan on the Children directly.

I tried doing the Page Axis - Dimension Override option, but I am unable to get the Cost Center nodes down separate cells. Kindly help.

Looking forward to favorable responses. Do let me know if any further information or screenshots are required.

Regards,

Sachin

[former_member186338 · Accepted solution]

By the way, can you show the report design? I do not completely understand your idea to select multiple nodes...

[Former Member · Accepted solution]

Hello Vadim,

Please find attached.

Regards,

Sachin

[former_member186338 · Accepted solution]

Ups, still not clear...

Multiple members can be selected only in page axis (the result will be the sum of multiple members).

With performance degradation...

[Former Member · Accepted solution]

Hello Vadim,

Exactly. Right now the Cost Center Dimension in the Row Axis is referencing the Context Member selection of Cost Center. In the Context Member I have selected CT1202 which is the parent. Now the user wants the option to select down CT1202; CT1202's children as well.

CT1202 -

     CT120201

     CT120202

In this case, during Forecasting user needs to be able to choose CT120201 and CT120202 to make the Forecasting instead of drilling down the CT1202 to reach the children.

Choosing it through Context Member/ (is there another way?) and accessing it in the Dimension Row Axis, to make the Forecast.

In Page Axis, like you mentioned - Performance degradation, also we can select multiple members, but the result is displayed as the Sum, which wouldn't be accepted.

Kindly advise.

Andy,

By using Data Access Profile, how can I achieve this. How and where will I be able to amke the multi-selection?

Regards,

Sachin

[Former Member · Accepted solution]

Hi Sachin,

If you want to select multiple members of cost center then you can use a macro for the same and create a Excel data validation. You will find the help on google for the same. Then you can reference the same using Excel cell reference to the report or dimension override.

Since you know the hierarchy you can manually use the ID's list for data validation.

Here is the link....

Select Multiple Items from a Drop Down List in Excel

Hope this helps....

[former_member186338 · Accepted solution]

Sorry, but the logic is still not clear!

Data input can be done only on the base level.

For row axis you can select whatever members you want! Just use standard member selector for row axis!

[Former Member · Accepted solution]

Sorry, incorrect response earlier.

Base members across multiple Cost Centers

CT1202

     CT120201

          CT12020101

          CT12020102

     CT120202

          CT12020201

          CT12020202

Selection of members CT12020101, CT12020102,CT12020201 for Forecasting - Data Input.

Currently I can select only one by one which is cumbersome. Using page Axis I was able to get the sum of both.

Is it possible to select the three Base Level Cost Centers to Forecast values.

Regards,

Sachin.

[former_member186338 · Accepted solution]

For sure you can select 3 base costcenters as 3 rows using memberselector for row axis (member only). What is the issue?

"Currently I can select only one by one which is cumbersome" - but what do you want instead?

You can create some property for costcentre and set it to some value. Then you can select members with this property...

[Former Member · Accepted solution]

Hello Vadim,

This report when it is run by the Users, it will be in Protected mode. At this time, the users will not be able to go and select the members manually. But I want to provide an option similar to Page Axis & Dimension Override or the Referencing the Context Member property cell.

Something similar to the above the user should have the option to select multiple members of the Dimension without any hindrance so that the Forecasting can be done.

There are EPM Formula that I think can be used, but I want to have clarity on that.

EPMSelectMember - the Parameters that is to be filled. How to get more than one Cost Center node using the EPM Standard Member Selection.

Regards,

Sachin

[Former Member · Accepted solution]

Thank you JP, I will definitely give this a try and post my output.

Regards,

Sachin

[former_member186338 · Accepted solution]

Please read my answers!

Vadim

[Former Member]

Hi Mario,

You should use data access profiles to control the data.

Then you can select parents or children.

Andy

[Former Member]

Hello Andy,

Thank you for your prompt reply.

Could you kindly direct me to a How-To-Guide as to how to use the Data Access Profiles.

I am pretty new to BPC and I need a lot of guidance on this.

Regards,

Sachin

[Former Member]

Hi Mario,

Have a look at the security guide found at this link.

on page 26 of the guide.

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver – SAP Help Portal Page

Andy

[Former Member]

Thank you Andy, I will get back to you for any queries on this.

Regards,

Sachin