This cube dimension represents tax codes and is based on the IFS Applications dimension DIM_TAXCODE. 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 tax codes.
Attribute | Hierarchy | Description |
Company | NO | Represents the natural parent COMPANY |
Tax Code | NO | Built as CODE + ' - ' + DESCRIPTION |
Tax Code Code | NO | Represents the CODE of the dimension, i.e. tax code |
Tax Code Descr | NO | Represents the DESCRIPTION of the tax code |
Tax Code Fee Rate | NO | Represents FEE_RATE as percetage |
Tax Code Fee Type | NO | Represents FEE_TYPE_DESC,i.e. description of FEE_TYPE |
Cube Name |
GENERAL LEDGER |
BI Access View | BI Component | Recommended Source Type |
DIM_TAXCODE_BI | ACCRDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.064 Load IFSAppl_DIM_TAXCODE_BI.dtsx | IFSAppl_DIM_TAXCODE_BI |
T - DW | 2.1.064 Load Dw_DIM_TAXCODE.dtsx | Dw_DIM_TAXCODE |
L - DM | 3.1.064 Load Dm_DIM_TAXCODE.dtsx | Dm_DIM_TAXCODE |