Ole Dyring
Articles
-
TABLEEXISTS
Can be used in an InMemory ETL script to check for existence of specified table. Returns TRUE or FALSE.Syntax:TABLEEXISTS('table_name')Example:IF TABLEEXISTS('Customers')=TRUE THENPRINT 'It is ther...
-
Web boxes example: Dynamically displaying images from IIS Virtual Directory
In this example, you will learn how to design a Web box that dynamically displays images based on criteria or filters applied in your dashboard.Use Case ExampleSuppose your data warehouse contains ...
-
AI Document Summary
[Cloud release: 2026.05.06][On-prem release: n/a][On-prem build: n/a] Note: AI Document Summary is only available to Cloud based TARGIT solutions.The AI-driven summarization feature analyzes dashbo...
-
Consumer Editing - empty crosstabs
[Cloud release: 2025.10.02][On-prem release: 2025 October][On-prem build: 25.10.10001]With Consumer Editing, you can make crosstabs editable for consumer users.These crosstabs may already contain m...
-
Consumer Editing - shared Document properties
[Cloud release: 2025.10.02][On-prem release: 2025 October][On-prem build: 25.10.10001]After setting up Document Properties for consumer editing, be sure to save them (using Save or Save As). Saved ...
-
Forecasting - overview
As of September 2025 you have three forecasting options with TARGIT. AI forecasting in front-end clients. See AI Forecasting - Designer user and Consumer user AI forecasting in ETL InMemory. See I...
-
TARGIT Server as a data source - Data Discovery
[Cloud release: 2025.11.26][On-prem release: 2026 January][On-prem build: 26.01.21003]The TARGIT Server can be used as a data source for designing new data warehouses and new cubes. Benefits includ...
-
Different calculations on subtotal level
Sometimes you may need to calculate numbers in a crosstab differently if it is on the lowest level (the leaf level) or if it is on one of the subtotal levels.ExampleIf you have a crosstab with two ...
-
Icon Package SVG files
The Icon Packages SVG files are icon packages provided by TARGIT - to be used for free by TARGIT customers. The icons are created as scalable vector graphics, and are suitable for e.g., menus, text...
-
Sorting dates
[Cloud release: 2025.09.17][On-prem release: 2025 October][On-prem build: 25.10.10001]If you have a pure date dimension, i.e., a dimension containing only dates, you can sort these dates in ascendi...