OAS: Set Column Properties -> Data Format-> Decimal places to Zero

User_AIR3E

Organization Name

Capgemini

Description

Team,

In OAS, We need a way to update report Column Properties -> Data Format->  Decimal places to Zero at global level.

We observed that after migrating OBIEE 12c to OAS 5.5.0, there were few reports where-in few columns the  Data format -> Decimal places got changed from Zero to two automatically and hence reports were displaying decimal values instead of integers.

We can fix this by manually editing the column properties -> data format but since we have 1000+ reports , we need a mechanism to update at global level.

Thanks

 

 

 

 

 

Use Case and Business Need

Users see Decimal values in reports, instead of integer.

Original Idea Number: 0f4de47256

Randall Burcksen

Hi,

I believe this functionality already exists. When you select Column Properties/Data Format/Save as Default you have the option to save the format as the system wide default:

Note: Only administrators will have this option.

Good luck!