
Kristoffer Drejer
BI developer at Triscan Smartparts. Responsible for constructing, and maintaing the datawarehouse storing our cubes, and developing and maitning our Targit solution. www.linkedin.com/in/kristoffer-drejer-69669b74
Comments
-
Hi Hasam, You need to make any new maps SVG images, and then you can chose where you change the map picture. And then you can add the picture. I created a local folder on my Targit server tha...
-
Hi Taylor, If I understand you correctly something in the ball park of this should do the trick. I made a user dimension in my case on the X axis, with two dimension. One that ignores nothing, and...
-
Solved it: Had a measure in my DWH that counts unique Articlecodes. I then made a user dimension, where on ignores all the possible drill options, and the other ignores nothing. And then made a ...
-
Hi Tyler This should do the trick, you probably need to tweak it to fit your data though. Create a new column, I named it filter if sum(d1, 0, m1) = sum(d1, 0(l1), m1) then 1 else if count(d1, d...
-
Sounds like you data dimension is not a hierarchy but two dimensions instead? If so this should work if sum(d1, 0, m1) = sum(d1, 0(l(1,0)), m1) then 1 else if count(d1, d1:0(s), m1) = 1 then 1 else 0
-
You can disable auto-zoom in the settings for the diagram. Not totally sure what you mean by "for our solution we would need to see also the areas without data (grayed out)."
-
Hi Joke, Give this a go: First create a new measure, purpose is to figure out which group is the top group when the columns are stacked. count(d-1:0, 0, m1) Next I like to add it as a line on t...
-
Hi Ole, I am not sure how, but somehow I had managed to remove the "designed for" for several of the layouts, including the top one, which was the reason it was opened as the standard layout :)
-
Thanks for the reply Ole. Is there a way to ensure that a layout is the main layout when navigating to a document. I have a dashboard, from where you can navigate to another dashboard, with a few ...
-
Hi Danilo, So your result in your example should be 3 instead of 4, because you don't want to count the last available month, is that correct?