Update ODS in Data Target - required full update

[Former Member]

Hi

I wanted to automate "Update ODS in Data Target" in a process chain. Created the process chain with the correct variant.

Is there a way to set as a "full update" instead of a delta? I have prior process to delete infocube. Reason is ..in Full Update, it brings across selection criteria which I needed.

thanks.

Message was edited by: BWer

[Former Member · Accepted solution]

System created. I have no moved the manual one yet to pbw.

[dielom · Accepted solution]

Try creating your own infopackage. That should work.

Regards,

Diego

[Former Member]

Resolved, awarded full points..

Also check on OSS 625338 – consulting on Process chain - datamart

https://websmp104.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=625338&_NLANG...

[Former Member]

Just discovered that in production BW, under process chains->infosources, there is a datamart (DM) section, so, I would presumed that this is the one that I needed in the process chains. Unfortunately, the error is the same when I move into the process chains steps.

Error msg:

InfoPackage ZPAK_429ONI1XPBPS6PDGO4FTYQVXU is generated; NOT able to be used as loading variant

Message no. RSMPC159

[dielom]

Hi BWer,

This infopackage was created by you manually? Or is the one that the system creates when you execute the process to update ods data targets?

Regards,

Diego

[Former Member]

Thanks so much... i found it on unassigned node and will transport to production bw.

Question:Anyway to assign to a proper node instead of unassigned section ?

Will award full point once I resolve it.

[dielom]

Hi,

You can drag and drop it to where you want. If you get a message that drag and drop is disabled, go to transaction sm30, put RSADMINSV as table/view, press maintain, you'll get two information messages, press ok in both, then uncheck the Drag & Drop off flag. Save and go again to rsa1 and move the infosource. For security, you'd better, after doing this, check the Drag & Drop flag again.

Regards,

Diego

[Former Member]

Hi Diego

You mentioned 2 things which I cannot locate on Infosources.

1. Check in datamart ? Where is the datamart option located ?

2. there is no such infosource named 8NAMEOFYOURODS. i.e i am using my ods technical name and did a find on infosources section, return nothing.

Message was edited by: BWer

Message was edited by: BWer

[dielom]

Hi,

when i mentioned datamart, i meant a component application named Datamarts, usually under unassigned nodes.

To get your infosource do as follows:

In rsa1 - infosources, in the tree, right click on the root (InfoSources) and select Insert lost node(s). Then, press the refresh button and look for your infosource named 8NAMEOFYOURODS.

Regards,

Diego

[dielom]

Hi,

You need to create a full load infopackage from the ODS (infosource named 8NAMEOFYOURODS, check in Data Marts).

Then, in process chain, instead of using Update data targets from ods, use this new infopackage.

Hope this helps.

Regards,

Diego

[Former Member]

i think Diego even if you do it from ODS side(rather than going for data mart and chosing 8ODSNAME) it will create package on 8ODSNAME. isn't it...?

[dielom]

Yes, but sometimes it's difficult to find or use it. As is an automatically generated infopackage, maybe you can have some troubles (its SAP infopackage, it can be deleted by the system if you change something).

regards,

Diego

[Former Member]

Created the package and now it throws out this error message.

"InfoPackage ZPAK_429ONI1XPBPS6PDGO4FTYQVXU is generated; NOT able to be used as loading variant"

[dielom]

Hi BWer,

Create the infopackage manually.

Regards,

Diego

[Former Member]

If you want to make full update a part of process chain you have to create a package for that and include that into Process chain.

Go to you infosources and disable the automatic updates to data target for ODS. then right click on ODS and select update data in targets. It will give a option for full or init load. Choose full load and it will take you to package creation screen. Create a package with all the slection you want and save it.

Now use this package in your process chain after you cube delete step

thanks