Niels Thomsen
Articles
-
Use Dates as Measures
Often you have dates in your facttable that represent different stages of a certain transaction. This could be Order Date and Shipped Date as a typical example, but there are many others. In this...
-
Using the Environment Variable in ETL Studio
The environment variable is a value that you can use to retrieve the cpu version, computername and many other pieces of information on the server where your inMemory job is executed. One use case c...
-
Online Data Provider: JavaScript (example with process described)
Query a SOAP web service Here will be described an example of how to get data from a web service using the JavaScript data driver on example Nextraq. Preparation You need a documentation (http...
-
Identify the levels of your hierarchy as preparation for special calculations
Note: As of the 2025 January release, identification of hierarchy levels can also be achieved by rowlevel() and collevel() calculations: Row level and Column level calculations - rowlevel() and col...
-
Dynamic Time in Data Discovery with "empty" dates
If you build a cube in data discovery based on just one data source with some transactions, you might encounter a problem with dynamic date filters when they refer to dates not represented in your ...
-
Using TARGIT ETL Studio, Python and ChatGPT to learn about your TARGIT Installation
This example was motivated by a number of factors that came together and ended up in a small example of what you can do, which hopefully can inspire you out there. Actually, I started out investiga...
-
CMDEXEC
You can run an external program using the CMDExec Command.It takes two string parameters. The first is the full path to the external program to run.And the second holds the command line Parameter...
-
Useful Materials
Attached: TARGIT Youtube.xlsx: Excel file holding list of all Youtube tutorial videos since 2019 - including URLs
-
What to remember when someone leaves your TARGIT solution
As an administrator, you will sometimes experience that someone with a TARGIT license no longer needs it.It could be someone relocated to another department or maybe even someone who leaves the com...
-
Special characters in CSV file
The attached CSV file holds some special danish characters - the letters æ, ø and å that are danish letters, not known in the rest of the world. When you have these type of characters in your CSV f...