
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
-
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 ...
-
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
-
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...
-
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.