Content for Analysis Models - Power BI
This page includes the Analysis Models - Power BI IFS Core models (including a sample report) which are required to be included in the Golden Workspace, and also the relevant Data Source Definitions for each Core Model. They are categorized as below based on the released IFS Version/ Service Update. These are designed to facilitate the Publishing and Downloading functions of Analysis Models - Power BI.
Refer the step-by-step guide below on how to use these samples: Quick Start Guide.
IFS Core Models
CRM
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| CRM | CRM 24R1 V1 - SU06 CRM 24R1 V2 - SU11 |
CRM 24R2 V1 - GA CRM 24R2 V2 - SU05 |
CRM 25R1 V1 - EA CRM 25R1 V2 - GA |
Financials
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Cash Planning | Not Applicable | CP 24R2 V1 - GA CP 24R2 V2 - SU05 |
CP 25R1 V1 - EA |
| General Ledger | GL 24R1 V1 - SU04 GL 24R1 V2 - SU11 |
GL 24R2 V1 - GA GL 24R2 V2 - SU05 |
GL 25R1 V1 - EA |
| Group Reporting | Not Applicable | GR 24R2 V1 - GA GR 24R2 V2 - SU05 |
Last modified: 24R2 |
| Revenue Recognition | Not Applicable | Not Applicable | RR 25R1 V1 - EA |
HCM
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Employee Analysis | EA 24R1 V1 - SU04 EA 24R1 V2 - SU11 |
Last modified: 24R1 | Last modified: 24R1 |
| Incident Analysis | Not Applicable | IA 24R2 V1 - GA IA 24R2 V2 - SU05 |
Last modified: 24R2 |
| Salary Review Analysis | Not Applicable | SRA 24R2 V1 - GA SRA 24R2 V2 - SU05 |
Last modified: 24R2 |
Inventory
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Inventory | Not Applicable | Inventory 24R2 V1 - GA Inventory 24R2 V2 - SU05 |
Last modified: 24R2 |
Maintenance
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Asset Health | Not Applicable | Asset Health 24R2 V1 - GA Asset Health 24R2 V2 - SU05 |
Last modified: 24R2 |
| Maintenance | Not Applicable | Maintenance 24R2 V1 - GA Maintenance 24R2 V2 - SU05 |
Last modified: 24R2 |
Procurement
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Spend Analysis | Not Applicable | Spend Analysis 24R2 V1 - GA Spend Analysis 24R2 V2 - SU05 |
Last modified: 24R2 |
| Supplier Performance | Not Applicable | Supplier Performance 24R2 V1 - GA Supplier Performance 24R2 V2 - SU05 |
Last modified: 24R2 |
Production Performance
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Production Performance | Not Applicable | Production Performance 24R2 V1 - GA Production Performance 24R2 V2 - SU05 |
Last modified: 24R2 |
Project
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Project | Not Applicable | Project 24R2 V1 - GA Project 24R2 V2 - SU05 |
Project 25R1 V1 - EA |
Sales
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Sales | Not Applicable | Sales 24R2 V1 - GA Sales 24R2 V2 - SU05 |
Last modified: 24R2 |
Data Source Definitions
CRM
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| CRM | CRM 24R1 - SU06 | CRM 24R2 - GA | CRM 25R1 V1 CRM 25R1 V2 |
Financials
HCM
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Employee Analysis | Employee Analysis - SU04 | Last modified: 24R1 | Last modified: 24R1 |
| Incident Analysis | Not Applicable | IA 24R2 - GA | Last modified: 24R2 |
| Salary Review Analysis | Not Applicable | SRA 24R2 - GA | Last modified: 24R2 |
Inventory
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Inventory | Not Applicable | Inventory 24R2 - GA | Last modified: 24R2 |
Maintenance
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Asset Health | Not Applicable | Asset Health 24R2 - GA | Last modified: 24R2 |
| Maintenance | Not Applicable | Maintenance 24R2 - GA | Last modified: 24R2 |
Procurement
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Spend Analysis | Not Applicable | Spend Analysis 24R2 - GA | Last modified: 24R2 |
| Supplier Performance | Not Applicable | Supplier Performance 24R2 - GA | Last modified: 24R2 |
Production Performance
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Production Performance | Not Applicable | Production Performance 24R2 - GA | Last modified: 24R2 |
Project
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Project | Not Applicable | Project 24R2 - GA | Project 25R1 - EA |
Sales
| Model | 24R1 | 24R2 | 25R1 |
|---|---|---|---|
| Sales | Not Applicable | Sales 24R2 - GA | Last modified: 24R2 |
Version History
25R1 GA Release
CRM
Added Revision State and Revision State Desc columns to FACT_BUSINESS_OPP_LINE PQ Data Source, and to the CRM model. "V2" of the CRM model and the Data Source Definition file has been made available above.
25R1 EA Release
CRM
Use_Pre_Ship_Del_Note and Use_Pre_Ship_Del_Note_Desc columns were made obsolete in the DIM_SITE_DISCOM_INFO_OL view. Hence, the two columns were removed from the DIM_SITE_DISCOM_INFO PQ Data Source and the CRM model.
Also note that the DIM_CUSTOMER_CONTACT column in BUSINESS OPP LINE table that was previously hidden in the IFS_CRM_24R2_V2 report has been removed; the FACT_BUSINESS_OPP_LINE PQ data source also has been updated accordingly in the CRM model Data Source Definition file.
Cash Planning
DIM_ACCOUNTING_PROJECT table was modified as follows: Updated COMPANY_CODE_DESCR column, removed Accounting Project Type Code column, renamed Accounting Project Group column to Accounting Project Group Desc and Project Origin Desc column to Project Original, and added new columns (which was added to the DIM_ACCOUNTING_PROJECT PQ Data Source as well).
General Ledger
The General Ledger model was updated to reflect the below mentioned changes.
- Credit and debit columns were added to GL ANALYSIS and IL ANALYSIS tables via the respective PQ Data Sources FACT_GL_ANALYSIS_PQ and FACT_IL_ANALYSIS_PQ.
- DIM_ACCOUNTING_PROJECT table was modified as follows: Updated COMPANY_CODE_DESCR column, removed Accounting Project Type Code column, renamed Accounting Project Group column to Accounting Project Group Desc and Project Origin Desc column to Project Original, and added new columns (which was added to the DIM_ACCOUNTING_PROJECT PQ Data Source as well).
- RLS implementation of Code Part Combinations was updated.
In addition, many measures were modified or added to the model as well.
Projects
In FACT_PROJECT_TRANS_PQ_OL view, the OBJID column was renamed as "ID" reflecting the change made to FACT_PROJECT_TRANS_OL view. Hence, the FACT_PROJECT_TRANS_PQ PQ Data Source and the Project model were also updated.
Revenue Recognition
The Revenue Recognition was newly released. It belongs to the Finance area.
24R2 Release
April 2025: All models were updated to apply the "Remove Empty” filter which clears null values for the columns being used on the “one” side of the “many-to-one” relationship. Hence, "V2" of all 24R1 and 24R2 are now published. The Data Source Definitions remain unchanged, except for the Cash Planning model (see below). Customers are recommended to download and publish the latest version of the 24R2 models and Data Source Definition files.
Cash Planning
In addition to the above, the Parquet File Path of the DIM_PROJ_PROGRAM PQ Data Source and DIM_SUB_PROJECT PQ Data Source were changed to be in "Finance" and "Shared" folders respectively. This change is reflected in the model as well as in the Data Source Definition file.
November 2024: The following models and respective Data Source Definition files were newly released for Analysis Models - Power BI as V1:
- Cash Planning
- Group Reporting
- Incident Analysis
- Inventory
- Maintenance - Asset Health and Maintenance
- Procurement - Spend Analysis and Supplier Performance
- Production Performance
- Project
- Sales
The CRM and General Ledger models were updated as follows:
CRM
Previously, DIM_REPORTING_PERIOD_CRM_PQ Information Source was used to ensure CRM-model specific filtering for Reporting Periods. In 24R2, this Information Source was replaced with DIM_REPORTING_PERIOD_PQ Information Source that can be used by multiple models (CRM, Asset Health/Maintenance, Production Performance, Projects, and Sales). Hence, the new DIM_REPORTING_PERIOD_PQ PQ Data Source was connected to the CRM model.
General Ledger
- A new Fact - FACT INTERNAL LEDGER ANALYSIS - was added to the model creating new relationships and measures based on the new Fact. RLS was implemented for the new Fact including an option to generate access for IL Code Combinations in the AD User Mappings page. New tables created:- CODE COMP COMBINATION IL and CODESTRING COMBINATION IL RLS
- Accounting Period table hierarchies were updated.
Other changes include applying/modifying format strings for columns and measures, applying sort-by columns for columns, making visible/hiding columns/measures, modifications to GL Analysis Measures table measures.