Skip to main content

Create MDX Semantic Model

Data Sourceโ€‹

The database type used in this series is the built-in Postgres.

  1. Open the data source configuration page, click the new button, and select Postgres from the type list in the popup;
  2. Enter a unique name for this data source in the name input box;
  3. Do not select Use Local Proxy
  4. Copy the information from the system-provided Demo - PG DB for other fields. For detailed data source configuration tutorials, please refer to Official Supported Data Sources
  5. Click create, and the creation is successful;

Create Semantic Modelโ€‹

Create an MDX semantic model based on the data source.

  1. Open the semantic model page
  2. Click the New button or New MDX Model in more options, and select the data source created in Create Data Source from the data source list in the popup;
  3. Click next to enter the service directory selection interface, which corresponds to the Schema list of Postgres, and select foodmart;
  4. Click next, if you came from the new button, select Use OLAP Cube Modeling (if you came from the new MDX button, you don't need to select), enter a unique name and click create, our name is Demo - FoodMart Model;
  5. Creation is successful, and you can see the created model in the model list;

Next, you can create Dimensions and Cubes in this semantic model.