Fiscal Year format has comma

Summary

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

Content

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.