This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

YTD and QTD hierarchy under Period Dim in Planning

June 29 2012 at 12:55 PM
No score for this post
Anonymous 
from IP address 63.169.27.4

I’ve created Hyperion Planning application. Hyperion planning automatically create Period dimension with Year Total hierarchy. Year Total has Q1, Q2, Q3, and Q4. I also enable DTS for period dimension. How do I add YTD and QTD hierarchy under Period dimension? I can only add child. I cannot add sibling in Period dimension.

I would like something like this
Period (Never Share)
Year Total (dynamic Calc) Note: Year Total Hierarchy was created by planning
Q1 (Dynamic Calc)
Jan (+)
Feb (+)
Mar (+)
Q2 (Dynamic Calc)
Apr (+)
May (+)
Jun (+)
Q3 (Dynamic Calc)
Jul (+)
Aug (+)
Sep (+)
Q4 (Dynamic Calc)
Oct (+)
Nov (+)
Dec (+)
QTD (Dynamic Calc) (~)
P1QTD (Dynamic Calc)
Jan (+) (Shared Member)
P2QTD (Dynamic Calc)
Jan (+) (Shared Member)
Feb (+) (Shared Member)
P3QTD (Dynamic Calc)
Jan (+) (Shared Member)
Feb (+) (Shared Member)
Mar (+) (Shared Member)
P4QTD (Dynamic Calc)
Apr (+) (Shared Member)
So on.....
YTD (Dynamic Calc) (~)
P1YTD (Dynamic Calc)
Jan (+) (Shared Member)
P2YTD (Dynamic Calc)
Jan (+) (Shared Member)
Feb (+) (Shared Member)
P3YTD (Dynamic Calc)
Jan (+) (Shared Member)
Feb (+) (Shared Member)
Mar (+) (Shared Member)
APR (+) (Shared Member)
So on.....

Thank you

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: YTD and QTD hierarchy under Period Dim in Planning - Ben White on Jun 29, 2012, 2:38 PM
    1. Re: YTD and QTD hierarchy under Period Dim in Planning - Anonymous on Jun 29, 2012, 4:26 PM
     
  2. add a child to period - hula boy on Jun 29, 2012, 2:44 PM
    1. Re: add a child to period - Anonymous on Jun 29, 2012, 4:27 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.