Creating Local Dimensions

By leveraging Business Warehouse workspace concepts and extending Business Planning and Consolidation local providers, you can generate local dimensions, which are named local InfoObjects in BW. The central InfoObject mentioned here is the corresponding global InfoObject in Business Warehouse.

Prerequisites

A central BW InfoObject, known as the central dimension, can be used as a reference to create a local InfoObject - a dimension - when all of the following prerequisites have been met:

  • The InfoObject is not authorization relevant.

  • The InfoObject has master data.

  • • The InfoObject should be assigned to an InfoArea and exposed as an InfoProvider in BW. You can check this via the InfoArea section in the global InfoObject’s Master Data/Texts page. Go to Transaction RSA1, then choose Start of the navigation pathModeling Next navigation step InfoObjectsEnd of the navigation path. Select the target central InfoObject and navigate to the Master Data/Texts tab.

  • The referenced BW workspace must have the setting Creation of Master Data Allowed turned on. To activate this setting, enter Transaction RSWSPW, search for the referenced BW workspace and go to the Settings tab of the workspace.

    Note
    The Creation of Master Data Allowed option is by default not checked when a new workspace is created. To change this behavior, go to transaction RSBPCADMIN and set the value of parameter WSP_SIDX to “X”.

  • The central InfoObject is assigned to the central providers list in the current workspace (environment). To make sure of this, go to Transaction RSWSP, input the current environment ID as the Workspace ID and click Display. Then, click the Central Providers tab and check if the target central InfoObject is listed there. If not, click the Build InfoProvider Selection button, select the target central InfoObject, drag it to the central providers list on the right, and activate the modification.

Context

A local dimension inherits all the metadata and master data from its central InfoObject. All changes to master data made in central InfoObjects are automatically reflected in the local dimension if they are not overwritten by subsequent changes to local dimension.

After generating a local dimension from the original central InfoObject, you can rename the member ID or change the attribute value. You can also add to the local dimension new attribute values, such as new members that do not exist in the central InfoObject. The new attribute value is visible only in the local dimension and overwrites the property value inherited from the global BW InfoObject.
Note
A central InfoObject can have only one local inherited version of the InfoObject within one Business Planning and Consolidation environment.

Procedure

  1. Go to Administration and choose Dimensions under Modeling.
  2. In the dimension list, select one central dimension, whose visibility needs to be Central, from which no local dimension has been created.
  3. Click Create Local, enter a description, and click OK. Then, enter the dimension structure view of the local dimension you are creating.
  4. Add new attributes and remove existing attributes.
  5. Click Save to finish creating the local dimension.
Related Information