Cube Dimension - Proj Billing Category

This cube dimension represents billing category information in Project Reporting based on the IFS Applications dimension DIM_PROJ_BILLING_CATEGORY. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Company Id NO Company
Proj Billing Category NO Key. Displayed as COMPANY_ID + ' - ' + PROJECT_ID + ' - ' + CODE + ' - ' + BILLING_CATEGORY_DESCRIPTION
Proj Billing Category Code NO Billing category (the code)
Proj Billing Category Description NO Description of billing
Project Id NO Project identity

USED BY CUBE

Cube Name
PROJECT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_PROJ_BILLING_CATEGORY_BI PRJRDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.122 Load IFSAppl_DIM_PROJ_BILLING_CATEGORY_BI IFSAppl_DIM_PROJ_BILLING_CATEGORY_BI
T - DW 2.1.122 Load Dw_DIM_PROJ_BILLING_CATEGORY Dw_DIM_PROJ_BILLING_CATEGORY
L - DM 3.1.122 Load Dm_DIM_PROJ_BILLING_CATEGORY Dm_DIM_PROJ_BILLING_CATEGORY