Limitations and restrictions

Application Studio has these limits.

Slice segments

The rows of a slice can have a maximum of 15 segments.

AVX2 requirement

Starting with version 2023.02 Infor EPM does not support client machines without AVX2 instruction support in the client computer's processors. This change helps with further performance improvements and does not affect Infor EPM client machines as AVX2 is supported on all modern environments. However, additional check with your IT team is recommended to make sure the system is ready for upcoming release.

Calculation limits enforcement

All queries, including ad-hoc report, all formulas within a cell-based report, and items within element tree, can have a maximum of 2 million values. A value is any cell property or member property, for example if you have a formula which queries five attributes for a single element, then it is counted as five values.

Calculation limits are applied to these report elements:

  • OLAP lists.

    In addition to any selected attributes that are defined in an OLAP list, these five attributes are subjects to calculation limits:

    • Unique name
    • Caption
    • Level
    • Children cardinality
    • Parent
  • Slices.

    Hierarchy elements and values are returned by the query. In addition to any selected attributes that are defined in the slice, these five attributes are subjects to calculation limits in each element of each hierarchy:

    • Unique name
    • Caption
    • Level
    • Children cardinality
    • Parent
  • Relational lists.

    The limit is determined by the multiplication of the number of columns by the number of records.

  • Formula lists.

    Formulas within hyperblocks are grouped and sent to the database as a single query submission. For formulas that are used to query OLAP values, the properties value and FORMAT_STRING are requested for each cell in the cube.

The maximum number of elements that are visible in an element tree depends on the number of attributes that are defined within a specific hierarchy. The greater number of attributes within a hierarchy, the lesser maximum number of elements that are displayed in an element tree. The maximum number of elements that can be displayed in an element tree is 20 000.

A report or query that exceeds the limit can be logged as an event in the application logs. The event name is Values Limit Exceeded (Number of values exceeded limit) and is used for all components.

Numeric input limitations and rounding

The maximum number of digits before and after the decimal point is 14. If that number is exceeded, the input is rounded to fit 14 digits.