Weeks, Months and Days in Planning Period Dimension


I was playing around with the Calendar definition of Planning application. (This was done mainly to check whether I can add Months and Weeks into Planning Period Dimension)
I was trying to see whether I can make use of Summary periods to achieve this.
Create a Planning application with Custom Time Period. I chose to add 365 Periods per Year and prefixed them as DD_
Application was created, select the first member (DD_1) and then click on Add Summary Period.
Name the summary period as January. (Keep Start Period and End Period as DD_1 and DD_365)
Select DD_32 and click on Add Summary Period to add February
You can follow the same steps to add other months.
If you like to add Weeks, then add week information first and then add Months later.
You can add alias for all level 0 members as days in a month (DD_1 as Jan 1st, DD_365 as Dec 31st etc, etc)
You cannot have different week hierarchy for different years. All the years will have same week hierarchy. If you would like to keep different hierarchy, you can create a reporting application with the same data and different week hierarchy.
HTH
Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

0 thoughts on “Weeks, Months and Days in Planning Period Dimension