Cube - Sales Contract

Contents

Usage/Purpose

 Main analysis scenarios are:

To see which dimensions that can be used with each fact in, for example Excel pivot analysis, see section Fact and Dimension Connections below.

Configurations

The Sales Contract cube supports calculation of base currency amounts to a reporting currency. To make this work it is necessary to create/select a currency rate type in one company as the rate source. The relevant configuration lookup must also be defined.

Refer technical documentation for more information.

Limitations

The Sale Contract cube supports calculation of base currency amounts to a reporting currency. To make this work it is necessary to create/select a currency rate type in one company as the rate source. The relevant configuration lookup must also be defined.

Refer technical documentation for more information.

Overview Facts

Cube Fact (Dsv name) Measure Group Referenced Information Source BI Access View Access Type
FACT_SALES_CONTRACT_ITEM CONTRACT ITEM FACT_SALES_CONTR_ITEM FACT_SALES_CONTR_ITEM_BI_OPT On Line
FACT_REPORTING_CURRENCY RATES REPORTING CURRENCY RATES FACT_CURRENCY_RATES FACT_CURRENCY_RATES_BI_OPT On Line

Each measure in the facts is described in section Measures. Corresponding Information Sources are described below. Detalled infomation about Information Sources can be found in IFS Online Documentation

FACT_SALES_CONTRACT_ITEM
Sales Contract Item information source is based on IFS\Contract Items. Some report examples that might be created based on sales contract item:

Overview Dimensions

Cube Dimension Note
ACTIVITY  
AWARD DATE  
COMPANY  
CONTRACT ITEM DATE  
CUSTOMER  
PLANNED FINISH DATE  
PLANNED START DATE  
PROJECT PROGRAM  
PROJECT  
REPORT CODE  
REPORTING CURRENCY  
REPORTING DATE  
SALES CONTRACT CURRENCY  
SALES CONTRACT ITEM COST CURRENCY  
SALES CONTRACT ITEM SALES CURRENCY  
SALES CONTRACT ITEM  
SALES CONTRACT LINE  
SALES CONTRACT REASON  
SALES CONTRACT  
SITE  
SUB PROJECT  
SUPPLIER  

Fact and Dimension Connections

The following picture shows how different facts in the cube are connected to the available dimensions.


Measures

About Measures

Aggregation of measures is based on SUM if not explicitly noted.

This sections describes the basic measures in the cube. These are either measures defined in the core Information Source or in the ETL process. The columns have the following meaning:

 

Measure Measure Group Core Measure ETL Measure Cube Measure Measure Expression Reporting Currency Measure Aggr. Method Note
Sales Value CONTRACT ITEM YES NO NO NO NO SUM  
Sales Value Adj CONTRACT ITEM YES NO NO NO NO SUM  
Sales Value Comp Curr CONTRACT ITEM YES NO NO NO NO SUM  
Sales Value Contr Curr CONTRACT ITEM YES NO NO NO NO SUM  
Cost Value Contr Cur CONTRACT ITEM YES NO NO NO NO SUM  
Cost Value Comp Curr CONTRACT ITEM YES NO NO NO NO SUM  
Margin Value Comp Curr CONTRACT ITEM YES NO NO NO NO SUM  
Margin Value Contr Curr CONTRACT ITEM YES NO NO NO NO SUM  
Sales Contract Item Count CONTRACT ITEM NO NO YES NO NO COUNT Count of rows
Qty Won Tenders CONTRACT ITEM NO YES NO NO NO SUM If CODE='Won' and CONTRACT_STATE<>'Cancelled' then 1 else 0
(CODE is the sales contract reason code)
Qty Lost Tenders CONTRACT ITEM NO YES NO NO NO SUM If CODE='Lost' and CONTRACT_STATE<>'Cancelled' then 1 else 0
(CODE is the sales contract reason code)
Qty Of Tenders CONTRACT ITEM NO YES NO NO NO SUM If CONTRACT_STATE<>'Cancelled' then 1 else 0
Revenue Of Tenders CONTRACT ITEM NO YES NO NO NO SUM If CONTRACT_STATE<>'Cancelled' then REVENUE_VALUE_CC else NULL
Revenue Won Tenders CONTRACT ITEM NO YES NO NO NO SUM If CODE = 'Won' and CONTRACT_STATE<>'Cancelled' then REVENUE_VALUE_CC
(CODE is the sales contract reason code)
Quantity CONTRACT ITEM NO YES NO NO NO SUM QUANTITY from DIM_SALES_CONTRACT_ITEM_BI
Markup CONTRACT ITEM NO YES NO NO NO SUM MARKUP from DIM_SALES_CONTRACT_ITEM_BI
Sales Rate CONTRACT ITEM NO YES NO NO NO SUM REVENUE_RATE from DIM_SALES_CONTRACT_ITEM_BI
Item Selling Price CONTRACT ITEM NO YES NO NO NO SUM CALC_SELLING_PRICE from DIM_SALES_CONTRACT_ITEM_BI
Cost Rate CONTRACT ITEM NO YES NO NO NO SUM COST_RATE from DIM_SALES_CONTRACT_ITEM_BI
Margin CONTRACT ITEM NO YES NO NO NO SUM MARGIN from DIM_SALES_CONTRACT_ITEM_BI
Win Probability CONTRACT ITEM NO YES NO NO NO SUM WIN_PROB from the view SALES_CONTRACT
Sales Value RC CONTRACT ITEM NO YES NO YES YES SUM Sales value in reporting currency
Cost Value RC CONTRACT ITEM NO YES NO YES YES SUM Cost value in reporting currency
Margin Value RC CONTRACT ITEM NO YES NO YES YES SUM Margin value in reporting currency
Currency Rate Reporting Currency Rate YES YES NO NO NO SUM This is the adjusted currency rate, compared to standard rate, that considers conversion factor and inverted quotation, named as CURRENCY_RATE_ADJ. This rate can be used directly to convert a base currency amount to the reporting currency code.The core measure is modified in ETL

 

