July 11, 2013 at 4:29 am
Hi everyone,
I have wriiten 2 calculated measures for my cube..
my cal measures are:
create member [Measures].[A]
as
iif([measures].[sales]=0,NULL,
([measures].[Latencydays]/[measures].[sales]),
visible=1
create member [Measures].
as
iif([measures].[Responses]=0,NULL,
([measures].[Latencydays]/[measures].[Responses]),
visible=1
but results are different from database to cube..
those are...
below result is from DB:
avgsaleslatency avgResplatency latency dayssalesresponses
Null Null 0 NullNull
15 Null 15 1Null
Null 23 23 Null1
cube result
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 :
avgsaleslatency avgresponseLatency
15 23
can anybody correct me, if my measure are wrong or if there is any other way to fix it..
Thanks in advance,
Niharika
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply