Are you saying you already deployed your app with summary time periods? If so you may need to re-create your application. One question I would have is if the end users will be planning at this level of detail as well or if this is strictly for reporting purposes. I would create my custom periods (level0) and then create my summary levels after the fact.
I've already deployed my application with Weeks as the base time period and the months as summary time periods.
Users will be planning and reporting at this level.
I have no problem recreating my application, what i'm asking about is that how to change the start month and the week distribution as they're fixed to January and Even.
I'll try what's mentioned in the below link.
please tell me if the start month and week distribution can be changed in another way.
No, unfortunately, this is the approach to take. As I'm sure you are aware, Oracle will typically not want you making updates to the underlying tables, but in this instance this is the approach to take as it is much better than re-creating the application.
i don't mind recreating the application, the problem is that there is no where to define it in the EPMA application creation, once you select CUSTOM time dimension, it will default and dim the weekly distribution and the start month. and this was my problem.
So once you've created your app, you went and built your hierarchy. After that did you go back and select the appropriate properties (Base Time Period, Summary Time Period, Year Total Time Period, etc). If you don't get the properties right, the deploy will fail
No, let's ignore the created application.
If we're creating a new application now on EPMA and we select CUSTOM period dimension, is there a way to select Weekly distribution other than even and select start fiscal month other than Jan ??? as these options are dimmed once you select Custom dimension for period.
Weekly distribution is for the applications which use standard months as periods. The way it works is that if you choose to distribute any figure that you input to quarters or year total down to months using weekly distribution, it assumes the first month in a quarter has 4 weeks, second month has 4 weeks and the third month has 5 weeks assuming you have set weekly distribution to 445.
But if you build your period dimension with weeks this is not applicable therefore the allocation is done evenly.
Thanks Alp, I got your point.
What about the First fiscal month?