Skip to Content
author's profile photo Former Member
Former Member

Delete Request in InfoCube

I would like to delete all the Request in the InfoCube and do the re-load from ECC6.

I right-click InfoCube ->Delete Content, then it will prompt me the following:

Do you want to delete the contents of this InfoCube?

I click Yes, then it prompt me the following:

Do you want to keep the data in the dimension

tables?

I click No

Is it correct to choose No?

What is the different between this Delete Contents if I delete all the Request manually in InfoCube ->Manage ->Request tab?

What happen if the Request has been compressed and also roll-up to Aggregate?

Which option should I use - 1) right-click InfoCube ->Delete Data or 2) Delete the Request one by one via InfoCube ->Manage ->Request tab?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Apr 14, 2010 at 09:04 AM

    Hello Lynn,

    Deleting the Dimensions or keeping then depends on if the data you load again will be similar to what you deleted. Since

    the data loaded are normally very equal to the data you loaded before it makes sense to keep the Dimension tables

    and than most SIDs/DIMIDs in the Dimensions are existing and the loading is faster.

    If you want to 'cleen up the cube complety though (maybe you completey redesign it) then its better to delete the

    Dimensions. If you keep dimemsions you also need to check that there ratio to the size of the fact table do not

    get too large, you can check this by executing the Transaction RSRV >Transaction Data > Multiple Entries

    in Dimensions of a (Basis) InfoCube and Entries Not Used in theDimension of an InfoCube.

    If you manually delete the entries from the fact table the difference is that the data will not be deleted from

    the E fact table (this is where the compressed data is stored).

    If you want to delete all data from the cube then the best option to use is to right click on the cube and select the

    option "delete data".

    Best Regards,

    Des

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 15, 2010 at 04:09 AM

    no answer

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.