d/EPM Administration

Synchronization of new roles with OLAP databases through d/EPM Administration

When creating new application or data roles in d/EPM Administration, roles are no longer immediately synchronized with the __GRP__ dimension of the OLAP database. Instead, administrators can trigger the synchronization of new roles manually to avoid unnecessary reloading of access cubes.

Everyone role is used for technical purposes only

Do not assign the Everyone role to any user in the business application. The role is used for technical purposes only.

Whitelist of SQL functions

To help ensure security, only a reduced list of SQL functions is allowed in the multi tenant cloud environment.

Relational modeling

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

Relational scripts

Relational modeling supports creation of SQL scripts that execute insert, update, and delete statements against data in the staging database. You can execute multiple statements that target multiple tables in the relational modeling staging database.

Query editor enhancements

In the relational modeling UI, the load query editor is redesigned for better usability.

Compression of export files

In relational modeling, export files are automatically compressed to decrease file sizes.

Ability to edit tables

In the relational modeling UI, you can now edit tables and add, remove, or rename columns of existing tables.

Dimension editor in relational modeling

With the dimension editor, you can design OLAP hierarchies in relational tables, which can then be mapped to OLAP hierarchies. You can create, edit, and delete elements, assign parents, edit weights, and change values of attributes.