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.
Try fiddling about with the context period offset.
http://www-01.ibm.com/support/docview.wss?uid=swg27040594
http://www-01.ibm.com/support/docview.wss?uid=swg27040479
http://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cog_rlp.doc/c_cog_rlp_time_dim.html
http://www.redbooks.ibm.com/abstracts/sg248064.html?Open
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.