slicing through calculated measure

  • Hello, please I have a measure that i can compute through calculated member, or by using a tuple, the issue I am having is that when I use(slice) a dimension on rows, the result I get is different for both of them, can anyone please give a clue, the queries are below. thanks

    select

    (TAIL(nonempty([Boardingdate].[Month Short Name].[Month Short Name],[Measures].[Amount]),1).ITEM(0),[Measures].[Amount]) on 0

    ,{[DaysFromBoarding].[DFB].&[0]:[DaysFromBoarding].[DFB].&[60]} ON 1

    from

    [Strategy_Performance_Dashboard]

    **This query above gives the correct result

    ----------------------------------------------------------------------

    with

    member

    [measures].m9

    as

    (TAIL(nonempty([Boardingdate].[Month Short Name].[Month Short Name],[Measures].[Amount]),1).ITEM(0),[Measures].[Amount])

    select

    measures.m9 on 0

    ,{[DaysFromBoarding].[DFB].&[0]:[DaysFromBoarding].[DFB].&[60]} ON 1

    from

    [Strategy_Performance_Dashboard]

  • Tail returns a set you need {} aroud the measure m9

    Jayanth Kurup[/url]

  • Thats not the issue, but i can spot what is happening , but i cant fix it,

    the situation is that

    DFB JAN FEB MAR APR

    0 4

    1 5 6

    2 7 8

    3 9

    Lets say this is the matrix table, and as you can see March is the last non empty month in general, so what i am trying to return is a calculated measure that the DFB will be able to slice through for the months so from that i can do other calculations. on the result

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply