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.
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.
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.
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:
The following picture shows how different facts in the cube are connected to the available dimensions.
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 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 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] |
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 |
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