Cognos Analytics

Expand all | Collapse all

Text field size limit in Data Module

  • 1.  Text field size limit in Data Module

    Posted Wed April 15, 2020 09:39 PM
    Hi All

    I tried to import excel text field and it's truncating charcters after 5000 characters.

    Is there any limit for data module text data type length or something that can be changed?


    Thanks for any input!

    ------------------------------
    Buddhi Gupta
    ------------------------------


  • 2.  RE: Text field size limit in Data Module

    Posted Thu April 16, 2020 12:02 PM
    Hi Buddhi,
    I can confirm that the limit is 5,000 characters. There is no configuration or other setting that allows this to be changed.
    From a point of interest: what kind of data are you looking at? What kind of functionality would you leverage to work with data?
    // Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 3.  RE: Text field size limit in Data Module

    Posted Fri April 17, 2020 08:43 AM
    Yes, we have fields containing more text and to display on Report as well as searching functionality on specific text within such objects. 

    With FM, We are not seeing such issues. If excel is able to hold it, in my view there should be work around to get all text string if there is limit of 5000 char per field.

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 4.  RE: Text field size limit in Data Module

    Posted Sat April 18, 2020 06:23 PM

    The file upload limits are documented 

    https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_gtsd_upload_data_files.html



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------