write into transactional ODS

[Former Member]

Hi,

i'm trying to write data into a transactional ODS via function-module 'RSDRI_ODSO_INSERT_RFC' and to transport these data from the ODS into an InfoCube afterwards.

Now i've got two problems:

1. I've created a very simple ODS with just one key field and one data field. In transaction SE80 i execute the functionmodule and fill the importtable 'I_T_DATA' with the key and just a '1' as data. The function writes the data without error.

But when i take a look into the active table of the ODS the key is written correctly, but instead of a '1' a '202.020.202.020.202,02' is written into the ODS.

2. I've created an Update Rule from the ODS to the InfoCube and thought that after the data is written to the ODS it would automatically be transported into the InfoCube, but that doesn't seem to work.

Is there someone who has allready implemented such a process and can help me with my problems?

Thanks in advance!

Greetings

Patrick

[Former Member · Accepted solution]

Hi Patrick,

in order to upload the data from ods to cube you need to schedule a infopackage or just make a right click on your ods and choose post data into datatarget (may be this is not quite correct because I'm translating from german).

regards

Siggi

[Former Member · Accepted solution]

Hi Siggi,

thanks for your quick response!

For a transactional ODS there is no menuitem 'Update ODS Data in Data Target'.

So i tried to generate an Export Datasource, so that i can create an InfoPackage. But after that i can't find the Datasource '8TODS'. I checked the display settings and generated Objects are shown. I don't know how i can find the generated DataSource to create the InfoPackage.

Greetz

Patrick

[Former Member · Accepted solution]

Hi Patrick,

did you try to find your datasource in the datasource overview of your source system 'myself'?

regards

Siggi

[Former Member · Accepted solution]

Hi Siggi,

You were right, i found it there.

But i can't find a possibility to create an InfoPackage.

Greetz

Patrick

[Former Member · Accepted solution]

Hi Patrick,

so what's left is, you need to see the infosource. May be as a workaround you can just create a infosource, assign the datasource to it and upload the data via infopackage.

regards

Siggi

[Former Member · Accepted solution]

Hi Siggi,

that doesn't work either.

Different DataSources can be chosen for assigning, but the generated DataSource for my transactual ODS is still missing!

Do you have any other ideas?

Greetz

Patrick

[Former Member · Accepted solution]

Hi Patrick,

did you replicate it from the datasource overview? If yes, and it is not available to connect to another infosource it is already connected to a infosource. So somehow we need to figure out where it is. Let me check some tables. I come back to you.

regards

Siggi

[former_member188975 · Accepted solution]

Hi Patrick,

You can also assign the InfoSource to your datasource from the datasource overview of your source system 'myself'. Have you tried doing it here?

[Former Member · Accepted solution]

So you generated datasource for your ODS, but you can not see it in infosources ?? so you can not create infopackage, ok ??

if so, you can try one thing. Go to the settings I think, in the menu on the top of the window. And there should be something like show generated objects or something like it. Then you can see it in your infosource tree menu.

bye

[Former Member · Accepted solution]

Hi Patrick,

check out table rsisosmap for your datasource. There you can see to which infosource it is assigned.

regards

Siggi

[Former Member · Accepted solution]

@Siggi

The table 'rsisosmap' shows me that my DataSource '8TODS' is assigned to an InfoSource '8TODS'. But this InfoSource is exactly the one that i need and which can't find anywhere in the administrator workbench!

@J J

The setting 'show generated objects' is allready switched on.

@Bhanu

How exactly can i make this assignment there?

[Former Member · Accepted solution]

Hi Patrick,

please go again to the datasource overview. Right in front of you datasource there is a button showing a + or a - sign. In your case it must be a +. Click on that button, it should bring you the infosource.

Siggi

[Former Member · Accepted solution]

Hi Siggi,

now i'm in the 'seetings window' of the InfoSource.

But i can only view the settings, not change them. And i can't find a way to create an InfoPackage.

Greetz

Patrick

[Former Member · Accepted solution]

Hi Patrick,

if you can go to the infosource in this way, it might be possible to delete the datasource assignment. Do so and create your own infosource and assign the ds to this is as I already suggested. I think it's worth to give it a try.

regards

Siggi

PS: please assign some points to all guys that help you.

PPS: if you want, you can give me a call.

[Former Member · Accepted solution]

Hi Siggi,

please excuse the late answer.

I tried to delete the datasource-assignment as you suggested, but that's not possible. The system only allows me to view the settings, not to change them!

Do you have any other ideas!

Thanks a lot!

Greetz

Patrick

[Former Member · Accepted solution]

Hi Patrick,

Try this.

1.Goto RSA1.

2.Click Infosources.

3.Goto Menu <b>Settings>>Display Generated Objects</b>

4.Select Radio buttion <b>Show generated ODS objects</b>

5.Then you find the datasource using the find function you definitly able to view the generated datasource.

6.Use Find function to select the infosource with name <b>8*</b>

Mail me if you still have problem