If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Period to Date Growth & Growth% - Dynamic cubes

Started by akshara_a, 23 Aug 2016 04:57:33 PM

Previous topic - Next topic

akshara_a

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.


akshara_a

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.