Skip to Content
Technical Articles
Author's profile photo Dinesh Mukundu Mohan

BPC Embedded 11 – How to update Dimension properties & texts (Master Data attributes & texts) from Analysis for Office

BPC 11 Embedded Master Data Planning Feature.

 

How to update Dimension properties (Master Data attributes) & texts from Analysis for Office using Master data Planning feature in BW/4 HANA & BPC 11.

 

Goal

In this Blog we will look on various options in updating BPC Master data and look on how to update master data attributes/properties via Analysis for Office usingBW/4 HANA Master data planning feature.

Overview

 

In BPC Embedded, Master data(Dimension Members and Properties) can be updated via

  1. Extracting Master data attributes & texts from SAP source systems (Data source extraction)
  2. Extracting Master data attributes & texts via Flat file interface from Non-Sap source systems.
  3. Manually maintaining from BW Master data maintenance
  4. Manually maintaining from BPC Web interface
  5. Update Dimension properties & descriptions from Analysis for Office.

 

Business Scenario

In BPC Embedded, Dimensions & Properties are added when you create Models. Dimensions and Properties are Infoobjects and their attributes. These bpc properties and descriptions will be updated manually via option 3 or 4 or loaded from source systems via option 1 or 2. We will see one more option to update dimension properties and descriptions that can be used by BPC Admin and Business users.

Option 5 : We will use Master data planning feature to update Master Data (dimension members and  attributes/properties) from Analysis for Office.

 

Detail Steps

Step 1 : Infoobject with Master data attributes and text.

Choose a infoobject that has master data attributes and text enabled. If you don’t have then

Create/copy an InfoObject (ZMDTPLN) switch on master data & texts and then add attributes. In my example I am copying existing infoobject.

Step 2 : Enable Planning mode for the infoobject and activate the infoobject.

 

An infoprovider is generated with the same name as the infoobject, in this case à ZBPC11MD.

 

Step 3 : Create an aggregation level on top of the generated infoprovider ZBPC11MD. 

Go to transaction  RSPLAN, enter the ZBPC11MD in infoprovider to view the fields of generated infoprovider.

Create aggregation level on top of the infoprovider ZBPC11MD.

Add Characteristics and Keyfigures to the aggregation level.

Add all the properties and texts that are available as keyfigures.

Step 4 : Create a planning Query on the Aggregation level

Add Characteristics in the Rows and keyfigures in the Columns.

 

Change all the keyfigures to Input ready by going to the planning tab.

Enable the Start query in Input mode and save the query.

Step 5 : Enable planning for the infoprovider ZBPC11MD

Step 6 : Open Query in Analysis for Office

Open the query in analysis for office by inserting data source.

Check if the query is in plan mode, enter or modify attribute values and texts

Enter the corresponding values to the attributes and texts and Click save to update the master data.

The properties and texts updates will be reflected in BW infoobject and BPC Dimensions.

 

Conclusion:

Now you just learnt how to update Dimension properties (Master Data attributes) & texts from Analysis for Office using Master data Planning feature in BW/4 HANA & BPC 11. You can find the benefits of this as mentioned below.

  • use alternate approach to Update Dimension and text from AFO
  • enable Master data update via AFO with authorization.

Looking forward for reading your comments. I hope you will find this blog useful.

 

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mohammed Toufiq Qureshi
      Mohammed Toufiq Qureshi

      Hi Dinesh,

      Nice blog

      Regards

      Toufiq

      Author's profile photo Dinesh Mukundu Mohan
      Dinesh Mukundu Mohan
      Blog Post Author

      Thank you Mohammed Toufiq Qureshi

      Author's profile photo Gregor Dieckmann
      Gregor Dieckmann

      Hi Dinesh,

      in section Goal there is a typo:

      ...using BW 7.5 Master data planning...

      correct is

      ... using BW/4HANA Master data planning...

      in fact you need BW/4HANA SP08 and AO version 2.7,cf. note 2508938.

      Regards,

      Gregor

      Author's profile photo Dinesh Mukundu Mohan
      Dinesh Mukundu Mohan
      Blog Post Author

       

      Thank you Gregor for your comments, in fact it works for AFO Version 2.5

       

      and below are the service pack details.

      Author's profile photo Ragunathan R
      Ragunathan R

      Hi Dinesh,

      Good read.

      Explained nicely step by step.

      Thanks,

      Ragunathan.R

      Author's profile photo Ramjee Gupta
      Ramjee Gupta

      Nice , Helpful

      Author's profile photo Sameer Lonkar
      Sameer Lonkar

      Thanks Dinesh. We followed the steps and we are able to update attribute values from AFO, but the updates from BPC Web have got stopped (we are not able to update master data from BPC Web). Can you please advise?

      Thanks,

      Sameer Lonkar

      Author's profile photo CRISTINA UNGUREANU
      CRISTINA UNGUREANU

      Hello Dinesh Mukundu Mohan,

      Very well documented blog, good job!

      I have a question, do you know if I can swich on/off the planning mode for the infoobject like we can do it for an infoprovider in a process chain?

      Best Regards,

      Cristina