Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Fiscal Quarter Option

Needs Votes
21
Views
1
Comments

I have been working for our supply chain as an analyst for almost a year and I am constantly needing to create fiscal quarters to reflect our fiscal time period off of other shipment timestamps using timestampadd. I thought it would be useful for us and maybe other companies to have a built in fiscal addition to add to dates.

2
2 votes

Needs Votes · Last Updated

Comments

  • If related to OAC/OAS and using an RPD, you should be able to create a custom time hierarchy for fiscal instead of doing manual calculations. OAC/OAS supports custom calendars but it needs to be implemented.