OLAP modeling

You can use relational modeling to define the objects of an OLAP database within the object definition tables of the Staging database. The object definition tables enable definition of all objects of an OLAP database: cubes, dimensions, hierarchies, subsets, rules, data roles, and access cubes. Only when the model is published are the results available in the OLAP database.

This is an outline of the steps in modeling a database.

  1. Create an application in the Applications dashboard.

    The OLAP Database and Modeling capabilities must be enabled.

  2. In the Data Connections dashboard, create a Relational Providers data connection to the Staging database.
  3. In the Relational Modeling dashboard, fill the object definition tables. Specify dimensions, cubes, and other objects.
  4. In the Relational Modeling dashboard, create data tables in the Staging database. These tables are intended to provide elements, relations, facts, or permissions.
  5. Populate the tables of the Staging database with data from, for example, Data Lake, using load queries and scripts. You can also use the definition view of tables to manually fill hierarchy element tables and to define hierarchical structures.
  6. Publish the model to the OLAP database, using the Non-SQL script function PublishCustomModelToOLAP(applicationName) or the Application Engine function, ModelingPublishCustomModelToOLAP (string applicationName) .