System dimensions

BPDPARAMETER

This dimension is the central configuration dimension. It provides base selection structures, required parameter definitions, and sub plan information.

The dimension has been implemented to organize the global configuration. With regard to the integration of additional sub plans and customer-specific extensions, the dimension currently contains more information as required for the Budgeting & Planning application.

Sub plan parameter:

The first level of the Subplan Parameter section provides a list of the sub plans that are integrated in the Budgeting & Planning application. This list can be used, for example, for any listing of available sub plans within the application. Each sub plan provides a similar structure:

  • The name of the sub plan element. For example, SUBPLAN_SALES.
  • An account section of required account types for the sub plan, for example, cash account or revenue account under SUBPLAN_SALES_ACC.
  • An additional section of required parameters related to the sub plan. For example, SUBPLAN_SALES_PARAM.

Account definition (_ACC):

Each sub plan needs different types of accounts where calculated values will be transferred to in the main cube of Budgeting & Planning. This list is used for pre-selection of accounts, which will be available within the specific sub plan configuration or even the planning itself. In the global configuration view, Sub Plan Account Assignment, you can assign accounts to the different types of accounts mentioned in the list. The list view provides the available sub plans, except finance. After selecting a sub plan, the list provides all defined account types for a pre-selection of accounts.

Parameter definition (_PARAM):

Each sub plan needs additional parameters such as activations within the sub plan-specific configuration. All required parameters can be listed centrally as part of this section of the dimension, for example, in the view Cost Group Overview / Account Assignment.

Global Parameter:

In the section of the global parameters, a list of required parameters mainly for the configuration set and entity configuration is provided. In addition, the configuration of premises/assumptions, global selection structures, forecast, version and activation of modules and dimensions are available. This section is directly linked to different application functions and should not be changed. Additional requirements should be integrated as sub plans. Therefore, required parameters must be integrated in the Subplan Parameter section.

Global Feature Parameter:

In the section of the global feature parameters, a list of required feature parameters is provided.

Related information:

The dimension is part of the BPCCONFIG cube to provide access to the dimension. Additionally, the dimension is part of a couple of sub plan-specific configuration cubes to provide selection structures and store configuration data, especially in the sub plan parameter section _PARAM.

Interaction with sub plans:

During the design of a sub plan, an additional section per sub plan should be added. For example, sales.

BPDLANGUAGE

This dimension provides all system languages set up in Designer. The language dimension is currently used to store translations as values in the configuration cubes.

BPDNO

This dimension is a placeholder dimension. The placeholder dimension is used to set up several lists of items as financial planning steps or cost and sales groups.

Currently, the number of Financial Planning Steps is limited by 100 items within the application. This number can be raised manually in Designer.

  1. Start Designer.
  2. Go to the Configuration folder.
  3. Click Flexible Elements.
  4. Add the desired elements.

Interaction with sub plans:

The placeholder dimension can be used for sub plans. For example, set up a new request, loan, or investment and use the next available element of the placeholder dimension.

BPDDCONFIGURATION

This dimension includes the Designer settings elements, the system elements, the top account elements, and the common settings elements.

BPDCONFIG_SALES

This dimension includes system parameters for the sub plan sales. For example, the sales planning status elements.

BPDCONFIG_SALES_GROUP

This dimension includes system parameter for the sales groups.

BPDCONFIG_SALES_MEASURE

This dimension includes system parameters for defining cost and sales groups.

BPDCONFIG_PHASING

This dimension includes the phasing methods elements.

EXDTYPE

This dimension contains two elements OPENING_BALANCE, to differ opening balance exchange rates in first periods from other exchange rates (MOVEMENTS element).

EXDRATE

This dimension includes the exchange rate types.

EXDCCURRENCY

This dimension includes the company currencies. This is automatically created by defining currency settings (by recreating the dimension or the OLAP database).

EXDGCURRENCY

This dimension includes the group currencies. This is automatically created by defining currency settings and includes the defined group currency (by recreating the dimension or the OLAP database). There can only be one defined group currency. All local currencies are underneath an additional parent.

BPDNAVIGATION

This dimension includes the navigation. This dimension is now enabled for permission. By default, the permission cube #BPDNAV is enabled and in use, default permission are added for standard repository roles. These attributes must be set:

  • ACTIVE. Active reports: 1 means activated (visible).
  • ReportUN. UN name of the reports should be stored here.
  • REPORTTYP. Reports or Dashboard: type should be stored:
    • R - report
    • D - dashboard
    • DR - dashboard with report navigation

BPDPREMISE

This dimension includes the account assumptions.

PWORKFLOWSTEPS

This dimension in only used for sales workflow.

ALDDIMENSION

This dimension includes the main dimensions to be used in allocations.

ALDITERATION

This dimension includes the iterations to be used in allocations.

GSDDATALAYER

This dimension includes global sign definition elements.