Automate Owner property in BPC 10.0 from BW

[former_member254616]

Hi Experts,

We would like to automate the master data from BW to BPC and for this I have a question regarding Owner property in Entity Dimension. For e.g. In BPC Entity Dimension, there is an Owner property. we have 2 Users at the moment Team 1 , Team 2 and Team 3. Team 1 and Team 2 for few Entities and Team 3 for few Entities.

My question is;

1. Is there a way to do something in the BPC Transformation file to update this property?

2. If we add a new Attribute in BW Info Object and update them with Team1, Team2, Team 3 against respective Entities, would this work when we extract this to BPC?

In case of any questions, please let me know.

Thank you.

[former_member186338 · Accepted solution]

How to map in conversion:

In transformation mapping use:

ID=ID

OWNER=ID

...

Conversion for OWNER:

External Internal
ID001    TEAM1,TEAM2
ID002    TEAM1,TEAM2
ID003    TEAM1
...

If most of ENTITIES will have the same OWNER then map only other mapping, for the rest use at the end:

*        SOMEMAPPING

[former_member254616 · Accepted solution]

Hi Vadim,

Great, thanks a lot for your support. I can opt for this solution.

Thank you once again.

Have a nice day.

Regards

[former_member254616]

Hi Vadim,

Thank you for your reply. Please find details below and help me understand more on Conversion file concept?

1. Conversion file (easy to maintain) -

Conversion file can only be maintained to convert data coming from Source. If I do not have an Owner field in BW info object, how can I maintain a Conversion file for the same? Please help me understand?

2. BW attribute (I am unable to understand the idea with text file...) -

Our Client will update the Master data in a BW info object using a flat file upload. The master data does not come from ECC. Therefore, I was planning to include an Attribute "Owner" in the BW info Object and when user updates Master data in this Info object, we can extract to BPC.

3. Z-table with routine badi looking on this table -

I think option 2 would be more feasible than this option.

4. Another last question please.

Would it be possible to hard code the value of a Property of a Dimension in BPC with 2 values? For e.g: as shown below.

Mapping Section in Transformation file

Owner = *NEWCOL(TEAM1,TEAM2)?

I know we can only hardcode one value as show below but when I try to maintain 2 values, it is giving me an error

Owner = *NEWCOL(TEAM1)

I hope I have answered all your queries.

Please let me know for any details.

Thank you,

Regards

[former_member254616]

Hi Vadim,

Thank you for your prompt response.

If I understand you correctly,

You can define mapping in the conversion file for each Entity ID. - I think we might face issues in future if any new Entity is added. we will have to maintain the new Entity in the conversion file again.

In that case, I think adding a new Attribute to the BW info object will suffice as our users will upload the BW info object using a flat file and we can then extract the same to BPC.

Thanks and Best Regards,

Venkat

[former_member186338]

Not a big difference where to maintain mapping between entity id and owner!

1. Conversion file (easy to maintain)

2. BW attribute (I am unable to understand the idea with text file...)

3. Z-table with routine badi looking on this table

[former_member186338]

"1. Is there a way to do something in the BPC Transformation file to update this property?"

You can define mapping in the conversion file for each Entity ID.

For sure you can do it in BW also.