Ole Dyring
Articles
-
Percentile calculation
[Cloud release: 2025.01.15][On-prem release: 2025 January][On-prem build: 25.02.07520] Returns the threshold value according to the percentile_value in the referenced range. Syntax: percentile(col...
-
ROLAP calculations format strings
[Cloud release: 2025.01.15][On-prem release: 2025 January][On-prem build: 25.02.07520] In the Data Model Editor, you can add calculations based on other measures - even using advanced features suc...
-
InMemory ETL Macros
InMemory ETL Macros give you an opportunity to store scripts globally or locally for easy reuse. When you add a Macro, give it a name and a script that you want to associate with this macro. In th...
-
Show or hide Criteria Bar in Anywhere client
[Cloud release: 2024.11.28][On-prem release: 2025 January][On-prem build: 25.02.07520] The Consumer user, in the Anywhere client, can control showing or hiding the Criteria bar. Use the small show...
-
Roles - Look up user permissions
A user may be member of multiple roles in your Roles settings in the TARGIT Management client. Each role may grant or prevent their individual access rights, and a user's effective access rights a...
-
Export - default settings
When you export a crosstab from the TARGIT client to Excel, the export will use a default format. You can change the export format by selecting the 'Custom export' option. In Designer client's File...
-
Maps - overview
The 'Map' object type can be used to display data on a background image, e.g., a World map or a Country map. However, map images are not limited to geographical maps, but can be any image type, e.g...
-
Calculate Totals and Subtotals for visible data
If data in a crosstab is influenced by a visibility agent, you will see that the remaining Totals and Subtotals often are wrong. They do not take into account that some data has been hidden in the ...
-
Menus - overview
A Menu - or a Menu object - is typically used for navigation purposes. A Menu object contains one or more Menu items which we may also to refer to as simply Buttons. Menus are using Triggers to op...
-
Layouts - overview
A document may contain multiple Layouts. When you create a new document, the default layout will often be a Dashboard layout or a Report layout. However, within the same document you may add as man...