The Fiscal Calendar, which stores information about the financial calendars defined in Oracle Fusion General Ledger, is used to analyze financial data.
The Fiscal Calendar allows dimensional analysis by Fiscal Calendar hierarchy. The Fiscal Calendar is defined as Dim-Date Fiscal Calendar in the Business Model and Mapping layer. It supports the following hierarchy:
Day, Fiscal Period, Fiscal Quarter, Fiscal Year, Fiscal Calendar
Multiple Fiscal Calendars can be exposed in the hierarchy. The data at the day level rolls up to Fiscal Period, which is then rolled up to Fiscal Quarter and Fiscal Year level of a specific Fiscal Calendar.
Note: | Because multiple Fiscal Calendars can be defined, users are always expected to filter on the Fiscal Calendar name in Transactional Business Intelligence queries in order to get the intended data while querying. |