Ggtcf

Why "be dealt cards" rather than "be dealing cards"?

What's a natural way to say that someone works somewhere (for a job)?

Teaching indefinite integrals that require special-casing

At which point does a character regain all their Hit Dice?

How was Earth single-handedly capable of creating 3 of the 4 gods of chaos?

Why does John Bercow say “unlock” after reading out the results of a vote?

How could Frankenstein get the parts for his _second_ creature?

Applicability of Single Responsibility Principle

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

Generic lambda vs generic function give different behaviour

Can I use my Chinese passport to enter China after I acquired another citizenship?

Ways to speed up user implemented RK4

Can criminal fraud exist without damages?

What will be the benefits of Brexit?

Hide Select Output from T-SQL

voltage of sounds of mp3files

How do I rename a LINUX host without needing to reboot for the rename to take effect?

Mapping a list into a phase plot

Valid Badminton Score?

If you attempt to grapple an opponent that you are hidden from, do they roll at disadvantage?

Is the destination of a commercial flight important for the pilot?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

What are the ramifications of creating a homebrew world without an Astral Plane?

Curses work by shouting - How to avoid collateral damage?

Creating a calculated measure to display prev month value

MDX Measure for Whole Previous Month (or previous month average day value)SSAS CUBE Calculated member based on different members in dimension and different measuresTime Calculation + Measure Calculation combined giving incorrect answer (SSAS)Calculated member to get dimension value in previous yearMDX Last Month to date not showing value on Day level when month has different number of daysMDX calculation for 12 rolling monthsSSAS mdx query ParallelPeriodMDX - Calculated MTD measure returning null valueCalculated measure for multiple date hierarchiesSSAS calculated measure gives infinite/null values

0

I have a cube(multidimensional) in SSAS which contains a dimension with a period hierarchy(year, month, periodcategory, periodcode) and a measure "Amount"

Now i try to make a calculated measure which returns the value Amount for the previous month - value Amount for the current month (this will then only be different from the current amount when drilled down to month in the period hierarchy).
I read a lot of posts already about ParallelPeriod function or lag(1) but i don't see how this could help me in this case.

Any advice would be really helpful.

ssas mdx multidimensional-cube

share|improve this question

edited Mar 8 at 9:46

Tim

asked Mar 8 at 9:40

TimTim

112

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Why don't any of the posts you read help? What is different about your cube that prevents the solutions that work for others from working for you?
  
  – Tab Alleman
  Mar 8 at 16:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I too thought ParallelPeriod would be perfect here. Maybe you could post a simple MDX query first: one that shows how you get values for the current month (or a hardcoded month). Then we can advise how to gradually develop that query.
  
  – Magnus Smith
  Mar 15 at 21:13
  

  
  
  
  

add a comment | 

0

I have a cube(multidimensional) in SSAS which contains a dimension with a period hierarchy(year, month, periodcategory, periodcode) and a measure "Amount"

Now i try to make a calculated measure which returns the value Amount for the previous month - value Amount for the current month (this will then only be different from the current amount when drilled down to month in the period hierarchy).
I read a lot of posts already about ParallelPeriod function or lag(1) but i don't see how this could help me in this case.

Any advice would be really helpful.

ssas mdx multidimensional-cube

share|improve this question

edited Mar 8 at 9:46

Tim

asked Mar 8 at 9:40

TimTim

112

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Why don't any of the posts you read help? What is different about your cube that prevents the solutions that work for others from working for you?
  
  – Tab Alleman
  Mar 8 at 16:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I too thought ParallelPeriod would be perfect here. Maybe you could post a simple MDX query first: one that shows how you get values for the current month (or a hardcoded month). Then we can advise how to gradually develop that query.
  
  – Magnus Smith
  Mar 15 at 21:13
  

  
  
  
  

add a comment | 

I have a cube(multidimensional) in SSAS which contains a dimension with a period hierarchy(year, month, periodcategory, periodcode) and a measure "Amount"

Now i try to make a calculated measure which returns the value Amount for the previous month - value Amount for the current month (this will then only be different from the current amount when drilled down to month in the period hierarchy).
I read a lot of posts already about ParallelPeriod function or lag(1) but i don't see how this could help me in this case.

Any advice would be really helpful.

ssas mdx multidimensional-cube

share|improve this question

edited Mar 8 at 9:46

Tim

asked Mar 8 at 9:40

TimTim

112

share|improve this question

edited Mar 8 at 9:46

Tim

asked Mar 8 at 9:40

TimTim

112

share|improve this question

edited Mar 8 at 9:46

Tim

asked Mar 8 at 9:40

TimTim

112

asked Mar 8 at 9:40

TimTim

112

asked Mar 8 at 9:40

TimTim

112