InfoObject attributes

[Former Member]

Hi

Is it possible somehow to run through the masterdata of an InfoObject and add an attribute value depending on the key field.

I tried to write a rutine in ABAP, but the M table of the InfoObject is write protected. Is there a way to get arround this? Is there a function module to do this sort of thin or another solution?

Thanks

Chris

[Former Member]

Chris,

The simplest ways to update the values of the master based on the key are to update the values as you load the data. For two well-documented ways to do this, go in the NW04 or BW help to:

Data Warehousing>Modeling>Update Rules>Creating Update Rules for Data Targets. Under here, you should find:

>Update Routines and Start Routines and

>Update Methods>The Transformation Library>Example for using the Formula Editor

The example seems similar to the problem you are describing.

Hope this helps.

Best Regards,

Doug Childs

[Former Member]

Hi Chris,

you can feed your (new?) field with a new flow (coming from a flat file, for example..) in which you can load only desired combinations (key field, even if I'm not colmpletely understanding your scenario...)

Hope it helps !

Bye,

Roberto

[Former Member]

Okay i try to describe the scenario in more detail.

I have one InfoObject whit one attribute (Country key - DK, UK, US, DE). Masterdata for this InfoObject is created when loading transactional data into an InfoCube.

Now i have som MasterData values for the KeyField. I now want to add the country key - DK to all Keys starting whit L3.

I hope this makes it easyer to understand.

Chris

[Former Member]

Ok Chris,

download your masterdata (only if sarting with L3) into a file (or into a custom table). Format it, fill with DK every record, then create a link between your masterdata infosource and the flat file and load it !

I think this is the smartest and safest way to do what you want (since directly operate onto db tables could result in some SID inconsistencies) !

Hope it helps!

Bye,

Roberto