calculated measure in mdx

  • 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