Oracle Analytics and AI

Enterprise Calendar and Fiscal Date dimension

Hi,

Just wanted to know what is the effect setting "Enterprise Calendar" in the FDI reporting configuration?

We have 2 option, which is the organisation calendar and gregorian calendar.

Does this affect the OACS reports and Semantic layer? if yes, in what way?

Also, what is the source in populating the the below Fiscal Date tables in FDI? How do we extend the rows to include earlier fiscal years?

DW_FISCAL_DAY_D

DW_FISCAL_PERIOD_D

DW_FISCAL_QUARTER_D

DW_FISCAL_YEAR_D

Find more posts tagged with

Fusion AI Data Platform

Accepted answers

All comments

fbarazan-Oracle

It is documented as follow: Enterprise calendar related columns are added under Time Dimension. All time options seen in the reporting layer are based off the calendar that you select as the parameter value in the reporting configuration.

Suzanne Gill-Oracle

@Ian Cosinas This documentation may be useful as well:

https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/global-parameters.html#GUID-ED1F65C3-387C-468C-A50C-2A46A57B3BE7

and

https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/set-global-report-parameters.html

Good luck!

VkDe

Hi @Ian Cosinas

When we select organization calendar, does it mean only that particular calendar gets loaded into the period tables?