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...
-
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...
-
Optimize your Search in TARGIT Community
When you search through the TARGIT Community, you can potentially get a lot of hits that are not relevant to you. There are a few ways of making your search more accurate and bring down the number ...
-
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...
-
Identify the levels of your hierarchy as preparation for special calculations
If you have a multi-level hierarchy in TARGIT, you can refer to levels with modifiers that can help you refer to: Children (the level below the current one) Siblings (all dimension values one the ...
-
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 ...
-
Submit your questions here for our Q&A Webinars!
Next Session: October 4th, 15.00 CEST / 9.00 PM EDT Do you have a question for our team? Ask it below to hear the answer at our next Q&A session on all things TARGIT. Participants can ask about th...
-
TARGIT Management - Multiple Logins
Note: From the 2023 August version, the setting for allowing multiple logins have been removed from the TARGIT Management client. From the 2023 August version, multiple logins to the TARGIT Managem...
-
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...
-
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...