You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fiscal Year format has comma

Received Response
edited Dec 15, 2020 3:45AM in Reporting and Analytics for ERP 4 comments


Is there anyway to change the default format of Fiscal Year in OTBI to remove the ','


While in OTBI it appears that all of the finical subject areas that have the Fiscal Year the default format of this data has a comma. Example the data displays as 2,020 instead of 2020.This causing every report that displays this column to update the format of this column to remove the ‘,’.

With On premise OBIEE we can go into the subject area and set the default with the default being stored in a metadata file that we can then move to the next environment.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!