I have wriiten 2 calculated measures for my cube..
my cal measures are:
create member [Measures].[A]
create member [Measures].
but results are different from database to cube..
[b]below result is from DB:
avgsaleslatency avgResplatency latency days sales responses
Null Null 0 Null Null
15 Null 15 1 Null
Null 23 23 Null 1
latencydays sales responses avgsaleslatency avgresplatency
38 1 1 38 38
but as aggregate is sum for latencydays it showing the results as below:
But Here what the expected result is :
can anybody correct me, if my measure are wrong or if there is any other way to fix it..
Thanks in advance,