Upload Master data and hierarchy from BW to BPC : Account Hierarchy

[Former Member]

Hello,

I know that you all are aware the property "ACCTYPE" is not available in BW for Account master data.

The requirement here is to load master data and hierarchy for Account dimension from BW to BPC. Can anyone suggest the best approach to populate the priperty "ACCTYPE" in the account dimension member sheet in BPC during this automated load process?

Thanks and regards,

RJ

[Former Member]

Hi,

To populate this property using the standard data packages, your infoprovider needs to have this value as attribute.

What you can try to do is, in case of your infoprovider don't have this value and it's a value that can be extracted in BW, is to create this attribute. Then adjust your transformation file to fill this field.

Regards

Lucas

Edited by: Lucas Gabriel Corrêa da Costa on Jan 18, 2012 1:07 PM

[Former Member]

Lucas,

Thanks for the response.

Could you please explain the steps you have peformed to adjust the transformation file in this regard?

Thanks again,

RJ

[Former Member]

Sure,

For exemple:

Assume that your infoprovider is 0COSTELMNT and you'll fill the ACCTYPE with the attribute 0CSTELMNTYP. (It's just a exemple).

In the transformation file, in the mapping field you just map the attribute to the property.

*OPTIONS

.....

*MAPPING

ID=ID

ACCTYPE=0CSTELMNTYP

SCALING=*str(Y)

RATETYPE=*str(AVG)

IS_INPUT=*str(Y)

*CONVERSION

....

You can also, define a hardcode for any property.

F.E: ACCTYPE=*str(EXP)

I hope this can help you.

Lucas

[Former Member]

There will be more than one "ACCTYPE" and "RATETYPE". Then what would be the code/syntax to be used in the transformation file?

The to-be process is to load master data from BW.

Is IS_INPUT=*str(Y) a required parameter then?

Kind regards,

RJ

[former_member313601]

You will have one line in the transformation for each of the property of BPC dimension.

When properties are not available in BW, you make them as described above like str(AVG) etc.

First one populates the base members and then in another load, parent/hierarchy information is loaded.

See the DM Process/ Process chanin - to load Master data and Hierarchy data from infoprovider.

Hope this helps

Thanks,

SN

[Former Member]

Hi,

It was just an exemple, to show that, or you map hardcode values or map attribute from BW infoobject for each property of your dimension.

This fields are fields that I have here, but you may put just your account dim properties, nothing further.

Regards

Lucas

Edited by: Lucas Gabriel Corrêa da Costa on Jan 18, 2012 4:18 PM