Analysis Models - Admin & Config - Tabular Model Details

This page provides detail information about available Tabular Model specific client functionality in IFS Cloud.

Tabular Models

General

From the Tabular Models overview page, select one or more models to navigate to the Tabular Model details page.

Tabular Model Detail Page

The Model Details page has the same attributes/fields as the overview page but also shows associated model details as lists. Details are Action Status, Data Sources, Expressions, Tables, Relationships and Roles.

The Model Details page provides almost the same commands as the overview page. The following commands are specific for the details page:

Command	Description
Logs	Navigates to the Import Logs page.
Update Action Status	The command will try to update the status of each tabular model action correctly. The status of different actions depend on chosen assistant/dialog to perform an action, if access views have been created from the Information Source page or from the Setup Tabular Model assistant etc. This means that the status might not always be accurate.

Action Status for the model

This detail group lists the status for each tabular model action.

Field	Description
Model Action	Name of an Tabular Model related setup action.
Action Status	Status of an action. Not Done - Action has not yet been performed. Ongoing - Action is now running/executing. Success - Action execution ended successfully. Error - Action execution ended with an error. Unknown - Action status is not known. Partly - Action has partly been executed. One of the create views actions and all other actions have to be successful to make the model action to indicate Success.
User ID	Identity of user that performed the action.
Status Change Date	Timestamp when the action was performed.
Last Data Load Definition ID	Identity of the last executed data load definition that contains all tabular data sources referenced by the model.
Last Data Load Run ID	Identity of the last data load run related to Last Data Load Definition ID
Last Data Load Run Exec Time	Time when the Last Data Load Run ID ended.
Last Process Definition ID	Identity of the last executed process definition that contains the tabular model with process mode as 'Database'.
Last Process Run ID	Identity of the last process run related to Last Process Definition ID
Last Process Run Exec Time	Time when the Last Process Run ID ended.

Command	Description
Reset Action Status to Unknown	Sets the status of a tabular model action to Unknown. This command can be used in cases when it is clear that the displayed status is incorrect e.g., the status is Ongoing due to that an error occurred during action execution and it was not possible to correctly set the status to Error.

Data Sources in the model

This detail group lists all data sources referenced by the model.

Field	Description
Data Source Connection ID	Identity of the data source connection. IFS_DW represents IFS Cloud.
Name	The name of the of the source connection in the model.
Description	Description of the data source connection.
Type	Data source connection type.
Configuration State	The configuration state of the expression. An expression can have its own configuration, i.e. a child configuration of the Tabular Model. For more information, please refer to Custom Configurations.

Go to details to view the data source connection details.

Expressions in the model

This detail group lists all expressions in the model.

Field	Description
Expression ID	The IFS identity of the expression in current model ( Model ID )
Name	The name of the of the expression.
Data Source ID	Identity of Tabular Data Source that specifies the expression source.
Configuration State	The configuration state of the expression. An expression can have its own configuration, i.e. a child configuration of the Tabular Model. For more information, please refer to Custom Configurations.

The Expressions in the model group provides the following commands for a single expression:

Command	Description
Create Configuration	Available if the Configuration State is Base. Will define the expression as configured by setting Configuration State as Configured. It is now possible to configure the expression.
Remove Configuration	Removes the expression configuration and sets the Configuration State to Base.
Exclude	Excludes the expression or the customization of the expression from deployment. Leads to a Configuration State change.
Include	Includes the expression in deployment, typically moving from Excluded to Base or from Configured or Dependent to Base.

Tables in the model

This detail group lists all tables in the model.

Attribute	Description
Table ID	The IFS identity of the table in current model ( Model ID )
Name	The name of the of the table.
Reference Expression ID	Identity of expression that the source refers to.
Reference Table ID	Identity of table that the source refers to.
Data Source ID	Identity of Tabular Data Source that specifies the table source.
Configuration State	The configuration state of the table. An table can have its own configuration i.e. a child configuration of the Tabular Model. For more information, please refer to Custom Configurations.

The Tables in the model group provides the following commands for a single table:

Command	Description
Create Configuration	Available if the Configuration State is Base. Will define the table as configured by setting Configuration State as Configured. It is now possible to configure the table (details).
Remove Configuration	Removes the table configuration and sets the Configuration State to Base.
Exclude	Excludes the table or the customization of the table from deployment. Leads to a Configuration State change.
Include	Includes the table in deployment, typically moving from Excluded to Base or from Configured or Dependent to Base.
Process Table	Starts the Tabular Model Processing Assistant that provides the possibility to process the current table but also to process a number of tables or the complete model.

Relationships in the model

This detail group lists all relationships in the model.

