
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
-
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 ...
-
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...
-
Can you upload and example cross table to show what it is you mean?
-
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 ...
-
Try a visibility agent with the following formula count(all,0,all) = 0
-
I think you need to make a view instead of an SP in SQL
-
You can use - I have used that if I want a specific word to split at a specific place in a dynamic title.
-
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,...
-
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 ...
-
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...