Dear All,
I have a requirement of Day wise planning (Sales Planning) using Hyperion Planning. What is the best way to define the day wise calender in Hyperion?
I have two options in my mind as follows.
1. Expand the period dimension by creating weeks and days below each month. This will end up in having more than 400 members in Period dimension and Month will become Parent which will impact other modules.
2. Create a custom dimension Days to store weeks and Days ( 5 weeks and 31 days) and store the data in combination of Year, Month and Days. But how to restrict the users from Selecting day 31 for month like Apr, Jun, etc.
Is there any other better way to handle the Day wise planning in Hyperion Planning?
Also I want to define the date in DD-MM-YYYY format for each days through out the year and define weekends (Thu,Fri & Sat) and weekdays. Is there any way to automate this.
Thanks in Advance.
Regards,
Sunil