Attribute	Description
From Table ID	The IFS identity of the from table in a table relation in current model ( Model ID )
From Table Column ID	The IFS identity of the from table column in a table relation
To Table ID	The IFS identity of the to table in a table relation in current model ( Model ID )
To Table Column ID	The IFS identity of the to table column in a table relation
From Cardinality	Cardinality in the from table, e.g. many in a many-to-one relationship
To Cardinality	Cardinality in the to table, e.g. one in a many-to-one relationship
Filtering behavior	Indicates how relationships influence filtering of data. Typically OneDirection, BothDirections, Automatic
Configuration State	The configuration state of the relationship. For more information, please refer to Custom Configurations.

The Relationships in the model group provides the following commands for a single relationship:

Command	Description
Create Configuration	Available if the Configuration State is Base. Will define the relationship as configured by setting Configuration State as Configured. It is now possible to configure the relationship.
Remove Configuration	Removes the relationship configuration and sets the Configuration State to Base.
Exclude	Excludes the relationship or the customization of the relationship from deployment. Leads to a Configuration State change.
Include	Includes the relationship in deployment, typically moving from Excluded to Base or from Configured or Dependent to Base.

Roles in the model

This detail group lists all roles defined for the model.

Model roles are normally defined in SSMS (SQL Server Management Studio) and specifies the permissions applicable for the role, included members and table specific filters. If roles are added to a base model in SSMS, then when importing the model to IFS Cloud the role definitions will be defined as a configuration.

The other way to handle roles is to use the IFS Cloud Web client and to create a configuration of a base model, then defining the role definitions and finally deploying the configured model to SSAS.

One example is the GL Model that has a predefined role definition. It contains Table Permissions related to GL Company, Business Plan and Planning Unit users. The role definition will be added in SSAS when deploying the model. Role Members can be added either in IFS Cloud Web client or in SSMS after having deployed the model.

Attribute	Description
Name	The name of the role as defined in SSMS (SQL Server Management Studio).
Description	Description of the role.
Model Permission	Role permission. Can be one of the following. Administrator Members can make modifications to the model schema and can query all data in the model designer, reporting client, and SSMS. Row filters do not apply. All data can be queried in this role. None Members cannot make any modifications to the model database schema and cannot query data. Row filters do not apply. No data is visible to users in this role. Read Members are allowed to query data (based on row filters) but cannot see the model database in SSMS, cannot make any changes to the model database schema, and the user cannot process the model. Row filters can be applied. Only data specified in the row filter DAX formula is visible to users. Read Refresh Members are allowed to query data (based on row-level filters) and run process operations by running a script or package that contains a process command, but cannot make any changes to the database. Cannot view the model database in SSMS. Row filters can be applied. Only data specified in the row filter DAX formula can be queried. Refresh Members can run process operations by running a script or package that contains a process command. Cannot modify the model database schema. Cannot query data. Cannot query the model database in SSMS. Row filters do not apply. No data can be queried in this role.
Configuration State	The configuration state of the role. An role can have its own configuration, i.e. a child configuration of the Tabular Model. For more information, please refer to Custom Configurations.

The Roles in the model group provides the following commands for a single role:

Command	Description
Create Configuration	Available if the Configuration State is Base. Will define the role as configured by setting Configuration State as Configured. It is now possible to configure the role.
Remove Configuration	Removes the role configuration and sets the Configuration State to Base.
Exclude	Excludes the role or the customization of the role from deployment. Leads to a Configuration State change.
Include	Includes the role in deployment, typically moving from Excluded to Base or from Configured or Dependent to Base.

Tabular Table Detail Page

From the Tables in the model group in the Tabular Model page, select a table and go to details to navigate to the Tabular Table page. This page provides detail information about:

1. Partitions in the table
2. Columns in the table
3. Measures in the table
4. Hierarchies in the table

The Table group in the detail page has the same attributes and actions as in the Tables in the model group in the Tabular Model detail page.

Partitions

The Partitions in the table list shows all partitions in the table. Currently only one partition per table is supported.

Attribute	Description
Partition ID	The IFS identity of the table partition.
Name	Name of the partition.
Description	Description of the partition.
Data Source	Identity of the Tabular Data Source that specifies the table source.
Source Type	The type of source used by this partition. Most common type is m which refers to that the partition is using an M expression. For other values, please refer to Microsoft documentation.
Configuration State	The configuration state of the table partition. For more information, please refer to Custom Configurations.

Available commands for table partition.

Command	Description
Create Configuration	Available if the Configuration State is Base. Will define the table partition as configured by setting Configuration State as Configured. It is now possible to configure the table partition.
Remove Configuration	Removes the table partition configuration and sets the Configuration State to Base.
Exclude	Excludes the table partition from deployment. Leads to a Configuration State change.
Include	Includes the table partition in deployment, typically moving from Excluded to Base.

Columns

The Columns in the table group shows all columns in a table.

