Skip to Content
avatar image
Former Member

Relating master data

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...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 20, 2007 at 11:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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....

  • avatar image
    Former Member
    Aug 20, 2007 at 12:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 01:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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....

  • avatar image
    Former Member
    Aug 20, 2007 at 03:11 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded