Search code examples
obieeoracle-bi

Setting a data format common to all analysis in obiee 12c


Is there any common configuration in OBIEE 12c , which allows to define decimal places applicable to all analysis?

For example,presently, if you want to set the decimal places for currency column, you need to take the data format of that column and change there. My requirement is to set the decimal places of currency type to a digit, which is applicable for all analysis in the application.


Solution

  • Yes. You first of all have the locale defaults per language. Then you always have the ability to format a column the way you want and then say "Save as..." and then "default for "Table"."Column"" which will format all.occurrences of this column the same way or "default for data type" which will apply it to all date columns for example.