Attribute	Description
Column ID	The IFS identity of the table column
Name	Name of column
Description	Description of column
Data Type	Column data type
Display Folder	Name of display folder that column should appear in
Hidden	Yes if the column should be hidden in client tools.
Source Column	Name of the column in the referenced source.
Sort By Column	Name of the table column used for sorting.
Expression	DAX expression for a calculated column
Configuration State	The configuration state of the table column. A table column can have its own configuration, i.e. a child configuration of the tabular table/model. For more information, please refer to Custom Configurations.

Available commands for table column.

Command	Description
Create Configuration	Available if the Configuration State is Base. Will define the table column as configured by setting Configuration State as Configured. It is now possible to configure the table column
Remove Configuration	Removes the table column configuration and sets the Configuration State to Base.
Exclude	Excludes the table column from deployment. Leads to a Configuration State change.
Include	Includes the table column in deployment, typically moving from Excluded to Base.

Measures

The Measure in the table group shows all measures in a table. Applies to tables based on Facts. (note that the below image is not relevant for the shown tabular table detail.)

Attribute	Description
Measure ID	The IFS identity of the table measure
Name	Name of measure
Description	Description of measure
Display Folder	Name of display folder that measure should appear in
Hidden	Yes if the measure should be hidden in client tools.
Expression	The DAX expression for the measure
Format String	Format string that applies
Configuration State	The configuration state of the table measure. A table measure can have its own configuration, i.e a child confguration of the tabular table/model. For more information, please refer to Custom Configurations.

Available commands for table column.

Command	Description
Create Configuration	Available if the Configuration State is Base. Will define the table measure as configured by setting Configuration State as Configured. It is now possible to configure the table measure
Remove Configuration	Removes the table measure configuration and sets the Configuration State to Base.
Exclude	Excludes the table measure from deployment. Leads to a Configuration State change.
Include	Includes the table measure in deployment, typically moving from Excluded to Base.

Hierarchies

The Hierarchies in the table group shows all hierarchies in a table.

Attribute	Description
Hierarchy ID	The IFS identity of the table hierarchy
Name	Name of hierarchy
Description	Description of the hierarchy
Display Folder	Name of the folder that will contain the hierarchy
Hidden	Yes if the hierarchy should be hidden in client tools.
Configuration State	The configuration state of the table hierarchy. A table hierarchy can have its own configuration, i.e. a child configuration of the tabular table/model. For more information, please refer to Custom Configurations.

Tabular Role Detail Page

From the Roles in the model group in the Tabular Model page, select a role and go to details to navigate to the Tabular Role page. This page provides detail information about:

1. Table Permissions
2. Role Members

The Table Permissions list shows the filter expression that will be applied to a table in the model. These filters are mainly used to support RLS (Row Level Security).

Attribute	Description
Table	The IFS identity of a table in the model with an associated filter expression that is used to control table permissions.
Filter Expression	A DAX expression used as a table filter to control table permission. The filter is typically used for handling of RLS, where members of the role gets access to different table details. The filter expression normally includes a DAX function to retrieve the user identity. This function should in most cases be the USERPRINCIPLENAME(), a function that return the user principle name. If the USERNAME() function is used the user identity is often a domain user. It is important to make sure that the correct function is applied. The result of the user function must return a user name that is defined as AD User Identity in the AD User Mappings page.
Configuration State	The configuration state of the role permission. For more information, please refer to Custom Configurations.

Available commands for role permissions.

Command	Description
Create Configuration	Available if the Configuration State is Base. Will define the role permission as configured by setting Configuration State as Configured. It is now possible to configure the role permission.
Remove Configuration	Removes the role permission configuration and sets the Configuration State to Base.
Exclude	Excludes the role permission from deployment. Leads to a Configuration State change.
Include	Includes the role permission in deployment, typically moving from Excluded to Base.

The Role Members list shows the members of the role.

Attribute	Description
Member Name	The identity of a role member. If the member is a user then it should be related to the AD User Identity on the AD User Mappings page. When defined via IFS Cloud Web, only users defined in the AD User Mappings page will be possible to choose. Upon save the related Fnd User identity will be displayed. During import of a model for which the role definitions have been handled in SSMS, it might be so that the Member Name is not recognized. In this case the Fnd User will not be displayed. When this happens,please make sure to update the mappings on the AD User Mappings' page.
Fnd User	This is the IFS user identity. Mappings of valid users is made on the AD User Mappings page. This is a read-only field.
Identity Provider	The name of the provider that handles user identification. Not a mandatory field. Will in most cases only have a value after import of a role defined in SSMS.
Member Type	Defines the member type. Auto Group The member is a user group, typically an AD group. User The member is a user, typically an AD user. Not a mandatory field. Will in most cases only have a value after import of a role defined in SSMS.

Note: Adding or removing members from role is not considered as a configuration.

More Information

Use the following links for more information about administration and configuration of Tabular Models:

• Admin & Config - Tabular Models

• Admin & Config - Tabular Model Explore Pages

• Admin & Config - Tabular Model Actions