OLAP Modeling

OLAP Modeling provides an overview of the dimensions and cubes of a model and options to manage elements of hierarchies and their access permissions. You can publish an entire model from the OLAP Modeling dashboard as an alternative to using scripts. To publish a single dimension and all its dependent objects (properties, attributes, hierarchies, subsets, DAC values, and data roles) use the PublishCustomDimensionToOLAP script. To publish a single cube and its dependent objects (properties, rules and rule groups, facts and, optionally, dimensions) use the PublishCustomCubeToOLAP script.

Note: You cannot use the OLAP Modeling dashboard to manage elements of the Infor d/EPM business applications.

All dimensions from the DEPM_MOD_DIMENSION object definition table are listed. Click the root, Dimensions node of the list to show the dimensions in a grid. The Security column indicates which dimensions have dimension access control and for which, therefore, you can manage element permissions.

You can add, edit, and delete elements and their attribute values and, if a dimension uses dimension access control, manage permissions for elements. The Elements tab shows the elements hierarchically, based on the data tables, and referenced from the DEPM_MOD_HIERARCHY object definition table. A column is shown for each attribute of the dimension, as defined in the DEPM_MOD_DIMENSIONATTRIBUTE object definition table. To enable changes to element types, order position, and weight, follow the column name recommendations for element and relations tables. See the "Element table" and "Relations table" topics. Hierarchies that are based on views or which have more than 1 million elements are not displayed.

All cubes from the DEPM_MOD_CUBE object definition table are listed. Click the root, Cubes node of the list to show the cubes in a grid. The Security column indicates which cubes have multi-dimensional access control.