Performing check and potential update for status control table

[Former Member]

Cheers Experts,

I searched in the forum, but I didn't find an answer.

I'm working on a 3.0B BW system.

After updating from PSA to an ODS, in the log I see the following line:

"Performing check and potential update for status control table" and double clicking on it, it says:

-

---

If data is loaded into an InfoCube, or existing data is edited (aggregated/compressed/deleted/got from a DataMart), then there is a change in the potential reportability of the data , or the possibility of deleting data by request, or of aggregating or compressing.

This status of each one of these Cubes is stored in a status table, that is updated when there is any change to the status of a request in the Cube.

The system now analyzes the requests in the Cube and compares the calculated status with the status table.

If deviations from the status table arise then you are given the option of adjusting the status table.

-

---

I have 2 questions:

1) What is BW doing, mainly because I'm working on an ODS and not an Infocube?

2) What can I do to reduce its execution time, since it lasts several minutes?

Thanks and greetings.

Roberto

[Former Member]

Any help?

[rick_markowski]

Roberto, did you ever find an answer to your question?  We also are experiencing long runtimes during this particular process running 3.x deltas from ODS to ODS and cubes.