• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

PARALLELPERIOD SQL SSAS 2008

Which to following expression mean created under SQL SSAS 2008 calculation member ?

SUM(YTD(PARALLELPERIOD( [DIM DATE].[Year Group].[MONTH], 12,[DIM DATE].[Year Group].currentmember)),[Measures].[Amount])
0
AXISHK
Asked:
AXISHK
  • 2
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
What was the Amount year to date at the same point in time last year?
0
 
AXISHKAuthor Commented:
What does the 3 parameters represent in PARALLELPERIOD ?
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Let's call the three parameters A, B and C. In plain English, the PARALLELPERIOD does this following:

For this member (C), go back this many (B) time units (A).

So, in this example, for wherever we are (currentmember) in the Year Group hierarchy (C), go back 12 (B) months (A).

The syntax is therefore PARALLELPERIOD(A, B, C) - in this case, PARALLELPERIOD(months in the Year Group hierarchy, 12, the currentmember of the Year Group)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now