Publish to OLAP
The publishing process compares the dimensions and cubes of the
OLAP model with those of the relational model. These objects are
ignored or deleted according to the value of PreserveManualAddedObjects in the DEPM_MOD_MODEL metadata table.
You can use a non-SQL script to publish an OLAP model, or use the
Publish option in the OLAP Modeling dashboard in EPM Administration. If you
use a script to publish, use the PublishCustomModelToOLAP
function. In Application Engine, you can use the ModelingPublishCustomModelToOlap function.
You can use scripting to publish single dimensions and single cubes, each with their dependencies.
Caution:
Before you publish a model to OLAP, create a
manual backup of the OLAP database. Ensure that only one user
publishes to a particular OLAP database at any time.
Note: If you use DEPM_MOD_FACTTABLE, existing data is handled differently
depending on the cube type. Data in access cubes is cleared before import. Data in data cubes
is only overwritten by the publishing process. Existing data in data cubes is not changed by
the publishing process unless the data structure is different. To load data to the cubes of
the Data type, consider using the OLAP cube mappings because of the
greater flexibility provided by the Clear,
Add, and Overwrite options.
Publishing to these applications is not supported:
- BIFSM (FSM)
- GHR
- BICSI (Business Analytics)
- BIIBP
- DEPM
If you publish to Infor EPM business applications (DEPMAPPS), these rules apply:
- Objects owned by Business Modeling are unaffected. They are managed in Business Modeling.
- DACs and MDACs assigned to an object owned by Business Modeling are unaffected.
- To add elements to hierarchies that are owned by Business Modeling, you must use Business Modeling.
- You cannot assign global permissions to data roles of the business applications.
- The only purpose of data roles that you publish to DEPMAPPS is the permission management of DAC, MDAC and TABACC cubes.
If you use a script to publish custom cubes, you can run the PublishCustomCubeToOLAP function only for cubes of the Data type.
Caution:
The publishing process does not check for manually
added attributes, hierarchies, subsets, or rules.