This Tabular Model is used for: Inventory. There is a list of Tabular Models pre-packaged and delivered as a part of IFS Analysis Models, and you can refer to them here.
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 |
| 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 |
| 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 |
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_ITH_DATE_APPLIED_ID) - ITH DATE APPLIED (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_ITH_DATE_CREATED_ID) - ITH DATE CREATED (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_ITH_EXPIRATION_DATE_ID) - ITH EXPIRATION DATE (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_IT_DATE_CREATED_ID) - IT CREATED DATE (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 (IV_DATE_CREATED) - IV DATE CREATED (ID) |
| INVENTORY VALUE (PLANNER_BUYER_NEW) - PLANNER (ID) |