Cube Dimension - Taxcode

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.

ATTRIBUTES

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

USED BY CUBE

Cube Name
GENERAL LEDGER

ETL Information

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