cancel
Showing results for 
Search instead for 
Did you mean: 

Loading Infopackages one at a time (i.e. one by one)

nigel_blanchard4
Discoverer
0 Kudos

Dear All BI Experts,

We are implementing SCM5.1 with BI7.0

We load a cube in BI with daily forecast data from APO, but unfortunately we have spotted one of the dates is wrong, so the data in the cube has been summing up incorrectly.

That has now been fixed via the transformation, so what I want to do is reload the cube but with one Infopackage at a time (not all eight as are queued up now).

Does anyone know how to load packages one by one?

Any help will be greatfully received.

Nigel Blanchard

Accepted Solutions (0)

Answers (4)

Answers (4)

nigel_blanchard4
Discoverer
0 Kudos

Dear Respondants so far,

At least KMR is the closest!

Geo - Your comment doesn't really help me.

Jagadish - Yes you can move data from a data source or PSA straight into a Cube. You do not need a DSO. So I do mean infopackages.

KMR - You seem to have got the idea of what I am doing.

Forecast data is created in APO and saved into a DSO.

We have built an extract datasource in BI that fetches this data daily to a datasource on BI.

We then load this data directly into a cube. We have no need for a DSO as no transformation takes place (the DSO in APO essentially becomes our corporate memory anyway).

So the problem is this;

Initially, moving the data from the datasource to the cube has gone wrong due to the date problem. We have now fixed this in the transformation between the cube and the datasource.

To reload the data back into the cube, I need to load one package at a time. After each package I need to change the transformation to reset this date. So, that is what I mean when I say I need to load one package at a time.

The process will look something like; Set date on transformation->Load First package->reset date on transformation->Load Second package->reset date on transformation->Load Third package and so on until I catch up with today's load (about 8 days worth). After that I can just use the 'Current Date' function to automatically fill in the correct date. So the sooner I do it the less manual intervention required!

You are right about the DTP to delta the data into the cube request by request, but this does not provide me with the break between requests that I need to manually reset the date in the transformation. This option will run all of them one after the other without stopping. Is there no way I can just specifiy the request I want to load by request number or an option to simply load one request, so I get the break in between loads that I need?

Many thanks for your time and help so far.

Nigel.

former_member185071
Contributor
0 Kudos

Hi Nigel Blanchard There is an ancient solution i am sorry if my mind working as ancient guy. But let me share my though here As i suggested Just run the DTP between Data source and Cube with Get request by request delta option with below process Say suppose you have 18 requets in PSA when you run the DTP first time its trying to fetch the records one by one till 18 th so you can manually red teh process and delete the unwanted requests and then change the transformations date related info and then again run the DTP this time it will try to fetch the request from 2-18 so after loading of second request break the load by changing the QM ststus of DTP if its not possible then go to the target cube mange from there stop the data load then reomev the requests which ever present other than 2 remove 3-18 and then again repeat the process 318 break the load delete the requests 418 4--18 " " " " Repeat the process till all the requests got finished... and finally cross verify weather all the requests got loaded or not.. Hope its clear a little..! Thanks K M R ***Even if you have nothing, you can get anything. But your attitude & approach should be positive..!****

>

> Dear Respondants so far,

>

> At least KMR is the closest!

>

> Geo - Your comment doesn't really help me.

>

> Jagadish - Yes you can move data from a data source or PSA straight into a Cube. You do not need a DSO. So I do mean infopackages.

>

> KMR - You seem to have got the idea of what I am doing.

> Forecast data is created in APO and saved into a DSO.

> We have built an extract datasource in BI that fetches this data daily to a datasource on BI.

> We then load this data directly into a cube. We have no need for a DSO as no transformation takes place (the DSO in APO essentially becomes our corporate memory anyway).

>

> So the problem is this;

>

> Initially, moving the data from the datasource to the cube has gone wrong due to the date problem. We have now fixed this in the transformation between the cube and the datasource.

> To reload the data back into the cube, I need to load one package at a time. After each package I need to change the transformation to reset this date. So, that is what I mean when I say I need to load one package at a time.

> The process will look something like; Set date on transformation->Load First package->reset date on transformation->Load Second package->reset date on transformation->Load Third package and so on until I catch up with today's load (about 8 days worth). After that I can just use the 'Current Date' function to automatically fill in the correct date. So the sooner I do it the less manual intervention required!

>

> You are right about the DTP to delta the data into the cube request by request, but this does not provide me with the break between requests that I need to manually reset the date in the transformation. This option will run all of them one after the other without stopping. Is there no way I can just specifiy the request I want to load by request number or an option to simply load one request, so I get the break in between loads that I need?

>

> Many thanks for your time and help so far.

>

> Nigel.

Edited by: K M R on Feb 16, 2009 4:30 PM

former_member185071
Contributor
0 Kudos

Hi Nigel Blanchard It seems to be you have a daily load to a specified data target in the BI system which is bringing the data from SCM (APO) system . Due to some reason the date field is filling with incorrect values and realised that then you have manipulated some kind of logic in Transformations and now you want to load all the data request request ? right if the issue is this then probably you have to check the data is present in the PSA level or not if its avilable then just delete the contents of the target >>> Choose DTP select teh option DELTA >> FLAG Get request by request and then start loading so that it will fetches the records request by request and in the Target it will show all the requests and it wont miss the data.

If your question is different then please execuse and POST clear details so that our expertz can answer.. Hope its clear a little..! Thanks K M R ***"Make everything as simple as possible, but not simpler. Albert Einstein...!****

>

> Dear All BI Experts,

>

> We are implementing SCM5.1 with BI7.0

> We load a cube in BI with daily forecast data from APO, but unfortunately we have spotted one of the dates is wrong, so the data in the cube has been summing up incorrectly.

> That has now been fixed via the transformation, so what I want to do is reload the cube but with one Infopackage at a time (not all eight as are queued up now).

> Does anyone know how to load packages one by one?

> Any help will be greatfully received.

>

> Nigel Blanchard

Edited by: K M R on Feb 13, 2009 3:54 PM

Former Member
0 Kudos

Hi Nigel Blanchard

What do you mean by how to load info packages one by one.

If you are using a BI system,then while loading to cube it should be a DTP but not the infopackages,as infopackages load only upto PSA.

Regards

Jagadish

Former Member
0 Kudos

Please post your question only once in any of the BI forums.

Duplicate thread: