To simplify for an end user to handle the mentioned setup steps, the Setup Tabular Model assistant is the suggested choice, since it supports most of the necessary actions. This option is the recommended one.Īlso refer to Admin & Config Client Overview. For small data volumes the assistant will do. The disadvantage with this option is that the processing is handled synchronously and then if the processing takes long time the Aurena client will timeout the processing.
In the mentioned pages there is also an action named New Data Load Definition that starts a dialog that can used for the same purpose. To be able to load the data associated with tabular data sources referenced by a Tabular Model, a data load definition needs to be created. To handle external source credentials it will be necessary to use the Tabular Model Deployment assistant. Note: If the Tabular Model contains external connection sources i.e., source data comes not only from IFS Cloud, then the Setup Tabular Model assistant can be used to deploy the model but it can not be used to supply credentials for the external sources. Another option is to use the Tabular Model Deployment assistant more information about model deployment, please refer to Admin & Config Client Overview. Next step would be to deploy the tabular model to be used. For special cases it is also possible to use the Deploy to SQL Server Db assistant Another easier option is to use the Setup Tabular Model assistant, found in the Tabular Models overview page or the Tabular Model details page.įor more information read about Access Views.Įach tabular models requires a number database objects to be installed in the target database. To create necessary views it is possible to use a special assistant in the Information Source(s) page. Creating Access Views is always done by starting from Facts. It will be necessary to create Access Views that reads from the required Fact/Dimension specific Online or Data Mart views.
Once the tabular model has been processed it can be used in tools like Power BI and Excel.Įach tabular model references Tabular Data Sources that are referencing Information Sources e.g., Facts and Dimensions. The steps are not fully dependent on each other but for most cases it is practical to do the steps in a given order. To set up a Tabular Model the below steps need to be completed. Refer to general information about IFS Analysis Models. Defining necessary information in IFS Cloud in the different product areas as well as defining load specific configurations is also very important.Read more about this in Admin & Config of Tabular Models section. Some models have predefined roles that support RLS (Row Level Security) and for these roles it is important to define the IFS users that are supposed to be considered when applying the RLS files. The Tabular Model framework must be installed.For more general details about installation, setup and also a useful check list, read more about IFS Analysis Models Installation.Environment parameters should have been defined.Necessary resources (hardware/software) need to be in place.įor more information, please read about IFS Analysis Models installation.Prerequisites ¶īefore setting up the tabular model, the following things needs to be considered:
#TABULAR ANALYSIS HOW TO#
This page provides information how to setup a Tabular Model i.e., steps that are needed before a Tabular Model can be used. Analysis Models - Setup a Tabular Model ¶
0 kommentar(er)
