Post reply

Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions

  • July 22, 2015 at 7:51 am

    #302611

    Comments posted to this topic are about the item Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions

  • August 14, 2015 at 6:28 am

    #1820023

    if we are using not taking any row members and taking time dimensions on filter and if you select multiples is it works i tried but it is not working can you help me inthat

  • August 14, 2015 at 9:25 am

    #1820102

    Great detail, and easy to follow for readers with English as a second language ... :-P:-)

  • August 18, 2015 at 8:11 am

    #1820756

    Thanks for the detailed article.

  • August 18, 2015 at 6:08 pm

    #1820924

    I have a calculated Measure for parallel period.

    My requirement is when we are taking time dimension on filters and selecting multiple months it is showing error.Here i am not taking time dimension on row field . will it work with out taking time dimension on row field .when i am taking row field it is working fine if i use the some other calculation like getting the last member from the filter

    Thanks

  • March 30, 2017 at 9:56 am

    #1935767

    I'm trying to create two named sets.  The first is a rolling 13 months, the second is the sum of those 13 rolling months.  LastPeriods() with .CurrentMembers doesn't appear to work as the result pulls all members.  If I use an explicit member the LastPeriods() function works, but does not roll.  My code is below.  Any suggestions are greatly appreciated!

    LastPeriods(13,[Time].[Default].&[2017P02])         'Works but doesn't roll
    LastPeriods(13,[Time].[Default].CurrentMember)    'Pulls all members rather than the last 13?
    SUM(LastPeriods(13,[Time].[Default].&[2017P02]),[Measures].[Value])  'Error - "Invalid Named Set Definition: The Axis0 function expects a tuple set expression for the argument. A string or numeric expression was used."

Viewing 6 posts - 1 through 5 (of 5 total)

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