Calculated Measures

Calculated measures are in the cube calculated with respect to other measures. The table below defines the general meaning/definition of each calculated measure.

Measure Meaning
Weighted Sales Value Contr Curr Sales Value Contr Curr * Win Probability
Weighted Margin Value Contr Curr Margin Value Contr Curr * Win Probability
Weighted Margin Value Contr Curr % Weighted Margin Value Contr Curr / Weighted Sales Value Contr Curr
Margin Value Contr Curr % Margin Value Contr Curr / Sales Value Contr Curr
Weighted Cost Value Contr Curr Cost Value Contr Curr * WIN PROBABILITY
Hit Rate Counts % Qty Won Tenders / Qty Of Tenders
Hit Rate Revenue % Revenue Won Tenders / Revenue of Tenders

 

Time Based Measures

Time based measures are calculated in the cube with respect to other measures. The table below defines the meaning/definition of  the different time measures. These measures need to be used with a specific time dimension defined in the table below.

Measure Meaning
YTD Year to Date
Aggregated value for current month in current  year. E.g. for period 201210 Ytd represents sum of periods 201201-201210.
Based on [REPORTING_DATE].[RepDateMFHy]
R12 Rolling 12 (Completed) Months
For a given period, the sum all months from one year back up to the previous month. E.g. Rolling 12 for 201210 is the sum of months 201110 - 201209
Based on [REPORTING_DATE].[RepDateMFHy]
PY Previous Year
The value of the corresponding month one year back. E.g. for month 201210, the value of month 201110.
Based on [REPORTING_DATE].[RepDateMFHy]
YTD PY Year to Date Previous Year
Aggregated value for corresponding month one year back. E.g. for month 201210 YTD Previous Year represents sum of months 201101-201110.
Based on [REPORTING_DATE].[RepDateMFHy]
R12 PY Rolling 12 (Completed) Months Previous Year
For a given month, first going one year back, then taking the sum of all months from one (more) year back up to the previous month. E.g. for month 201210 the sum of month 201010-201109
Based on [REPORTING_DATE].[RepDateMFHy]

 

Included Example Reports and Dashboards

This section lists dashboards and reports in the example content for the BI Analysis Package that is using this cube:

UI Name Type
Sales Contract Values Report
Active Won Contracts - Value by Company Currency APC - Analysis Panel Component
Lost Contracts - Value by Company Currency APC - Analysis Panel Component

 

Required Components

The BI specific and also related core components listed in this section are required, i.e. they must along with other dependent components, be part of the customer installation to successfully use this cube.

Note that only directly used components are listed. Each such component can have its own list of dependent components. Please refer to the Component Deployment Profile File for each component to get the full picture

Component Type Component Name Product
BISEDI BI BI Services Dimensions Business Intelligence
APTOOL BI Common scripts and utilities, BI Anapac Business Intelligence
APPSDI BI Application Services Analysis Package Dimension Business Intelligence
ENTEDI BI Enterprise Analysis Package Dimensions Business Intelligence
ACCRDI BI Accounting Rules Analysis Package Dimensions Business Intelligence
ACCRFT BI Accounting Rules Analysis Package Fact Business Intelligence
PROJDI BI Project Analysis Package Dimensions Business Intelligence
MPCCDI BI Gen Inventory and Distr BI Anapac Dimensions Business Intelligence
PRJRDI BI Project Reporting Analysis Package Dimensions Business Intelligence
CONMDI BI Sales Contract Management BI Anapac Dimensions Business Intelligence
CONMFT BI Sales Contract Management Analysis Package Facts Business Intelligence
SCANAC BI Sales Contract Analysis Cube Business Intelligence
ENTERP CORE Enterprise Financials
ACCRUL CORE Accounting Rules Financials
PROJ CORE Project Projects
CONMGT CORE Contract Management Projects
PRJREP CORE Project Reporting Human Resources
MPCCOM CORE General Inventory and Distribution Supply Chain

Note BI Component SCANAC