Cube Dimension - Posting Type

This cube dimension represents the group consolidation posting type and is based on the IFS Applications dimension DIM_GROCON_POSTING_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

The posting type is a stand alone item, independent of company.

ATTRIBUTES

Attribute Hierarchy Description
Posting Type NO Key. Built as CODE + ' - ' + DESCRIPTION
Posting Type Code NO Represents the CODE of the dimension, i.e. Posting Type Code value
Posting Type Desc NO Represents the DESCRIPTION of the Posting Type

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_GROCON_POSTING_TYPE_BI GROCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.174 Load IFSAppl_DIM_GROCON_POSTING_TYPE_BI.dtsx IFSAppl_DIM_GROCON_POSTING_TYPE_BI
T - DW 2.1.174 Load Dw_DIM_GROCON_POSTING_TYPE.dtsx Dw_DIM_GROCON_POSTING_TYPE
L - DM 3.1.174 Load Dm_DIM_GROCON_POSTING_TYPE.dtsx Dm_DIM_GROCON_POSTING_TYPE