cancel
Showing results for 
Search instead for 
Did you mean: 

Why can't we delete the selective request from DSO as we can in Cube?

Former Member
0 Kudos

Hi BI Lovers,

Consider the scenario as:

We have some 10 requests in DSO as well as in Cube and the is no connection between the Cube and DSO.

When we want to delete the request number 6 we can delete from the Cube, but whenwe try to do the same from DSO it wunt allow us?

Requesting for some intellectual explanation.

Thanks

SDP

Edited by: SDPSAP on Nov 16, 2011 2:16 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello!

See, in Cube you have single request ID's and therefore you can select one and delete it. Cube is build to just aggregate data. Standard DSO (different to write optimized DSO) is build to deliver consistent delta to further data targets. Therefore you can not delete a single request in the middle of all the requests in DSO because the requests after this build on this request and could changed values to derive a new delta for an old value.

It is just possible to delete this request and all requests after this. So every request is calculated back with ChangeLog information. In the active table of the DSO, the exact information does not need to exist because later request could changed this value. If you delete ChangeLog information this would be bad in this situation...

Within a write optimized DSO it would be possible to delete any request (depending on settings).

Hope that helps you to understand.

Best regards,

Peter

Former Member
0 Kudos

Thanks Peter for a very lucid clear answer.Thanks a lot and seeking your future supportive answers.

Former Member
0 Kudos

And already Assigend Full Points

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Suppose:

We have 100 requests in DSO.

When we want to delete the request number 35 we can delete from the Cube, but whenwe try to do the same from DSO it wunt allow us?

This is because in cube it will just aggregate the data but in DSO the second request creates change logs and then the request created is totally based on the previous request so you cant delete the request from DSO in between.

But in infocube all requests are independent when you delete any one of the requests it will just disaggregates the quantity and delete the request.

Thanks and regards

Ankit Jain