Niels Thomsen
Articles
-
Data Model Editor, explained
In this article we describe how to: Setup a connection to a relational database in TARGIT Management Use the data model editor to create a Data Model on some tables from the Relational Database Fi...
-
Data Sources Overview
For an overview of the data sources available for both InMemory and Data Discovery, please visit this page. All of the Data Discovery sources are included in the installation of TARGIT Data Discove...
-
What does a data model in Data Discovery support - and what does it NOT support
In this data model we have 2 fact tables holding the numbers we would like to analyze and 2 dimension tables that hold unique employee IDs and unique dates. What does this data model support? Y...
-
Calculate date differences in Data Discovery formats
Sometimes you might want to calculate the difference between 2 dates - or maybe the difference between today and a certain date. The data source could look something like this: Now we want to ca...
-
Wrong interpretation of dates in Data Discovery and how to fix it
Sometimes dates are not recognized - or maybe even worse misinterpreted, and we have to fix it before the dates are stored correctly in Data Discovery. This data source looks straight forward - but...
-
Wrong interpretation of column data type in Data Discovery because date is invalid
When you load data into Data Discovery, they are automatically interpreted - and sometimes they will give you an error. In this case we are loading in an excel sheet with an invalid date: Notice ...
-
Relations between Fact tables and Dimension tables - wrong way and right way
When you build data models, there are some conventions you need to follow to be sure that the data model will always return correct results. You need to understand concepts like: FACT tables and D...
-
Wrong interpretation of column data types in Data Discovery because first rows in data source are misleading
When you load data into TARGIT Data Discovery, you can experience that a column you thought was a date, an integer, a decimal number, etc. was interpreted differently by TARGIT Data Discovery. Th...
-
Parent-child - how to transform and get ready for TARGIT Data Model Editor
This example shows how to read from a database table where parent-child is implemented in a traditional way, and transform this into a dimension table that can be utilized directly in the TARGIT Da...
-
CSV and Excel import loop
This is an example of reading through a list of csv and excel files and appending them to an inmemory table. The project can be used as inspiration and starting point if you need to read through a ...