3 Replies Latest reply on Feb 13, 2017 8:02 AM by Christian Berg

    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

      Default Option.jpg

       

      Requirement:

      Required Option.jpg

        • 2. Re: How to set value suppression is Repeat by default.
          S R Battula

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

          • 3. Re: How to set value suppression is Repeat by default.
            Christian Berg

            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.