Create #SAP #BW Housekeeping task list

[MGrob]

Applies to SAP BW 7.31

This document describes how you install the housekeeping task list for BW systems.

If you are on SAP NW BW 7.31 SPS8 you can go straight to Tx STC01 step.

A lot of so called "housekeeping" task are done manually now or in processchains like repair indexes and cleanup statistical data. SAP has delivered a task list that can handle things like that.

The Housekeeping task list can assist you with the following tasks:

• Repairs indices on InfoCube fact table(s) at the Data Dictionary level
• Re-assign requests written into the incorrect PSA partition
• Ensure request consistencies throughout the PSA landscape
• Ensure partitioned tables are correctly indexed for the PSA
• Verify DataSource segments assignment to PSA
• Checks BW metadata with regard to the DDIC
• Deletes the entries that are no longer required in table RSIXW
• Reorganize and delete bookmark IDs and view IDs
• This program deletes RSTT traces
• This program deletes BW statistical data
• Delete Aggregate data via deactivation
• Clear all OLAP Cache parameters

How do you implement the list?

First things first: Read Note 1829728.

“This note contains the necessary coding required for the SAP_BW_HOUSEKEEPING task list
creation. This task list can be used to facilitate some of the BW system's
routine housekeeping activities and should be run on a regular basis.”

You need your SAP Basis help for this implementation!

1) First follow the document attached in the note called PCAI_Guide.pdf. This is a basis task.

2) Once done with this you need to install Report ZNOTE_1829728_PRE.TXT. Create the program ZNOTE_1829728_PRE
and copy/paste the code from the note or from my attachment. (If you have an OSS account you might want to get it from the note to have the most recent one)

3) In the attributes Pop-up please enter description and 'Executable program' as type.

4) Execute now the PRE steps.

Choose your transport layer and do an update.

Use the same transport request as for the rest of the manual activities and the corrections of this note. You don’t need to transport the programs you have just created, but the objects, which were generated by the report.

Now create the post report ZNOTE_1829728_POST_70X or ZNOTE_1829728_POST_73X depending on your
release. Proceed the same way as above.

Execute it in testrun. If you get an error the note – or one of the prerequisites have not been done. 

From the Note:

“The program will automatically create several objects like Package, Function Group, Error messages, Task lists and will prompt you for a transport request. Please use the same transport request as for the rest of the manual activities and the corrections of the note. “

Make sure all changes are collected on the same transport.

Once installed go into Tx STC01

The task list is called SAP_BW_HOUSEKEEPING

Select the steps you want to execute. Most of them only run in background mode due to their long run time. You can schedule the housekeeping items on periodic basis.  Most of the task can also be run in a check mode only.

Each step is explained when you click on the document icon at the end. A couple steps are Repair related while others are for Cleanup purposes.

All in all a great tool to fix some of the db related issues that keep happening in a BW environment. The same applies for all cleanup steps that BW needs!

EDIT: You can also refer to the new SAP Guidance on Housekeeping that came out SAP First Guidance - BW Housekeeping and BW-PCA or to SAP NetWeaver BW Application Lifecycle Manageme... | SCN