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

Create a Relative-Time Calculated Member

Started by pgorge12, 28 Dec 2017 12:42:45 PM

Previous topic - Next topic

pgorge12

Hi, I am attempting to create a time-related calculated member. I already added the additional default members  such as Current Year, Prior Year, Year to date Change etc. I wanted to create a 13 Month member where it goes back 13 months from the current month. So if it were applied today, It would show November 2016 to December 2017. I want to be able to drill down from this member to show the 13 months individually as well. How can this be created? If you see the attachment, you will see what I have done so far. When I go into the cube and I drag this member in, it says July 2018. Does anyone know how to create such a calculated time member?

Thanks


MFGF

Quote from: pgorge12 on 28 Dec 2017 12:42:45 PM
Hi, I am attempting to create a time-related calculated member. I already added the additional default members  such as Current Year, Prior Year, Year to date Change etc. I wanted to create a 13 Month member where it goes back 13 months from the current month. So if it were applied today, It would show November 2016 to December 2017. I want to be able to drill down from this member to show the 13 months individually as well. How can this be created? If you see the attachment, you will see what I have done so far. When I go into the cube and I drag this member in, it says July 2018. Does anyone know how to create such a calculated time member?

Thanks

Hi,

This sounds like a rolling 13 months is required? Start by selecting the New Custom N-Period Running Total Definition button. Set the Number of Periods to 13, the Target Period to Month, the Target Period Offset to 0, the Context Period to Year, and the Context Period Offset to 0.

Does that work?

MF.
Meep!