Procedure documentation Partitioning InfoCubes using the Characteristic 0FISCPER Locate the document in its SAP Library structure

Use

You can partition InfoCubes using two characteristics – calendar month (0CALMONTH) and fiscal year/period (0FISCPER). The special feature of the fiscal year/period characteristic (0FISCPER) being compounded with the fiscal year variant (0FISCVARNT) means that you have to use a special procedure when you partition an InfoCube using 0FISCPER.

Prerequisites

When partitioning using 0FISCPER values, values are calculated within the partitioning interval that you specified in the InfoCube maintenance. To do this, the value for 0FISCVARNT must be known at the time of partitioning, that is, it must be set to constant.

Procedure

  1. Set the value for the 0FISCVARNT characteristic to constant. Carry out the following steps:
    1. Call the InfoSet maintenance from Administrator Workbench: Modeling by double clicking on the InfoCube that you want to partition. You reach the Edit InfoCube: Characteristics screen.
    2. Choose the Time Characteristics tabstrip.
    3. Choose Extras -> IC Specific Properties of InfoObject. InfoObject Properties You get to the Structure-Specific Properties dialog box.
    4. Specify a constant for the characteristic 0FISCVARNT. Choose Continue.
  1. Choose Extras -> Partitioning. You get to the Determine Partitioning Conditions dialog box. You can now select the 0FISCPER characteristic under Slctn. Choose Continue.
  2. You get to the Value Range (Partitioning Condition) dialog box. Enter the required data. For more information, see Partitioning