SAP BPC 10 - Creating Flexible Master Data with user input through EPM Addin

[SaqibRaja]

Hello,

Would be grateful for someone's input.

I have a requirement in SAP BPC 10 Standard edition where I am trying to provide the Flexibility for a user via EPM Add in Excel to be able to populate an attribute of a Dimension - therefore creating the MD record almost via user interaction instead of pre-loading attributes.

For example, I have a project dimension which has a project stage.

Attributes

ID. NAME. STAGE

123ABC. Test Proj. Draft

Update via user to

123ABC. Test Proj. IN PROGRESS

There is no source of this data so the option is to either preload all the projects manually into the dimension and the user chooses each project from the list via the context pane OR provide some functionality to allow each attribute to be populated AND updated by the user via the input schedule.. which is preferred.

For example, to update the project stage the user can choose from a drop down list of validations like, IDEA, PROGRESS, IMPLEMENTED and update this via the form.

Not sure how to do this but have read the MDOF guide and still a bit stumped?

Is this possible and how to achieve this? I will try with project dimension and then try and apply it to others..

Thank You

[former_member186338]

By the way, instead of changing master data you can update transactional data for some account like STAGE: 0 - Draft, 1 - In Progress, 2 - ...

[former_member186338]

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

[SaqibRaja]

Thanks Vadim.

Not sure how to use the VBA for my purposes or what it is doing etc.

Are you able to provide further insight please. Would be most appreciated?

[former_member186338]

syraja

Sorry, but what is not clear?

MDOF is using Data Manager package prompts to define properties of master data.

If you have the property values entered in some cell in the worksheet then my VBA code will pass the mentioned values to DM prompts without any user interaction.

The user will fill the values and press VBA button like - update project.

P.S. If you want to only modify (not create) MD then you need to adjust MDOF code a little.

[N1kh1l]

syraja

Creating Master data on fly from EPM without Data manager can be tricky. The challenge is how to transfer the various master data components like attributes , ID, Parenth1 from excel interface to backend BADI. There is another HTG to achieve this by executing the DM in background by filling all the DM prompts from Excel cell ranges.The HTG on MDoF uses DM as a medium to transfer these details to backend BPC Master data class methods which actually create the master data. In my project we have used ABAP webdynpro screens to create a form which does this jobs for us. All the validations and dropdowns have been created in wbdynpro via supporting ABAP tables and finally the user input from the screen and dropdown is passed to the BPC classes and methods to create the master data. I have used this for my capex projects in capex planning and I can say that its scalable and more flexible solution. Finally to make it easy for the users we have included the webdynpro URL in BPC Business Process Flow hyperlink which makes the overall experience even better. Using ABAP tables to populate dopdowns in Master data form is more central and flexible.

I would suggest that you can explore webdynpro as a possible form solution for Master data creation.

Nikhil

[SaqibRaja]

Hi Nikhil,

Thanks for the response.

Do you have a link to the HTG that you are referring to which you used to implement the solution?

If I could do some reading around it I can explore some the solution you have implemented to provide flexibility..

Thanks

[N1kh1l]

syraja

I did not use any HTG for my solution as my solution is based on webdynpro to provide the UX for Master data creation. But you can use MdoF HTG and the blog below from Vadim to combine and achieve a solution.

Nikhil

[SaqibRaja]

I read the HTG but that doesn't seem to work anymore and I was trying to achieve this without DMP or any user interaction other than choosing the values from a list..

All solutions gratefully considered..