Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Problem with Calculated Member - ParallelPeriod

Answered Problem with Calculated Member - ParallelPeriod

  • Monday, February 18, 2013 5:22 PM
     
     
    Sign In to Vote
    0

    Hi guys,

    I'm having some problems using the ParallelPeriod MDX expression, I wrote this expression:

    (ParallelPeriod([Period].[Period].[Year], 1,
    [Period].[Period].CURRENTMEMBER),
    [Measures].[Measure1])

    But SSAS is showing me data from 2 days after the date I'm analysing. I wrote another MDX to show me the date that SSAS is considering:

    (ParallelPeriod([Period].[Period].[Year], 1, 
    [Period].[Period].CurrentMember).MEMBER_NAME)

    And the results are wrong, like this:

    01/01/2013        -     03/01/2012

    02/01/2013        -     04/01/2012

    03/01/2013        -     05/01/2012

    I hope anyone can help me! =)

    Thanks!


    Daniel Reino - Analista Business Intelligence / DBA

     

All Replies

  • Monday, February 18, 2013 5:49 PM
     
     Answered
    Sign In to Vote
    0
    Problem solved! It was the day of week level in the time hierarchy, I remove it from the hierarchy and everything works! =)

    Daniel Reino - Analista Business Intelligence / DBA

    • Marked As Answer by Daniel Reino Monday, February 18, 2013 5:49 PM
    •