Chapter 12. Data Maintenance

So far we have built a simple BW system and loaded data into it. Now suppose the business has changed, so that the characteristic data will change as well. If we modify the characteristic data, what will happen to the InfoCube, aggregate, and ODS object data that depend on the characteristic data? In this chapter we will answer this question and several others:

  • How do we delete InfoCube data?

  • How do we maintain indices and statistics?

  • How do we manage individual data load requests?

  • How do we automate aggregate rollup?

  • Can we compress multiple data load requests into one request? How?

We start from the first question, how to deal with changed characteristic data.

Maintaining Characteristic Data

If characteristic data have been ...

Get SAP® BW: A Step-by-Step Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.