Cube Dimension - Voucher Type

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

Natural parents are company and ledger id, i.e. each company has ledgers that have its on set of voucher types.

ATTRIBUTES

Attribute Hierarchy Description
Company NO Represents the natural parent COMPANY
Ledger Id NO Represents the secondary parent key ledger id
Voucher Type NO Built as CODE + ' - ' + DESCRIPTION
Voucher Type Code NO Represents the dimension CODE, e.g. voucher type.
Voucher Type Desc NO Represents the description of a voucher type.
VoucherTypeHy YES Define as "Company" -> "Ledger Id" -> " Voucher Type"

USED BY CUBE

Cube Name
GENERAL LEDGER
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_VOUCHER_TYPE_BIo ACCRDI Data Mart

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.076 Load IFSAppl_DIM_VOUCHER_TYPE_BI.dtsx IFSAppl_DIM_VOUCHER_TYPE_BI
T - DW 2.1.076 Load Dm_DIM_VOUCHER_TYPE.dtsx Dw_DIM_VOUCHER_TYPE
L - DM 3.1.076 Load Dm_DIM_VOUCHER_TYPE.dtsx Dm_DIM_VOUCHER_TYPE