'init load' & 'full load'??

[Former Member]

Hi all,

Can anyone correct this if i am wrong?

--My question is that I need to delete 'init load' & re-load it with 'full load' and then create the 'process chain' to transfer data periodically after I loaded data first time with 'init load' and the data was tested, right?

--If not, what it is after I loaded data successfully with 'init load' in the first time?

--Do I always need to use 'init load' for first time data load? If not, what is the situation that I need to use 'full load' for the first time data load?

Thank you

[Former Member · Accepted solution]

U cannt use an Init load as a load in the Process chain. As u have deltas in ur requirement, then u have to do either Full upadte and then do the init with out data transfer or u can do the Initilization. Once this step has finished then u can include the delta load as a load process in ur Process chain. then only it will work.

u shud not include any init load infopackages in the process chain..

Hope it helps.

Regards-

MM

[Former Member · Accepted solution]

Hi MM,

Thank you. But my first load was 'full load', I used the 'full load' infopackage to run the process chain and got an error message. I am wondering if it is the problem to cause the error because I ran the 'full load' instead of 'init load' for the first tiem data load. Thank you for help.

[Former Member · Accepted solution]

Hi John,

The black line that you see between the start process and the load is not an issue. That line is always black. Doing a full load through the process chian is not an issue at all. There must be somethign else...what is the message if you check the chain?

[Former Member · Accepted solution]

Hi Bhanu,

For the processing option, I chose 'PSA and then intodata targets (package by package). <b>I intend to load data into ODS and then load from ODS into Cube.</b>

For the data targets, I only chose the 'ODS'. Do I also need to choose the Cube in this tab?

The error message is 'the request xxxxxx is still not uptdated in any infocube.

Thank you

[Former Member · Accepted solution]

John,

You need to check if updates rules are maintained from the ODS to the Cube. If you are loading to ODS and then from ODS to cube, you cannot choose the cube and ODS in the same InfoPackage. Either use another infopackage from ODS to Cube or use the further update process type.

Hope this helps...

[Former Member · Accepted solution]

Hi Bhanu,

Thank you.

Yes, the updates rules is from the ODS to the Cube. I used "update ODS data in Data Target" but I cannot find any information about it. (because the error shows: it cannot load into the cube)

I would like to re-load from the ODS to the Cube by using "generate export datasource". If so, I am wondering if i need to delete the 'update rule' before I re-load it again? I try not to affect BW too much by re-loading.

Thank you.

[Former Member · Accepted solution]

Even if your ODS is set to update into further data target, if you are using a process chain, you need to use the process for further update, else it will not be loaded in to the cube.

Sames goes for the PSA and Subsequent update option in the Infopackage. Even though you have checked this option, you will need a separate Update from PSA method in the process chain. The process chain needs each step to be spelt out clearly.

There is no harm in regenerating the Export DataSource, just check that the update rules are active before attempting the load.

Hope this helps...

[Former Member · Accepted solution]

Bhanu,

According to your information, I found that in the ODS dataflow I see the dataflow including the cube but i didnt' see the cube included in the planning view. Did I miss somthing here? If so, can you point out the steps for loading ODS data into the Cube periodlically?

Thank you

[Former Member · Accepted solution]

The method I usually follow makes my process chain look like this:

Start > InfoPackage to Load to ODS (on the Processing tab in the infopackage choose the first or second option, not the third one) > Process to Activate the ODS data > InfoPackage to load from ODS to Cube.

These InfoPackages load the delta data and scheduled to run once a day.

Hope this helps...

[Former Member · Accepted solution]

Bhanu,

Here is my planning view: start -> Load data-> ODS data (activated)-> futher processing(generated from ODS) I missed from the ODS to the Cube.

I need help to setup the dataload from ODS to the cube. I alread created the updates rules for the cube and ran the "update ODS data in data target". I don't know what else i need to do to make it work. Thank you.

[Former Member · Accepted solution]

What did you maintain in the variant for the Update ODS data (further update) process?

[Former Member · Accepted solution]

Bhanu,

It is 'generated from ODSACTIVAT ZPAK_XXXXXXXXXX. I saw one option- avtivate_all_ODS. Do I need to use that one or create one.

[Former Member · Accepted solution]

Bhanu,

I am not sure if this will help you to find a clue. I deleted the process chain and try to create new one. It shows "<b>invalid TID passed:monitoring contenxt not found in the System BWP</b>.

[Former Member · Accepted solution]

Just log out and log in again and then try to create the new chain...the message is not really relevant to our case.

[Former Member · Accepted solution]

Hi Bhanu,

I re-created the process chain again. I got an error message: infoObject* is inconsistent when I double click on the "further processing". Any clue? Thank you

[Former Member · Accepted solution]

Any details on this error message?

[Former Member · Accepted solution]

Bhanu,

Do I have to transport the 'further process'(process maintenance-updata ODS Object Data)? Thank you.

[Former Member · Accepted solution]

Transport..? Is the process chain working now, and you want to transport it?

[Former Member · Accepted solution]

Bhanu,

Is there any way that I can check if my process chain works after I create it? I usually know when I check PSA next day.

For the process chain, I used 'check' buttom and it shows OK. Then I activated it.

[Former Member · Accepted solution]

Yes you can certainly do that. Set the Start Variant to Run Immediate. Save and then Activate and Schedule it. It will start running immediately and then you can take a look at the logs to see its progress.

Hope this helps...

[Former Member · Accepted solution]

Bhanu,

Thank you for sharing your knowledge with a new man in this area.

Yes, I looked at the log and I saw it shows that I activated it in the specific time. But I cannot find any information regarding if is loading successfully. Last time I found the loading unsuccessfully <b>in the infopackage with yellow warning sign on when I went to PSA.</b> (that is how I found it didn't load into the Cube). Thank you.

[Former Member · Accepted solution]

So what does the message in the monitor details tab show?

[Former Member · Accepted solution]

Hi Bhanu,

Tahnk you for all the help. I found that I omit one process which you mentioned (the process between the ODS and the Cube). I am going to give it a try again. However, I have another problem before I work on the process chain. I am going to post this question online. Please help, you know the solution.

I reward you for sharing your experience.

Thank you