Show TOC

Function documentationImport Hierarchies from an SAP BW InfoObject Locate this document in the navigation structure

 

You can define a Data Manager package to import external hierarchies defined in an SAP NetWeaver BW InfoObject for use in Planning and Consolidation using the process chain /CPMB/IMPORT_IOBJ_HIER.

Features

The following features are supported:

  • Import hierarchy — Overwrites the whole hierarchy tree using the new imported hierarchy tree

  • Load hierarchy from the specified member taken as the root to the specific level

  • Load time-dependent — Reads the hierarchy by the given key date

  • Version-dependent — Reads the hierarchy by the given key version

  • Text node — The system does not support text nodes. If there are text nodes that need to be imported, import them as members first. The transformation file can be used for attribute values when creating members for these text nodes.

  • Input levels of the source hierarchy

  • Transform and convert hierarchies from source into target format and target members. If the hierarchies are in different structures and are related, you must write a transformation file to make the hierarchies satisfy the requirement of the Planning and Consolidation hierarchy.

Planning and Consolidation hierarchy rules are the following:

  • A calculated member cannot be a parent node.

  • The parent node in different hierarchies must have the same children nodes.

Note Note

Delta and packaging are not supported. The precondition is that all necessary masterdata has existed in the target.

End of the note.

Activities

  1. Create a Data Manager package by using the process chain /CPMB/IMPORT_IOBJ_HIER (see Package Usage).

  2. Run the Data Manager package as follows:

    1. Log on to the Planning and Consolidation Office module.

    2. On the action pane, choose   Manage data   Run a package  .

    3. Choose the package created in step 1 and choose Run.

    4. Enter the technical name of the SAP NetWeaver InfoObject.

      Note Note

      Expect a long runtime if the Select button to select the SAP NetWeaver InfoObject is being used for the first time.

      End of the note.

    5. Set the selection to filter the hierarchy to be uploaded and set the member filter, level, and the key date, if needed.

    6. Choose the format.

      The external format calls the Output conversion routine of the InfoObject. The internal format does not call the Output conversion routine.

    7. Choose a transformation file (see the example below and Hierarchy Transformation Example).

    8. Choose one of the following options:

      • Run now

      • Schedule

      • Run now & schedule

    9. Choose Finish.

You can change the default package instructions (see Modifying the Dynamic Script of a Package).

Dynamic script task parameters

Task

Parameter

Default Value

Description

/CPMB/IOBJ_SOURCE_HD_CONVERT

DIMNAME

Dimension name

/CPMB/IOBJ_SOURCE_HD_CONVERT

SPACKAGE_SIZE

40.000

Package size

/CPMB/IOBJ_SOURCE_HD_CONVERT

TRANSFORMATIONFILEPATH

Transformation file

/CPMB/BW_IOBJ_HIER_SOURCE

INFOOBJECT

Technical InfoObject name

/CPMB/BW_IOBJ_HIER_SOURCE

MASTERDATA_FORMAT

Conversion exit

1 = No conversion

0 = Conversion Executed

/CPMB/BW_IOBJ_HIER_SOURCE

MASTERDATA_SELECTION

INTERNAL data selection

/CPMB/BW_IOBJ_HIER_SOURCE

SPACKAGE_SIZE

40.000

Package size

/CPMB/BPC_HIER_DATA_TARGET

DIMNAME

Dimension destination

/CPMB/BPC_HIER_DATA_TARGET

SPACKAGE_SIZE

40.000

Package size

Example Example

PROMPT(HIERARCHYSELECTION,%INFOOBJECT%,"%SELECTION%",Please select the infoobject and the selection,,)

PROMPT(RADIOBUTTON,%FORMAT%,"Choose format.",1,{"Internal Format","External Format"},{"1","0"})

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(DIMENSIONNAME,%DIMNAME%,"Dimension name:",,,%DIMS%)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TEMPNO3%,%INCREASENO%)

TASK(/CPMB/BW_IOBJ_HIER_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/BW_IOBJ_HIER_SOURCE,INFOOBJECT,%INFOOBJECT%)

TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_FORMAT,%FORMAT%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,FORMULA_FILE_NO,%TEMPNO2%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SUSER,%USER%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SAPP,%APP%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,DIMNAME,%DIMNAME%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,OUTPUTNO,%TEMPNO3%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,INPUTNO,%TEMPNO1%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,INPUTNO,%TEMPNO3%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,DIMNAME,%DIMNAME%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO2%)

End of the example.