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

Processchains - Automatic deletion of similar full loads

Hi

I have made a process chain that loads financial data into BW. Some of the plan data loads uses the full load method. Therefore it is neccesary to delete prior requests with the same selection criteria.

I have included a process to delete the requests in the process chain however this works very slowly ad there are aggreagates on the InfoCubes that need to be refreshed when loading the data.

Is there a smarter way to do this?

Chris

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2004 at 02:26 PM

    If you don't automatically compress the aggregates, then deletion out of aggregates will be fast and will not require rebuilding the aggregate. Query performance, however, may suffer, if aggregates are not compressed.

    You specify this in the Admin Workbench, right mouse on InfoCube, roll up, then remove the autocompress flag for aggregates.

    regards, KLaus

    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.