Cube Dimension - Configuration Spec

This cube represents the dimension part configuration specification and is based on the IFS Applications dimension DIM_CONFIGURATION_SPEC.

ATTRIBUTES

Attribute Hierarchy Description
Configuration Code NO The dimension CODE, i.e. configuration identity
Configuration Descr NO The description of the part configuration identity (DESCRIPTION)
Configuration Part No NO Represents the part number (PART_NO)
Configuration Spec NO Key. Defined as PART_NO + ' - ' + CODE + ' - ' + DESCRIPTION and represented by ETL specific column PART_NO_CODE_DESCRIPTION

USED BY CUBE

Cube Name
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_CONFIGURATION_SPEC_BI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.022 Load IFSAppl_DIM_CONFIGURATION_SPEC_BI.dtsx IFSAppl_DIM_CONFIGURATION_SPEC_BI
T - DW 2.1.022 Load Dw_DIM_CONFIGURATION_SPEC.dtsx Dw_DIM_CONFIGURATION_SPEC
L - DM 3.1.022 Load Dm_DIM_CONFIGURATION_SPEC.dtsx Dm_DIM_CONFIGURATION_SPEC