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, create 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.