How to Manually Create a Data Model

Overview

This video teaches you how to manually create a data model from the Settings > Models page. It covers naming the model, choosing its role and type, and attaching the dimensions it should use.

Facts to Remember

• Every tenant needs at least one data model set to the default role.
• Model types: Standalone creates a traditional OLAP data model; Sub-model is a relational-based model type.
• Dimensions added to a model inherit the role you assigned when you originally created that dimension.

Transcript

In this video, we'll go over how to manually create a data model.

Let's start by going to our settings page.

Next, click on your models page.

This will bring up a list of your current data models.

In this tenant, we do not have any data models, so it's empty.

Let's start off by clicking add new to create a new data model.

In the name field, put in the name of your data model.

So let's call ours finance.

Data model role.

The only role we want to consider at the moment is the default role.

Every tenant needs a default data model.

So you have to set at least one data model to be default.

So we'll add the default role here.

Model type, standalone is your standalone OLAP data model.

Sub-model is a different type of model that is relational based.

We won't go into the details in this video.

So let's select standalone to create our OLAP data model.

On the right hand side, let's click add dimension to add our dimensions.

We're going to add all of them.

So the account, department, entity, period, and scenario.

The roles are inherited by what you chose when you created the dimensions.

So let's click save.

And our data model is created.

Related Articles

• Models — the model definition screen used here
• Model Dimensions — attaching dimensions and assigning their roles