How to set value suppression is Repeat by default.

S R Battula

By Default OBIEE column properties -> column format -> value suppression  has been Suppress(default).  how to change this to default option to Repeat?.

Default Option

Requirement:

[Deleted User]

Just answered some weeks ago.

S R Battula

Thanks Christian for the update , but i am not able to open your answer.  can i have the link.

[Deleted User]

It *is* a link, but here's the core snippet from the post

"

In code:

1. <?xml version="1.0" encoding="utf-8"?> 
2. <sawsavedformat:metadata xmlns:sawsavedformat="com.siebel.analytics.web/savedformat/v1.1"> 
3.     <sawsavedformat:datatypeSavedFormats> 
4.         <sawsavedformat:datatypeFormat xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" datatype="GDT:real"> 
5.             <saw:displayFormat> 
6.                 <saw:formatSpec suppress="repeat" wrapText="true" visibility="visible" hAlign="right" vAlign="top" imagePlacement="right" interaction="action"> 
7.                     <saw:dataFormat minDigits="0" maxDigits="0" commas="true" negativeType="minus" xsi:type="saw:number"/> 
8.                 </saw:formatSpec> 
9.             </saw:displayFormat> 
10.             <saw:tableHeading> 
11.                 <saw:displayFormat> 
12.                     <saw:formatSpec/> 
13.                 </saw:displayFormat> 
14.             </saw:tableHeading> 
15.             <saw:columnHeading> 
16.                 <saw:displayFormat> 
17.                     <saw:formatSpec/> 
18.                 </saw:displayFormat> 
19.             </saw:columnHeading> 
20.         </sawsavedformat:datatypeFormat> 
21.     </sawsavedformat:datatypeSavedFormats> 
22. </sawsavedformat:metadata> 

The key are the saved formats for datatypes in webcat/system/metadata.