Cube Dimension - Account

This cube dimension represents the financial voucher related account and is based on the IFS Applications dimension DIM_ACCOUNT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

Natural parent is company, i.e. each company has its on set of account values.

Attributes

Attribute Hierarchy Description
Account NO Built as CODE + ' - ' + DESCRIPTION
Account Code NO Represents the CODE of the dimension, i.e. account
Account Group NO Represents the ACCOUNT_GROUP + ' - ' + ACCOUNT_GROUP_DESC related to an account
Account Group Code NO Represents the ACCOUNT_GROUP for an account
Account Group Desc NO Represents the ACCOUNT_GROUP_DESC related to an account
Account Type NO Represents the ACCOUT_TYPE + ' - ' + ACCOUNT_TYPE_DESC related to an account
Account Type Code NO Represents the ACCOUNT_TYPE related to an account
Account Type Desc NO Represents the ACCOUNT_TYPE_DESC related to an account
Company NO Represents the natural parent COMPANY
AccountHy YES Hierachy defined as "Company" -> "Account"
AccGroupHy YES Hierachy defined as "Company" -> "Account Group" -> "Account"
AccTypeHy YES Hierachy defined as "Company" -> "Account Type" -> "Account"

USED BY CUBE

Cube Name
MAINTENENCE
SALES

ETL Information

BI Access View Recommended
Source Type
BI component
DIM_ACCOUNT_BI On Line ACCRDI

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.001 Load IFSAppl_DIM_ACCOUNT_BI.dtsx IFSAppl_DIM_ACCOUNT_BI
T - DW 2.1.001 Load Dw_DIM_ACCOUNT.dtsx Dw_DIM_ACCOUNT
L - DM 3.1.001 Load Dm_DIM_ACCOUNT Dm_DIM_ACCOUNT