Creating a Data Model

When we have data in the InMemory database, we can start creating a Data Model on top of these data.

In short, creating a Data Model involves:

• Setting up Foreign Key to Primary Key relations between the involved tables.
• Defining dimensions, dimension attributes and dimension hierarchies.
• Defining cubes from fact tables (measure group tables).
• Defining measures and potentially calculations.

First, you will need to log on to the TARGIT Management client. Start the TARGIT shortcut from the Windows Start menu and click Manage Server for the selected server (localhost, in this case):

The TARGIT Management interface contains a number of tabs relevant for the general configuration and administration of a TARGIT Server. To connect the TARGIT Server to the newly created InMemory database, we must move to the Connections tab.

Here, by right-clicking in the blank area, we can add a new connection:

TARGIT’s InMemory database is categorized as a Relational Database:

Provide a suitable name for the new connection:

To access data in the InMemory database, we must use the login info for the default user that we configured during the installation. If you did not change the default settings, it is configured as:

• Username: default
• Password: Pa$$W0rd

With the established connection, you can now right click it to enter the TARGIT Data Model Editor:

The TARGIT Data Model Editor will start up with a blank Global Schema. Notice that the tables that were imported with the Bulk Import in the ETL Studio are available in the list on the left.

Drag the tables into the Global Schema area and connect the tables by adding relations between them.

An easy way to create a relation is to locate the Foreign Key in one table – e.g. No_ in the Sales Invoice Line table – and then drag this key to its corresponding Primary Key in another table – e.g. No_ in the Item table.

In our quite limited data model, you will need to define in total four relations.

When you create the relation, make sure that the arrow points from the Foreign Key to the Primary Key.

Tip: Use the magnifying glass to search for the required table columns.