Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Base Time Period "Daily" in PBCS

Alex1Mar 2 2016 — edited Mar 3 2016

Hi experts,

I would to know which is the best way to create my PlanType with Time dimension based in days. My application needs to plan in daily granularity.

It's important to note all cases, for example, I will need these information in my application:

Year/Quarter/Month/Day/DayName

For example will have forms that user can filter with name days like "Monday", "Tuesday",...,"Saturday".. I take into account leap year, also a type of calendar about easter season or christmas season, etc. All about time dimension with day granurality.

So my question is: How can I build this in PBCS?

1. One dimension only with Year and another with Period (day)? in that way how can I know about leap year or easter season, etc?

2. Unique dimension with all time dimension: year, month, day (name days).... it will be faster with retrieve data?

3. ¿?

Now, i'm starting my project so I have possibility to create one or two dimensions extra to goal my requirement.

pastedImage_0.png

Thanks for your time!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2016
Added on Mar 2 2016
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
6 comments
1,875 views