Author Topic: Create a Relative-Time Calculated Member  (Read 211 times)

Offline pgorge12

  • Full Member
  • ***
  • Join Date: Jan 2017
  • Posts: 8
  • Forum Citizenship: +0/-0
Create a Relative-Time Calculated Member
« 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


Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,281
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Create a Relative-Time Calculated Member
« Reply #1 on: 29 Dec 2017 03:48:46 am »
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!

 


       
Twittear