Delta's

[Former Member]

Hi Friends

I have 2 doubts.

1.I've a full load from R/3 into ODS and delta from ODS into Cube.

Now I want to delete the data on ODS after delta loaded into cube.

How can I do that?

2. I've a delta load from R/3 loading into ODS and delta loading from ODS inot cube.

Here too I want to delete the data on ODS.

How can I do that?

I've tried but it's prompting me to do Init load .

Points will be assigned for the right answers...

Regards,

Chama.

[Former Member · Accepted solution]

Hi,

Usually it allows to delete the data in ODS irrespective to the update type. can you please give still more information on the message provide by system.

Regards,

Vishwa

[Former Member · Accepted solution]

Hi

I've loaded data from R/3 into ODS and loaded into Cube using delta.Now I deleted the contents of ods and loaded again and updating into cube but it's allowing me to do either Full load or INIT load only. Why it's not allowing to do delta into cube?

How can I do delta ?

Regards,

Chama.

[Former Member · Accepted solution]

because by deleting the data in ODS you have disrupted the delta setting to the cube.

\

The pointers to the deltas have been lost. So unless you do reinit you cannot do deltas.

or delete data in the cube and then do deltas.

[Former Member · Accepted solution]

Hi

Is it possible to delete contents of ODS after the data loaded into cube without disrupting the delta to cube?

I'm just explaining my problem.

We are loading data from R/3 into ODS and into Cube and reporting will be done on cube level.Due to space issue we want to delete the data on ODS since it's updating into cube.We are in a procedure to delete data from all the ods because we dont use that data and it's occupying the space and everytime we are kept adding more gigs to the sysyem.

One of our ODS occupied 15gig space on hard drive.That's why we want to delete data on ODS objects.

What's the best way to delete data from ODS without effecting the cube loads?

Regards,

Chama.

Edited by: SAP BI on Sep 2, 2008 4:14 PM

Edited by: SAP BI on Sep 2, 2008 4:19 PM

[Former Member · Accepted solution]

Hi,

If you delete the data from the source then initialization option(which u can see in the infopackages) gets deleted.

So there is no longer init between the source DSO and the target cube.

Also why u want to delete the data from the DSO it will affect the delta to the cube

just make sure that u delete very old data which is not changing or is not required for reporting.

wht u are trying to do is not possible.

Since if you will delete the requests from the DSO then the next delta from the R/3 will look for the last delta request which was loaded into DSO and for the delta mechanism it is correct and should be present in the target.

and if you delete the whole data from the DSO then you will have to a new initiallization to the DSO or you will not be able to load the delta to the DSO only.

And if you are doing a new delta to DSO then you can also do a new init to the cubes as well.

but in this case u will have to make sure that u dont miss any delta to the DSO...so u can try it on some holiday when u are sure that no new records is getting created in R/3.

Thanks

Ajeet

[Former Member · Accepted solution]

Hi

So there is no way to get ride of unused data from ODS since the same data sitting on Cube.

It's acquired lots of extra gig space to load the data.So keep on adding more space to the system or is there any other way to get ride of this?

Regards,

Chama.

[Former Member · Accepted solution]

Hi,

You can save disk space by deleting Change logs and PSA of the ODS.

Hope this helps.

[Former Member]

You need to initialize you ods without data trasfer. You will get this option in Infopackage.

Thanks...

Shambhu

[Former Member]

Thats right...ods must have init. Initialize tyhe ods without dat transfer. It will just update the initialization. After that, you can delete the data in both cases.

Thanks...

Shambhu

[Former Member]

Hi Shambhu

Thanks for your quick reply.

I didn't get you. Please explain me clearly.

Regards,

Chama.