Marlene Knaup
Posts
-
Rank for top list with multiple dimensions
Hi all, I would like to share with you the way to create this Top 3 Customer list: I needed a Top 3 Customer list but also information about the Salespersons. The smart calculation "Rank Desc" wou...
-
Calculations with specific level
Hi all, I have the following table in TARGIT (Column A-C), but need to realize the calculation in Column D and E. All dimensions are user dimensions. I tried a calculated measure sum(0, d1(l(1,1))...
-
Ranked dimensions in bar/column chart
Hi all, We would like to display this table as a bar or column chart. I used a rank to see only Top 5 per Company. The result should show the Company on x-Axis. And per Salesperson as a STACKED ba...
-
User Dimensions - valid per object or per document?
Hi all, when working with user dimensions I have the question if they are always valid per object (table, chart) or if you can also make them valid per document so that you can reuse them. We delib...
-
Case-insensitive filtering in TARGIT Client
Hi all, in one case our database and SSAS cube need to be in case-sensitive mode. This causes a filtering in TARGIT (e.g. in criteriabar) to be case sensitive as well. Is there a way to ignore thi...
-
Axis labeling for diagram with two axes
Hi all, in the following example(!) I have two axis with negativ and positiv values each. Unfortunately the 0 is not at the same height. Is it possible? Does anyone have any ideas?
-
Answered
Change font/color in rows at a specific entry
Hi all, I have a table with 3 columns: 2 dimensions and 1 measure. If the entry in the 2nd column is "Intern", the whole row (or just the measure) should be bold or in another colour. Is that possi...
-
Change Total value in calculation
Hi all, we use a calculation where the percentage should be shown per user dimension "Year". So far so good, the formula is: sum(0, 0, m1) / sum(0, all(s), m1) Is it possible to change the formula ...
-
Impersonation is not supported in 2021
Hi all, for TARGIT 2021 Update 3 is the following note in download center: Impersonation is not supported in 2021 ('Effective user' is still supported). The move to the new HTTP communication is ...
-
TARGIT Update from 2018 to 2021 in single steps?
Hello all, When updating from TARGIT 2018 U2 to 2021 U3, is it recommended or necessary to install the last release version of 2019 first? Or are intermediate steps not necessary?