Cube Dimension - Site

This cube dimension represents sites (contracts) and is based on the IFS Applications dimension DIM_SITE. All cubes that refers to this dimension will have the attributes and hierarchies as described below. The Maintenenace cube contains additional sites Organization Site, Source Site,  Actual Object Site and Reported Object Site with corresponding prefixes Source, Act Obj and Rep Obj respectively.

ATTRIBUTES

Attribute Hierarchy Description
Company NO Defined as COMPANY + ' - ' + NAME + ' (' + CURRENCY_CODE + ')', i.e. the company identity and name as well as the base currency code.
Company Code NO The identity of the COMPANY referenced by the a site (contract).
Company Name NO The NAME of the company references by the site.
Site NO Key. Defined as CODE + ' - ' + DESCRIPTION, i.e. site and its description.
Site Code NO The CODE of the dimension, i.e. site
Site Description NO The site DESCRIPTION
Site Description Code NO Defined as DESCRIPTION + ' - ' + CODE, ie. site description and the site
SiteHy YES Defined as "Company" -> "Site"

USED BY CUBE

Cube Name
MAINTENANCE
MANUFACTURING
PROCUREMENT
SALES
SALES CONTRACT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SITE_BI MPCCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.036 Load IFSAppl_DIM_SITE_BI.dtsx IFSAppl_DIM_SITE_BI
T - DW 2.1.036 Load Dw_DIM_SITE.dtsx Dw_DIM_SITE
L - DM 3.1.036 Load Dm_DIM_SITE.dtsx Dm_DIM_SITE