
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
Activity overview
Latest activity by Kristoffer Drejer-
Kristoffer Drejer commented, Yes, You create a color agent on measure1 with code Value > sum(d1,0,m2) Alternatively I like to specify what is happening in the color agent by naming the references like this: If for instance ...
-
Kristoffer Drejer commented, You need to create and extra column to my knowledge. Assuming your % calculations is a column, I would do this and then just hide your first column. if allcount(c1,all(c),0) = 0 then sum(c1,0,0) e...
-
Kristoffer Drejer commented, Can you upload and example cross table to show what it is you mean?
-
Kristoffer Drejer commented, Aah that changes thing then, you wrote where all measures don't contain data. But as you write now, it sounds like m2 is the budget, and m1 might be empty as no sales has occured. Then give this ...
-
Kristoffer Drejer commented, Try a visibility agent with the following formula count(all,0,all) = 0
-
Kristoffer Drejer commented, I think you need to make a view instead of an SP in SQL
-
Kristoffer Drejer commented, You can use - I have used that if I want a specific word to split at a specific place in a dynamic title.
-
Kristoffer Drejer commented, Hi Gia Hands down that issue is above what I can see a solution for. Tyler's case was easy as he only had one child. But in you case you have 5 Parrent / Childs, so that is a lot of if statements,...
-
Kristoffer Drejer commented, I think it still should work, you just need to change the column references in your calculated columns that you made. So that they are based on the columns that ignores the drills. But as we can't ...
-
Kristoffer Drejer commented, Hi Steppi, I know you found a solution, but maybe this could work, an be easier to alter later if needed? I didn't have any samples where I could make 4 dimensions, so in my case its only 2, but t...