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

  • Bill Pearson

    Ten Centuries

    Points: 1359

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

  • bibhushan88

    SSC Journeyman

    Points: 94

    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

  • Lazarus Islo

    Valued Member

    Points: 68

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

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the detailed article.

  • bibhushan88

    SSC Journeyman

    Points: 94

    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

  • sb8910 67785

    SSC Journeyman

    Points: 89

    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 6 (of 6 total)

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