Analysis Models - Tabular¶
IFS Analysis Models - Tabular 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 IFS Cloud Web.
Further functions like data loading, data configuration, scheduling, monitoring and processing of tabular models are also done through IFS Cloud Web.
Architectural 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 Data sources.
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 specify one or more Analysis Data sources.
Once defined each data load definition can be run multiple times.
Basic Data in IFS Cloud¶
IFS Analysis Models - Tabular requires that basic data has been set up properly in IFS Cloud.
Configuration of Data Mart Load in IFS Cloud¶
In a practical scenario Data Mart access is essential to make sure that data access is as efficient as possible. Learn more Data Mart access and associated configuration in IFS Cloud.
Access Views¶
Extracting data from IFS Cloud to the Data Warehouse in SQL Server is done by using Access Views. These views represent the read interface in IFS Cloud, acting as a view layer on top of the Information Source related views.
Note: Access Views are not available by default. It is necessary to generate these views via the IFS Cloud Web client.
Learn more about Access Views.
Security¶
This section deals with read access related to IFS Cloud and also provides some information about security handling in SQL Server. Learn more about security.
Setup Environment and User Mappings¶
Data Configuration¶
Analysis Models - Tabular provides data configurations that will limit the data used by the Tabular Models. The configurations are important to make sure that the Tabular Models work as designed to provide the end users with the best experience.
Data configurations are mainly related to basic data in IFS Cloud. For more information please refer to Basic Data in IFS Cloud.
Learn more about data configurations.
Setting up a Tabular Model¶
Before a Tabular Model can be used there are a number of setup steps that have to be completed.
Admin & Config Client Overview¶
Use the following link to get an overview of available client support in IFS Cloud related to the Tabular framework in Analysis Models - Tabular.
Deploy Necessary DW Objects¶
Each tabular model is dependent on a number of Tabular Data Sources. Before a model can be used, it is important to make sure that necessary Tabular Data Source specific objects are created in the the SQL Server database,
Learn more about DW deployment.
Data Load Definition and Volume Configuration¶
The Analysis Models - Tabular framework, supporting SSAS Tabular models, transfers data from IFS Cloud to a storage layer, database, in SQL Server.
The data load supports different load types, providing flexibility to control the data volume loaded for different sources used by the Tabular models:
- Full load
- Conditional load
- Incremental load
Learn more how to create a data load definition and how to configure the data volume.
Processing a Tabular Model¶
Analysis Models - Tabular framework supports creating a processing definition to process one or many Tabular Models.
Learn more how to create a process definition and how to run the process action.
Custom Configurations¶
The Tabular Models framework is built around IFS Marble models and support a layered architecture that allows custom specific configurations. Read more about how to use the layered architecture to handle custom specific modifications and additions.
Read more about Tabular Models specific custom configurations.
Creating a copy of a Tabular model¶
The Tabular Models Framework supports creating a copy of an already existing tabular model, including its entities and configurations to a new model.
The Configuration State of the copied model and its entities will be New, It can be used as an alternative to deploying a model with configurations to Analysis Services/exporting it as a BIM file and importing said model to a new model. Read more about Copying a Tabular Model
Logs¶
The Tabular Models framework supports several actions that leads to execution of SSIS packages, Stored procedures and Agent Jobs in SQL Server. To enable tracing of these remote executions,a set of logs have been made available in the IFS Cloud Web client.
Read more about available logs.
Translations¶
Read more about how translations are handled.
Other Subjects¶
Information related to installation and preparations can be found in the Installation Checklist.