| YTD and QTD hierarchy under Period Dim in PlanningJune 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 |
| Responses- Re: YTD and QTD hierarchy under Period Dim in Planning - Ben White on Jun 29, 2:38 PM
- Re: YTD and QTD hierarchy under Period Dim in Planning - Anonymous on Jun 29, 4:26 PM
- add a child to period - hula boy on Jun 29, 2:44 PM
- Re: add a child to period - Anonymous on Jun 29, 4:27 PM
|
|
|