Remedy Smart Reporting - CLOB Fields Best Practices INCLUDES VIDEO

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    Smart Reporting Remedy


    APPLIES TO:

    9.1.x and above



    QUESTION:

    What are the best practices when using CLOB fields on Remedy Smart Reporting?


    ANSWER:

    The best practices for using a CLOB field are the following ones:
     

       
       Use CLOB fields if absolutely required
               • Only if it is required use this type of field.
     
       
       Avoid large reports (10k+ rows) 
       
       Smart Reporting is Business Intelligence tool. 
       
       Avoid using distinct (use “show duplicates”) 
       
       Recommended from a database perspective 
       
                • This can be turned on by enabling the "Show Duplicates" checkbox on the Report Builder, Data tab. 
    1
     
       
       Transform to Varchar 
       
       Best approach to use the CLOB fields.  
      
                             •Create a calculated field using the "Transform CLOB to Varchar" formula type. 
                          •Use the created calculated field on the report as required.
                               2


     


    Article Number:

    000370149


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles