Author Topic: Period to Date Growth & Growth% - Dynamic cubes  (Read 918 times)

Offline akshara_a

  • Full Member
  • ***
  • Join Date: Sep 2015
  • Posts: 17
  • Forum Citizenship: +0/-0
Period to Date Growth & Growth% - Dynamic cubes
« on: 23 Aug 2016 04:57:33 pm »
Hi All,

I have created a time dimension and set Auto generate relative time members to 'true'.

I have created a custom period to date definition as Quarter to date Last Year. That is if current year is 2016 and current quarter is Q3, then this would evaluate to 2015, Q3 to date.

I need to create a member -  Quarter to date growth% over last year. That percentage of difference between Quarter to date Current year and Quarter to date Last Year. Can anybody help me with this please?

Cube designer automatically creates Quarter to date growth%, but that shows difference between Q3 of 2016 and Q2 of 2016.


Offline akshara_a

  • Full Member
  • ***
  • Join Date: Sep 2015
  • Posts: 17
  • Forum Citizenship: +0/-0
Re: Period to Date Growth & Growth% - Dynamic cubes
« Reply #2 on: 24 Aug 2016 03:59:11 pm »
Thank you for the response. I have already gone through all these links, but none of explains how to get to a solution.

Quarter to date (Q3 2016) is already available by default.
I have created Quarter to date (Q3 2015) by setting the below properties and it works perfectly fine.
           To-date Period : Quarter
           Target Period : Day
           Target Period Offset: 0
           Context Period: Year
           Context Period Offset: -1

Now I need a member which gives me Q3 2016 vs Q3 2015 (Quarter to date growth% over last year). Can you please tell if this is possible and if it is can you share me the syntax. I tried multiple ways and failed.

 


       
Twittear