Cube Dimension - Price Adjustment

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

ATTRIBUTES

Attribute Hierarchy Description
Company Id NO Company
Currency Code NO  
Fixed Value Internal Price NO  
Fixed Value Sales Price NO  
Precentage Internal Price NO  
Precentage Sales Price NO  
Price Adjustment NO Key. Displayed as COMPANY + ' - ' + PRICE_ADJUSTMENT_ID + ' - ' + PRICE_ADJUSTMENT_NAME
Price Adjustment Id NO Identiy in IFS Applications
Price Adjustment Name NO Name of the price adjustment
Valid From NO Valid from date
Valid Until NO Valid until date

USED BY CUBE

Cube Name
PROJECT

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.121 Load IFSAppl_DIM_PRICE_ADJUSTMENT_BI IFSAppl_DIM_PRICE_ADJUSTMENT_BI
T - DW 2.1.121 Load Dw_DIM_PRICE_ADJUSTMENT Dw_DIM_PRICE_ADJUSTMENT
L - DM 3.1.121 Load Dm_DIM_PRICE_ADJUSTMENT Dm_DIM_PRICE_ADJUSTMENT