Can we update infoobject to cube by lokking at attribute value?

[Former Member]

Hi All,

I have a question (this might be in BI space) however I am working on APO BI.

WE have a sitaution were an infoobject character - Salesgroup has attribute (Display) externanl group. When we get sales history file evvery month we get attribute of Salesgroup that is External group in file. When we write to cube we look up at External group and write associates sales group number into the cube - CAn we do this and if yes How?

[former_member209769 · Accepted solution]

Hi,

Your question is not very clear.

What I understood is that you have a characteristic called Sales group. For this characteristic called Sales Group, you have an attribute called external group.

Then you get some file which contains external group. What is meant by "we write associates sales group number into the cube"?

Is this 'Associate's sales group' a new characteristic/ attribute? Or do you mean the above characteristic itself (sales group)?

If my understanding is correct, you mean that you would like to update the sales group (characteristic) in the cube based on external group (attribute).

You can get your file data to a DSO or a cube, and then use it somewhere in logic in any way that you want.

For this, either you need to change the characteristic when data is being uploaded to the cube,

OR

send data from this cube to another cube or DSO, and make the changes during the data transfer,

OR,

use function modules through which you can read cube's data and also change it. This will require a custom program.

If you can share your requirement clearly, then it should be possible to give a more clear solution.

Hope this helps.

Thanks - Pawan

[Former Member · Accepted solution]

Hi Pawan

thanks for your response - what you understood looks to be right.

Sales Group is an info object(Characteristic) -- External group is its attribute. Flat file we get from Market has External group populated. We need to use some sort of rule or ABAP code to in transfer rule or however - such that the based on External group the system should look up for Sales Group and populate in cube .

to my understanding we need to write some sort of ABAP code for this . Can you suggest on this. Any sample code is also appreciated.

thanks

Varma

[former_member209769 · Accepted solution]

Hi Varma,

You should talk to some ABAP person from your team who has worked previously in BI related area.

He could maintain the routine in the transformation. For an ABAP person, this shouldn't be a very complex topic, however as a functional person, I am unable to help you with the code.

PS: You would maintain the external group in the datasource, but this won't be mapped to any characteristic in the cube.

In the transformation , maintain the above code which would fill the value for sales group when populating the data to the cube.

An assumption would be that one external group is assigned to a unique sales group, else you would face issues in the logic.

Regards - Pawan

[Former Member]

Hi,

Typically you would model such a situation in BI by creating an Infoobject External Group with an attribute Sales group. Next you would load all the External Group, Sales Group combination into this Infoobject.

Since you want to store Sales group in the cube that would need to exist in the cube. And the External group will be required on the source. Within the transformation connection these two, you use the rule type 'Read Master data' and select External Group infoobject in the 'From Attr. of' box.

No ABAP code or skills are required for this approach.

[Former Member]

Thanks for your info - I think

i need to take help of ABAPer .

REgards

Varma