Skip to content

IFS Analysis Models

IFS Analysis Models consists of a framework that supports transferring data from IFS Cloud Information Sources to a Data Warehouse hosted in Microsoft SQL Server, and a set of Microsoft Tabular Models connecting to this Data Warehouse.

The definition of the Data warehouse and the Tabular Models are done using Marble models and supports the layered application architecture.

The deployment of the Data warehouse and the Tabular Models are done through Aurena.

Further functions like data loading, data configuration, scheduling, monitoring and processing of tabular models are also done through Aurena.

Architectual Overview

Architecture Overview

Definition of Data Warehouse

The data warehouse contains tables, views and indices on tables. All objects found in the data warehouse is defined using a collection of Analysis Datasources.

Analysis Data Source

An Analysis Data Source marble models install meta data for Tabular Data Sources. Refer the section Tabular Data Sources for more details.

Definition of Tabular Models

The tabular models are abstracted into Marble models as analysismodel files. One analysismodel file represents one Tabular Model along with all shared expressions, tables, hierarchies etc.

The marble models will generate insert scripts and they will get installed to the Oracle database during IFS installation.

The current release only supports Tabular Models of compatibility level 1400.

Definition of Data Loads

Loading of tables in the data warehouse needs to be defined using data loads. A data load can specifiy one or more Analysis Data sources.

Once defined each data load definition can be run multiple times.


Both Analysis Models and Analysis Datasources supports configurations through Aurena. What IFS delivers is termed as the Base version and will be completely replaced with the next version of IFS. However customers changes done through Aurena will be preserved as Configurations. Each record will show the state of the configuration.