Budgeting & Planning cube data: BPCMAIN

Source data for the BPCMAIN main Budgeting & Planning cube is loaded into a staging table. Stored procedures are used to validate the staged data and transform it so that it can be imported by Designer. Each data value is identified by references to the target element of each of the 26 dimensions which make up the BPCMAIN cube.

The process uses these tables and stored procedures:

• The staging table is DAT_BPCMAIN_STAGE.
• The stored procedure to validate staged data is depm_integration_bp_bpcmain_prepare_staging.
• The stored procedure to process staged data is depm_integration_bp_bpcmain.
• The output table is ATT_BPCMAIN (cube data table).

This table describes DAT_BPCMAIN_STAGE:

Field	Required	Description
PERIOD	Y	Period used with the time dimension; period and year are merged and displayed as PP_YYYY. For example, 01_2015. Opening balance (period 0) data is automatically assigned to 01 for only the first year with data within a configuration set/version combination. Other opening balance data is calculated by OLAP rules and should not be imported. Fiscal periods 13 – 16 data is automatically assigned to period 12.
YEAR	Y	Year used with the time dimension; period and year are merged and displayed as PP_YYYY. For example, 01_2015.
BPDENTITY	Y	Element from the Entity dimension.
BPDINTERCOMPANY	N	EXTERNAL is the standard value. For intercompany amounts only: entity ID for the internal trading partner. The account used must allow intercompany transactions.
BPDORGANIZATION	N	Base level element in the organization dimension. The default value is N.A.
BPDACCOUNT	Y	Base level element in the account dimension.
BPDCURRENCY	Y	ISO code of the base currency for the entity followed by _LC (local currency). For example, EUR_LC. Use N.A. for statistical accounts (type M or O) such as Volume that are not associated with a currency.
BPDDETAIL	N	Base level element in the detail dimension. Not applicable in most source systems. The default value is N.A.
BPDPSEGMENT	N	Base level element in the primary segment dimension if applicable (and if the account used allows segment 1 values). The default value is N.A.
BPDSSEGMENT	N	Base level element in the secondary segment dimension if applicable (and if the account used allows segment 2 values). The default value is N.A.
BPDTSEGMENT	N	Base level element in the tertiary segment dimension if applicable (and if the account used allows segment 3 values). The default value is N.A.
BPDANALYSIS_01	N	Base level element in the analysis_01 dimension. The default value is N.A.
BPDANALYSIS_02	N	Base level element in the analysis_02 dimension. The default value is N.A.
BPDANALYSIS_03	N	Base level element in the analysis_03 dimension. The default value is N.A.
BPDANALYSIS_04	N	Base level element in the analysis_04 dimension. The default value is N.A.
BPDANALYSIS_05	N	Base level element in the analysis_05 dimension. The default value is N.A.
BPDANALYSIS_06	N	Base level element in the analysis_06 dimension. The default value is N.A.
BPDANALYSIS_07	N	Base level element in the analysis_07 dimension. The default value is N.A.
BPDANALYSIS_08	N	Base level element in the analysis_08 dimension. The default value is N.A.
BPDANALYSIS_09	N	Base level element in the analysis_09 dimension. The default value is N.A.
BPDANALYSIS_10	N	Base level element in the analysis_10 dimension. The default value is N.A.
BPDANALYSIS_11	N	Base level element in the analysis_11 dimension. The default value is N.A.
BPDANALYSIS_12	N	Base level element in the analysis_12 dimension. The default value is N.A.
AMOUNT	Y	Numeric data amount stored as a string; amounts are generally in the functional currency for the entity. BP core stores period movement amounts; normal amounts for expenses (account type E) are stored as negative numbers. Normal amounts for all other account types are positive numbers.