Infor Enterprise Performance Management Relational Modeling Developer Guide (Cloud)

Home

Back

Forward

  • Help
  • Copy URL
  • PDF
  • Print this page

Help

Copy URL

Topic URL copied to clipboard

PDF

Print

Overview of relational modeling
Preparing your modeling environment
Modeling permissions
Data sources
Creating a data connection to the Staging database
Creating a data connection to Data Lake
Managing tables, views, and load queries
Table naming rules
Table prefix rules
Working with standard integrations for Infor EPM business applications
Editing Staging table schemas
Creating a staging database table from a query
Creating a staging database table manually
Editing columns of a staging database table
Adding columns to a staging database table from a query
Views in the Staging database
Creating a view
Editing a view
Loading data
Creating load queries
Methods of running load queries
Running a load query manually
Incremental data loads
LAST_IMPORT macro
LAST_EXECUTION macro
Parametrized mappings
Scripts
Creating scripts
Methods of running scripts
Running a script manually
Non-SQL functions in scripts
SQL scripts to edit staging data
Using custom settings
Parametrized load queries and scripts
Creating load query and script parameters
Using custom settings
Examples of parameters in non-SQL script functions
Dimension View
Editing table data in the dimension view
Exporting, importing, and deleting data
Exporting data
Importing data
Deleting data
Export and import
Exporting a model from Staging
Exporting a model from Integration
Importing a model to Staging
Importing a model to Integration
Object definition tables and publication of models
Metadata tables
Model table
Table table
Load Query table
Script table
Dimension table
Dimension attribute table
Hierarchy table
Subset table
Element in static subset table
Cube table
Dimension in cube table
Cube rule group table
Cube rule table
Table access cube table
Fact table
Multidimensional access cube table
Data roles table
Perspective table
Domain table
Data tables
Element table
Relations table
Dimension access cube table
Table access cube table
Fact table
Fact table for the Domain cube values
Multidimensional access cube table
Setting up a Domain cube in the object definition tables
Publish to OLAP
OLAP Modeling
Adding a dimension to the model
Managing the properties of a dimension
Adding a hierarchy to a dimension
Managing the properties of a hierarchy
Adding a cube to the model
Managing the properties of a cube
Viewing the dimensionality of a cube
Adding elements to a hierarchy
Deleting elements from a hierarchy
Managing data role permissions
Managing attributes
Subsets
Creating a subset manually
Editing a subset manually
Creating a query-based subset
Editing a query-based subset
Deleting a subset
Managing rules
Publishing a model to OLAP
  • Links
  • docs.infor.com
  • Send Feedback on Current Topic
  • Product Support
  • Open link in new tab
  • Open link in new window
  • Copy link to clipboard