d/EPM Administration

Extended OLAP export and import functions include subsets

OLAP database export and import functions are enhanced to include subsets and handle these use-cases:

  • Export subsets with the complete OLAP database.
  • Import packages containing subsets only when the Replace Database method is selected.

Ability to order the position of child elements

Tables in the Staging database now support the OrderPosition column that provides the ability to specify the order of child elements.

Relational modeling

These relational modeling features are not supported in IRIS (Infor Regulated Industries SaaS).

Automatic target table adjustment that is based on the SQL query

In relational modeling, you can create new table schema from an SQL query. Or, based on an SQL query, you can automatically adjust an existing target table schema.

Preview query result

Relational modeling supports the ability to preview an SQL query result before you execute the load query.

Data load enhancement

In relational modeling, data load behavior is enhanced with additional options to resolve data conflicts. Update, Skip, or Abort options can be configured before the load query is executed.

Support for custom settings in scripts and load queries

Relational modeling supports the use of custom settings in relational scripts and load queries. The custom settings can be used as SQL parameters in WHERE clauses.

Object browser in relational modeling

A new object browser is available for load queries and relational scripts. The object browser provides a hierarchical view of all source connections, tables, columns, and metadata such as data types and field lengths.

Non-SQL scripts can execute modeling functions

Relational modeling supports the use of these non-SQL scripts:

  • ExecuteScript: can execute other relational scripts.
  • ExecuteLoadQuery: can execute load queries.
  • ExecuteHierarchyMapping: can execute an OLAP hierarchy mapping.
  • ExecuteFactMapping: can execute an OLAP cube mapping.