Post reply

Full year Data MDX calculated member

  • July 15, 2009 at 8:51 am

    #384992

    I have an issue. Customer has a time dimension with

    Year, Half Year, Quarter and period. Which ever one the choose I need to be able to produce the sum (of which ever measure they pick) for the full year irrespective of what time slice they have chosen.

    Can anyone help?

  • July 16, 2009 at 2:28 am

    #1025506

    Hi all,

    Thanks for the many updates to this. I forgot to mention that the client is running SQL2000 (apologies fo that). I've managed to crack the MDX as follows:-

    (ANCESTOR( [Financial Time].[FINANCIAL].CurrentMember,[Financial Time].[FINANCIAL].[Fin Year] ), [Periodicity].[YTD])

    I managed to hook in to another calculation that provides YTD , thus the ancestor function provides the last member of any given year level irrespective of what time slice the user selects.

    Hope this helps any other users out there.

    😀

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

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