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):

mceclip0.png

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:

mceclip1.png

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

mceclip2.png

mceclip3.png

Provide a suitable name for the new connection:

mceclip4.png

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

mceclip5.png

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

mceclip6.png

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.

mceclip7.png

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.

mceclip8.png

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

Foreign Key

Primary Key

Sales Invoice Line [No_]

Item [No_]

Sales Invoice Line [Document No_]

Sales Invoice Header [No_]

Sales Invoice Header [Sell-to Customer No_]

Customer [No_]

Customer [Country_Region Code]

Country_Region [Code]

 

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.

mceclip9.png

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.