This Tabular Model is used for: Revenue Recognition. 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.
The primary objective of the Revenue Recognition Analysis Model is to generate visualizations by integrating actual revenue recognition data with planned values from revenue recognition forecasts. The model supports multi-company, multi-currency and multi-calendar analysis. Additionally, for companies or groups following multiple accounting standards, it enables the analysis and visualization of differences between them. Measures available in both periodic and accumulated formats are translated to different currency using period amounts, while accumulated amounts represent the aggregation of already translated period amounts.
The analysis can be performed in either the Accounting Currency or a standardized currency known as X-Rate. X-Rate translates all balances using the currency rate types and corresponding currency rates of a selected company.
Reporting periods are designed to provide a standardized calendar structure, independent of how individual companies configure their local accounting calendars or define their closing periods. These periods support operational reporting and analysis by ensuring a consistent organizational view across multiple companies.
To facilitate visualizations that cover the entire lifecycle of a project, mixed measures have been introduced. These measures display actuals up to a selected cutoff period while incorporating forecasted values for the remaining periods. To retrieve specific forecast data within mixed measures, users must filter by both the cutoff period and a required forecast type defined for monthly review or for a specific forecast version.
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| DIFF GL vs IL MEASURES | FACT_REVENUE_REC_PROJ_TM, FACT_REV_REC_FORC_LINE_ALL_TM | FACT_REVENUE_REC_PROJ_BI, FACT_REV_REC_FORC_LINE_ALL_BI | FACT_REVENUE_REC_PROJ, FACT_REV_REC_FORC_LINE_ALL | On Line |
| FORECAST CUT OFF PERIOD | DIM_FORECAST_CUT_OFF_PERIOD_TM | DIM_FORECAST_CUT_OFF_PERIOD_BI | DIM_FORECAST_CUT_OFF_PERIOD | On Line |
| GENERAL LEDGER MEASURES | FACT_REVENUE_REC_PROJ_TM, FACT_REV_REC_FORC_LINE_ALL_TM | FACT_REVENUE_REC_PROJ_BI, FACT_REV_REC_FORC_LINE_ALL_BI | FACT_REVENUE_REC_PROJ, FACT_REV_REC_FORC_LINE_ALL | On Line |
| INTERNAL LEDGER MEASURES | FACT_REVENUE_REC_PROJ_TM, FACT_REV_REC_FORC_LINE_ALL_TM | FACT_REVENUE_REC_PROJ_BI, FACT_REV_REC_FORC_LINE_ALL_BI | FACT_REVENUE_REC_PROJ, FACT_REV_REC_FORC_LINE_ALL | On Line |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
The Revenue Recognition model has two main sources:
Based on the Information Source FACT_REVENUE_REC_PROJ containing actual amounts.
Based on the Information Source FACT_REV_REC_FORC_LINE_ALL containing forecast amounts.
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| ACCOUNTING PROJECT | DIM_ACCOUNTING_PROJECT_TM | DIM_ACCOUNTING_PROJECT_BI | DIM_ACCOUNTING_PROJECT | On Line |
| COMPANY | DIM_COMPANY_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| FACT ACTUAL AMOUNTS | FACT_REVENUE_REC_PROJ_TM | FACT_REVENUE_REC_PROJ_BI | FACT_REVENUE_REC_PROJ | On Line |
| FACT FORECAST AMOUNTS | FACT_REV_REC_FORC_LINE_ALL_TM | FACT_REV_REC_FORC_LINE_ALL_BI | FACT_REV_REC_FORC_LINE_ALL | On Line |
| FORECAST TYPE | DIM_REVENUE_REC_FORECAST_TM | DIM_REV_RECOG_FORECAST_TYPE_BI | DIM_REV_RECOG_FORECAST_TYPE | On Line |
| FORECAST VERSION | DIM_REV_RECOG_FORECAST_TYPE_TM | DIM_REVENUE_REC_FORECAST_BI | DIM_REVENUE_REC_FORECAST | On Line |
| PROJECT PROGRAM | DIM_PROJECT_PROGRAM_TM | DIM_PROJECT_PROGRAM_BI | DIM_PROJECT_PROGRAM | On Line |
| REPORTING PERIOD | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| X-RATE CURRENCY | DIM_CURRENCY_CODE_XRATE_TM | DIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TC | DIM_CURRENCY_CODE_XRATE | On Line |
| X-RATE TYPE | DIM_CURRENCY_RATE_TYPE_XRATE_TM | DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | DIM_CURRENCY_RATE_TYPE_XRATE | On Line |
| X-RATES | FACT_CURRENCY_RATES_PERIODXRATE | DIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | FACT_CURRENCY_RATES_PERIODXRATE | Data Mart |
The model assumes that revenue recognition is conducted on a monthly basis.
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| ACCOUNTING PROJECT (Project Program ID) - PROJECT PROGRAM (ID) |
| FACT ACTUAL AMOUNTS (COMPANY_BASE_CURRENCY) - X-RATE FROM CURRENCY (From Currency Code) |
| FACT ACTUAL AMOUNTS (DIM_COMPANY_ID) - COMPANY (ID) |
| FACT ACTUAL AMOUNTS (DIM_PROJECT_ID) - ACCOUNTING PROJECT (ID) |
| FACT ACTUAL AMOUNTS (DIM_REPORTING_DATE_ID) - REPORTING PERIOD (ID) |
| FACT FORECAST AMOUNTS (ACC_PROJECT_ID) - ACCOUNTING PROJECT (ID) |
| FACT FORECAST AMOUNTS (COMPANY_BASE_CURRENCY) - X-RATE FROM CURRENCY (From Currency Code) |
| FACT FORECAST AMOUNTS (CUT_OFF_DATE_ID) - FORECAST CUT OFF PERIOD (ID) |
| FACT FORECAST AMOUNTS (DIM_COMPANY_ID) - COMPANY (ID) |
| FACT FORECAST AMOUNTS (DIM_FORECAST_ID) - FORECAST VERSION (ID) |
| FACT FORECAST AMOUNTS (DIM_FORECAST_TYPE_ID) - FORECAST TYPE (ID) |
| FACT FORECAST AMOUNTS (DIM_REPORTING_DATE_ID) - REPORTING PERIOD (ID) |
| RR COMPANY RLS (COMPANY) - COMPANY (ID) |
| X-RATES (CURRENCY_RATE_DATE_ID) - REPORTING PERIOD (ID) |
| X-RATES (CURRENCY_RATE_TYPE_KEY) - X-RATE TYPE (X Rate Type Code) |
| X-RATES (FROMCURRENCY) - X-RATE FROM CURRENCY (From Currency Code) |
| X-RATES (TOCURRENCY) - X-RATE CURRENCY (To Currency Code) |