Louise Stub Hansen
Posts
-
Several rows per dimension if empty categories - after upgrading to 2021 ?
Hi We have just upgraded from 2019 to 2021 and now it seems like there is some problems with our DataDiscovery cubes regarding dimensions with empty categories. In a crosstable the numbers get thei...
-
Formula "Month" in a data source format ?
Hi I have made a format on top of my data source. I would like to create a new column that tells me how many days there are in a specific month. I thought I could use a formula like: if month(&Da...
-
Creating a global dimension ?
Hi I am trying to create a global dimension on an organization hierarchy but it doesn’t seem to work. As I haven’t worked with global dimensions before, I then contacted a colleague from my network...
-
Excel data source: "Choose worksheet from list" dosn't seem to work?
When I create a datasource from an excel file I can choose between "the first visible worksheet" or "choose worksheet from list". But when I choose the option "choose worksheet from list" I consequ...
-
How to allow multiselection at a shared dimension in the criteria bar?
I have added a shared dimension to the criteria bar. But I can only select 1 value. How do I get the option to multiselect? I have already ticked the box for "Allow multiselection" when I created...
-
Is it possible to show a user dimension at the criteria bar with Targit 2020?
We haven't upgraded to Targit 2020 yet. But we are planning to do so in the nearest future. I have a user dimension, that I would like to use in my criteria bar at the top of my analysis. I don't s...
-
Why is the option "Select all" in my criteria bar not active (grey)?
Consequently the option "Select all" in my criteria bar is grey (not possible to use). Why is that? It is the same problem whether I use the Windows client or the Anywhere Client, and regardless wh...
-
Work around for dynamic text showing the name of latest month with value > 0?
I have a dataset with data for the latest 14 month. But update time for the various categories in my dataset varies a lot with no fixed schedule. The data source updates daily, but I never know how...
-
What is the difference between Contributions and Requests?
Under "My activities" in this forum I find Requests, Contributions and Following. What is Requests?
-
Absolute Reference Calculation
We often use absolute references when we do calculations. Maybe other members are not aware of the option? I have just answered a question from Keiron about the syntax. Below I will use his questio...