Creating InfoCubes
Use
An InfoCube is a type of InfoProvider. From an analysis point of view, an InfoCube describes a self-contained dataset, of a business-oriented area for example.
An InfoCube is comprised of a set of relational tables arranged according to the enhanced star schema: a large fact table in the middle surrounded by several dimension tables.
More information: Enhanced Star Schema
The data in an InfoCube is stored either physically or in BW Accelerator. The InfoCube receives the data via a data transfer process. It is then available as an InfoProvider for analysis and reporting purposes.
Procedure
...
1. Follow the general procedure for creating an InfoProvider. All InfoCube-specific settings are described below.
More information: Creating InfoProviders
2. In the creation dialog box, select either Standard or Real-Time as the InfoCube type.
More information: Real-Time InfoCubes
3. In the Choose BWA Status field, you can specify whether to store the data for standard InfoCubes on the database or in the BWA.
More information: InfoCubes with Data Persistence in the BWA
4. For standard InfoCubes, you can specify that the InfoCube should be semantically partitioned.
More information: Using Semantic Partitioning.
5. Details and object-specific properties:
If you double-click an InfoObject, the detail display for this InfoObject appears. In the context menu of an InfoObject, you can make additional settings under Object-Specific Properties.
For more information, see Structure-Specific Properties of InfoObject in Additional Functions in InfoCube Maintenance.
6. Create dimensions: The data package, time, and unit dimensions are offered in the standard setting. The data package dimension contains technical characteristics. Units are automatically assigned to the corresponding dimensions. You have to assign time characteristics manually. In the context menu for the Dimensions folder, you can create additional dimensions under Create New Dimensions.
More information: Dimensions
If a dimension only has one characteristic or has a large number of attributes, you need to set the Line Item or High Cardinality indicator. More information: Line Item and High Cardinality.
7. Save or Activate the InfoCube.
Next Step