Relating master data

[Former Member]

Hi Friends,

I got an req. i.e, I get data from other system, for 2 characteristics along with keyfigures. These 2 char. are related with other char. , so need to get all these char. along with keyfigure in to a infocube.

These combination are stored in other cube.

So please advice how to combine all these char. along with master data in to cube... so as to get in single line of data with these char. along with keyfig...

[Former Member]

From what I understand, you want the data in a single record in the cube, you may get something like this if you update with two datasources:

Char 1| Char 2| Char 3| Char 4| Char 5| KF1| KF2|

A| B| #| #| #| 10| 20

#| #| C| D| E| #| #

How will you handle this on the report?

[Former Member]

Hello

You need to write a routine for the characteristics which you have to read from the other cube. The way to code or use this function module is shown in the report RSDRI_INFOPROV_READ_DEMO .

I hope this helps.

Regards

Shreyas

[Former Member]

can we have two datasource and add the fields in trnasfer rules and update rules. So that we update data in to a single infocube....????

Can i do this....

[Former Member]

Even if the records are coming through flat file it does not matter. the procedure remains the same.

1. Add the required characteristics and keyfigures to the desired cube.

2. In the update rules from the infosource to the cube, get the data from the already existing cube. use the function module I specified for the infocube read.

Regards

Shreyas

[Former Member]

Could you just tell me how to use this func. module, step wise in update rule. Please......

[Former Member]

Hello

As far as I understood, you are geting two new characteristics from a new R/3 system and you want ot get some more information from already existing cube.

1. You need to add the two fields coming from R/3 to the cube.

2. Derive all the related characteristics from the other cube in the update rules / transformations. Use the function module dule RSDRI_INFOPROV_READ to read already existing cube.

All the things will come in a single record as you want. Lemme know if it helps.

Regards

Shreyas

[Former Member]

Hi Thanks for reply,

The source is not r3 it is flat file, from where i get 2 chars along with kf's.

But these 2 chars are related with ither chars. which are in a cube, so while uploding from flat file i need to update all these char. and kf in to single infocube.

The data should be in one line.

If your reply helps the same, please detail that....