Using the Edit Database dashboard for direct OLAP editing

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

Create an application in the Applications dashboard.
The OLAP database and Relational Modeling capabilities must be enabled.
In the Data Connections dashboard, ensure that there is a Relational Providers data connection to the Staging database.
In the Relational Modeling dashboard, create tables in the Staging database. The tables are intended to provide elements, relations, facts, or permissions.
Use load queries and scripts to populate the tables of the Staging database with data from, for example, Data Lake.
You can also use the dimension view of tables to manually populate hierarchy element tables and define hierarchical structures.
In the Edit Database dashboard, perform these actions:
1. Create dimensions and cubes.
2. Create mappings between the tables of the Staging database and the dimensions and cubes of the model.
In the Mappings Overview dashboard, run the mappings to populate the dimensions and cubes of the model with the data from the Staging database's tables.

Note: When you use API Gateway or ION API calls to call functions of the Modeling Service, we recommend that you define tasks that run no longer than 15 minutes. After 15 minutes, the functions are canceled. The cancellation doesn't affect the Modeling Service in which load queries, scripts, and mappings continue to run.