What is a cube in SAP?

An InfoCube is defined as a multidimensional dataset which is used for analysis in a BEx query. An InfoCube consists of a set of relational tables which are logically joined to implement the star schema. A fact table in the star schema is joined with multiple dimension tables.

Can a cube containing data be partitioned?

Partitions are a powerful and flexible means of managing cubes, especially large cubes. For example, a cube that contains sales information can contain a partition for the data of each past year and also partitions for each quarter of the current year.

What is Cube compression in SAP BI?

InfoCube Compression is used to Eliminate Zero values as key figures are contained in the infocube. zero Elimination is only permitted for infocubes where key figures with the aggregation behavior ‘sum’ exclusively occur, with non-cumulative values in particular you may not execute zero elimination.

What are different options of Repartioning of InfoCube in BI?

Steps for InfoCube Partitioning

• Step 1:- Time Characteristics. InfoCube partitioning is done at database level and can be based on one of the following date based info objects:
• Step 2:- Setup InfoCube Partitioning.
• Step 3:- Determine Partitioning Condition.
• Step 4:- Value Range.
• Step 5:- Maximum No of Partitions.

How is infocube partitioning done in SAP bi?

InfoCube partitioning is done at database level and can be based on one of the following date based info objects: Hence include either of these time characteristic in the InfoCube to be partitioned under the Time dimension as per the business requirement.

How to compress the cube in SAP bi?

SAP recommends compressing those requests in the InfoCube that are not likely to be deleted as soon as possible. Also compress aggregates as soon as possible. The InfoCube content is likely to be reduced in size, so DB-time for queries should improve. How to check in system? 1. Run the Program SAP_INFOCUBE_DESIGNS Refer Fig 2. 2.

How many dimensions can a SAP BW infocube have?

Similarly, SAP BW InfoCube can have a maximum of 16 dimensions, which means we can define 13 dimensions in addition to the three predefined dimensions. Each dimension can have up to 248 characteristics. SAP also delivers InfoCubes through the BW Content. They start with a number usually 0.

What are the different types of BIW cubes?

BASIC CUBE: 2 TYPES: These are physically available in the same BW system in which they are specified or their meta data exist. 3.1.1. STANDARD INFOCUBE: FREQUENTLY USEDStandard InfoCube are common & are optimized for Read Access, have update rules, that enable transformation of Source Data & loads can be scheduled 3.1.2.