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.
Good one bro…is there a way we change weekly distribution of an existing app from 445 to 544
I've not checked that option. 🙂
Nice! How would you handle leap years?
This was an experiment to utilize the summary time period concept. Current one doesn't handle leap years, for leap year you'll have to add 366 as periods in year. (but user will have to check whether it is leap year and enter data accordingly)
I am facing issue when adding adding 3rd level summary time period.
when i make Q4 and adj period as one STP and the make 2nd half STP with Q3 and Q4 and Adj STP
I am started my new journey in EPM Hyperion application and i have some question regarding period dimension i.e why period dimension data type is unspecified? If we used other data type what problem we have in the application.