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.
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" |
Cube Name |
GENERAL LEDGER |
SALES |
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 |