Main analysis scenarios are:
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| CURRENCY RATES | FACT_CURRENCY_RATES_TM | FACT_CURRENCY_RATES_BI | FACT_CURRENCY_RATES | On Line |
| INVENTORY TRANSACTION HISTORY MEASURES | FACT_INVENT_TRANS_HIST_TM | FACT_INVENT_TRANS_HIST_BI | FACT_INVENT_TRANS_HIST | Data Mart |
| INVENTORY TURNOVER MEASURES | FACT_INVENTORY_TURNOVER_TM | FACT_INVENTORY_TURNOVER_BI | FACT_INVENTORY_TURNOVER | Data Mart |
| INVENTORY VALUE MEASURES | FACT_INVENTORY_VALUE_TM | FACT_INVENTORY_VALUE_BI | FACT_INVENTORY_VALUE | Data Mart |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
FACT_INVENT_TRANS_HIST
The main purpose of this information source is to present data based on the inventory transactions history to support high level summarizations and analyzes to evaluate changes in inventory, for instance, using the Count metrics.
FACT_INVENTORY_TURNOVER
The main purpose of this information source is to present data based on the average issues connected to the receipts per period to support high level summarizations and analyses to evaluate inventory quantities, movements and turnover rates.
FACT_INVENTORY_VALUE
The main purpose of this information source is to present data based on the inventory values per period to support high level summarizations and analyses to evaluate changes of inventory values in different perspectives.
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| ACTIVITY | DIM_ACTIVITY_BI | DIM_ACTIVITY_BI | DIM_ACTIVITY | On Line |
| COMMODITY GROUP | DIM_COMMODITY_GROUP_TM | DIM_COMMODITY_GROUP_BI | DIM_COMMODITY_GROUP | On Line |
| COMPANY | DIM_COMPANY_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| CONDITION CODE | DIM_CONDITION_CODE_BI | DIM_CONDITION_CODE_BI | DIM_CONDITION_CODE | On Line |
| INVENTORY LOCATION | DIM_INVENTORY_LOCATION_TM | DIM_INVENTORY_LOCATION_BI | DIM_INVENTORY_LOCATION | On Line |
| INVENTORY PART | DIM_INVENTORY_PART_TM | DIM_INVENTORY_PART_BI | DIM_INVENTORY_PART | On Line |
| INVENTORY TRANSACTION HISTORY | FACT_INVENT_TRANS_HIST_TM | FACT_INVENT_TRANS_HIST_BI | FACT_INVENT_TRANS_HIST | Data Mart |
| INVENTORY TURNOVER | FACT_INVENTORY_TURNOVER_TM | FACT_INVENTORY_TURNOVER_BI | FACT_INVENTORY_TURNOVER | Data Mart |
| INVENTORY VALUE | FACT_INVENTORY_VALUE_TM | FACT_INVENTORY_VALUE_BI | FACT_INVENTORY_VALUE | Data Mart |
| MPCCOM TRANSACTION CODE | DIM_MPCCOM_TRANSACTION_CODE_TM | DIM_MPCCOM_TRANSACTION_CODE_BI | DIM_MPCCOM_TRANSACTION_CODE | On Line |
| PLANNER | DIM_PLANNER_TM | DIM_PLANNER_BI | DIM_PLANNER | On Line |
| PROJECT | DIM_PROJECT_BI | DIM_PROJECT_BI | DIM_PROJECT | On Line |
| REPORTING CURRENCY | DIM_REPORTING_CURRENCY_TM | DIM_CURRENCY_RATE_TYPE_BI | DIM_CURRENCY_RATE_TYPE | On Line |
| REPORTING DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| RETURN CAUSE | DIM_RETURN_CAUSE_TM | DIM_RETURN_CAUSE_BI | DIM_RETURN_CAUSE | On Line |
| SCRAPPING CAUSE | DIM_SCRAPPING_CAUSE_TM | DIM_SCRAPPING_CAUSE_BI | DIM_SCRAPPING_CAUSE | On Line |
| SITE | DIM_SITE_BI | DIM_SITE_BI | DIM_SITE | On Line |
| STATISTIC PERIOD | DIM_STATISTIC_PERIOD_TM | DIM_STATISTIC_PERIOD_BI | DIM_STATISTIC_PERIOD | On Line |
| IT CREATED DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| ITH DATE APPLIED | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| ITH DATE CREATED | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| ITH EXPIRATION DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| IV DATE CREATED | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
The Tabular Model 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.
Please refer to Technical Documentation for more information.
Combinations of facts and dimensions that do not match will not give any results
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID) |
| CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_CONDITION_CODE_ID) - CONDITION CODE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_INVENTORY_LOCATION_ID) - INVENTORY LOCATION (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_MPCCOM_TRANSACTION_CODE_ID) - MPCCOM TRANSACTION CODE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_PROJECT_ID) - PROJECT (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_RETURN_CAUSE_ID) - RETURN CAUSE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_SCRAPPING_CAUSE_ID) - SCRAPPING CAUSE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_SITE_ID) - SITE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_STATISTIC_PERIOD_ID) - STATISTIC PERIOD (ID) |
| INVENTORY TRANSACTION HISTORY (PLANNER_BUYER_NEW) - PLANNER (ID) |
| INVENTORY TURNOVER (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| INVENTORY TURNOVER (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |
| INVENTORY TURNOVER (DIM_SECOND_COMMODITY_ID) - COMMODITY GROUP (ID) |
| INVENTORY TURNOVER (DIM_SITE_ID) - SITE (ID) |
| INVENTORY TURNOVER (DIM_STAT_PERIOD_ID) - STATISTIC PERIOD (ID) |
| INVENTORY TURNOVER (PLANNER_BUYER_NEW) - PLANNER (ID) |
| INVENTORY VALUE (DIM_COMPANY_ID) - COMPANY (ID) |
| INVENTORY VALUE (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| INVENTORY VALUE (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |
| INVENTORY VALUE (DIM_SITE_ID) - SITE (ID) |
| INVENTORY VALUE (DIM_STATISTIC_PERIOD_ID) - STATISTIC PERIOD (ID) |
| INVENTORY VALUE (PLANNER_BUYER_NEW) - PLANNER (ID) |