Managing InfoCubes 

Use

You can display technical information on the content of the InfoCube using the function Manage InfoCube. You can carry out administrative tasks, such as constructing aggregates and deletion for an individual InfoCube. You can influence the load and query performance by using the InfoCube content maintenance.

Prerequisites

An active InfoCube is available.

Functions

The InfoCube is displayed in the top table. You only have to make one selection from several InfoCubes if you got to the InfoCube management screen from the Scheduler or Monitor.

After you have selected an InfoCube from the table in the upper half of the screen, you can display the InfoCube contents by choosing Contents in the toolbar. If you have not selected an InfoCube, you can display any number of dictionary tables relevant to InfoCube administration. Enter the table name in the subsequent dialog box. Change Update Rules brings you to the maintenance screen for the update rules. Delete Contents removes the contents of the InfoCube. You can also display an application log and a process overview.

Content of the InfoCube

You can display the dimensions of an InfoCube with the InfoObjects that belong to them.

Using Cube or Fact Table, you can display the content of the InfoCube and of the fact table, and also delete them if necessary.

Performance

Here you can find the options that allow you to affect not only the load performance but also the query performance. For information about this, read InfoCube Performance.

Requests in the InfoCube

You get information on all requests that have run in the InfoCube and you can, where necessary, delete requests once again. For information about this, read Requests in the InfoCube.

Rolling up the InfoCube

You can start rolling up the requests for restructuring aggregates immediately or in the background. You can display already existing aggregates for the InfoCube and the logs that belong to them.

If activated aggregates exist for the InfoCube and you are loading new requests into the InfoCube, you also have to roll up these in the aggregates. Only then are these new requests taken into account when executing a query.

For more information see Rolling Up Data into an Aggregate.

Automatic Subsequent Processing

You can make the following automatic settings for the subsequent processing of InfoCubes:

·        Set the quality status to OK

·        Automatically roll-up

·        Automatically compress

You can find additional information under Automatic Subsequent Processing and Efficiently Loading Data into Aggregates.

Reconstructing the InfoCube

You can reconstruct an InfoCube from the requests that are already uploaded. You can use these requests for reconstructing the current InfoCube or for constructing another InfoCube.

See also:

Scheduler

Monitor