A set of Application Engine processes and a how-to guide (.doc) to create dimension tables and set up the OLAP Model/Object Definition Tables for an existing OLAP database in v12 (cloud or on-premise).
(Originally in an archived thread here: https://community.infor.com/discussion/32987/olap-to-relational-modeling)
Publishing date | Version | Changelog |
|---|
2026-03-10 | 9 | Major change: processes now create tables directly instead of creating XML for an .rmexport.
Created new processes using these abilities, removed old ones (as well as some supplemental processes that were not useful any more).
Integrated correction of order positions into O2RM2_OLAPtoDimTables instead of having a separate process for it.
Minor bug fixes: incorrect elements would be entered for empty subsets.
Other changes: integrated the correction of element order positions into O2RM2_OLAPtoDimTables instead of having a separate process for it. Re-structured O2RM3_OLAPModel to allow entering dimensions in the model which are not contained in any cube. Made O2RM3_OLAPModel_CubeRules output a warning for dimensional rules instead of wordlessly skipping them.
Changed column name for automatically created column “DataSourceId” to “DataSourceID” because only then it is shown in the OLAP Modeling UI. |
2026-04-24 | 9.1 | Fixed a critical error about subsets in O2RM3_OLAPModel (subset elements were not logged, so all subsets were empty in the model). Made O2RM1_CreateTables delete any existing modeling information and drop existing tables before (re-)creating them. Removed an obsolete setting from O2RMx_OLAPModel_UpdateSubsets. Updated Community Link in the doc. |
