Updating Cost Center Dimension in BPC

[former_member602692]

Hi Experts,

Is there a way to update the members or properties in dimension thru a macro in excel where I just need to put the summary of changes in excel and click a button? How do you manage many updates from time to time during planning season especially? Below sample is Cost Center dimension but not part of the screenshot are other properties like, entity, function, cost center owner, etc.

Thanks,

Joseph

[former_member186338]

BPC version details, please!

[former_member602692]

Hi Vadim,

.

[former_member186338]

I am talking about BPC, not about EPM client!

[former_member602692]

HI Vadim

..

[former_member186338]

Then you are using incorrect tag:

SAP Business Planning and Consolidation, version for the Microsoft platform

has to be:

SAP Business Planning and Consolidation, version for SAP NetWeaver

I will alert moderator to change tag

[former_member186338 · Accepted solution]

You can always use DM package to load master data from text file. You can get existing master data, change it in Excel, save as text file then upload it to BPC...

[former_member186338 · Accepted solution]

P.S. All steps can be automated using VBA...

[former_member186338 · Accepted solution]

P.P.S. Alternative can be badi for Master data on the fly, but this approach is more complex...

[former_member602692 · Accepted solution]

Thank you!

[former_member186338 · Accepted solution]

jtuawin

You can automate DM launch with VBA:

https://blogs.sap.com/2017/06/16/simple-vba-function-to-pass-parameters-to-dm-packages/

[former_member602692 · Accepted solution]

do you have a sample? will it be possible to target 1 member to update? for example. cost center owner of cost center 123 only.

Thanks,

Joseph

[former_member186338 · Accepted solution]

jtuawin

"do you have a sample? will it be possible to target 1 member to update? for example. cost center owner of cost center 123 only."

The scenario is not clear!

For single member property update it's easier to use web administration page 🙂

For multiple members and single property it can work like:

1. Get table of member ID's and property values: https://blogs.sap.com/2014/06/04/bpc-nw-10-vba-to-get-dimension-members-list-and-properties/

2. Change properties as required

3. Generate text file with 2 columns (ID and property value)

4. Upload this file to BPC server (vba: DataManagerFilesUpload)

5. Run DM package to import data from uploaded file.

[former_member602692 · Accepted solution]

The scenario is more of the 2nd one especially during planning season. There are a lot of request to update properties. If I will be able to do this, it will be a big time saver. Thank you. I will try.

Thanks again Vadim!