Direct OLAP editing, using the Edit Database dashboard and mappings

You can add cubes and dimensions directly to the OLAP database by using the Edit Database dashboard. You then define mappings to load data into hierarchies and cubes.

This is an outline of the steps:

  1. Create an application in the Applications dashboard.

    The OLAP Database and Relational modelingcapabilities must be enabled.

  2. In the Data Connections dashboard, ensure that there is a Relational Providers data connection to the Staging database.
  3. In the Relational Modeling dashboard, create tables in the Staging database. These tables are intended to provide elements, relations, facts, or permissions.
  4. Populate the tables of the Staging database with data from, for example, Data Lake, using load queries and scripts. You can also use the dimension view of tables to manually fill hierarchy element tables and to define hierarchical structures .
  5. In the Edit Database dashboard, create the dimensions and cubes.
  6. In the Edit Database dashboard, create mappings between the tables of the Staging database and the dimensions and cubes of the model.
  7. In the Mappings Overview dashboard, run the mappings to populate the dimensions and cubes of the model with the data in the tables of the Staging database.
Note: We recommend that, when using API Gateway or ION API calls to call functions of the Modeling Service, you define tasks that run no longer than 15 minutes. After 15 minutes functions are canceled. However, the cancelation does not have effect in the Modeling Service, in which load queries, scripts, and mappings continue to run.