Cognos Analytics

Expand all | Collapse all

Data Length is not updated in Data Module

  • 1.  Data Length is not updated in Data Module

    Posted Mon April 27, 2020 12:02 PM
    Hi 

    When underlying table structure is changed . Example - data length, I don't see metadata refreshed in Data Module even after refreshing Data Server.


    Is this issue fixed in CA 11.1.6 or is there any work around so that we don't have to recreate table and associated joins?



    Thanks for any inputs!

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


  • 2.  RE: Data Length is not updated in Data Module

    Posted Mon April 27, 2020 12:44 PM

    Hi Buddhi,
    What is the kind of datatype change that you're making ?
    Data Modules expose a higher level data type, that groups similar underlying data types into the same category, e.g. short, int, long all are INTEGER
    varchar(10) , nvarchar(10), char(10), 10 representing any number, these all become TEXT.
    Curious, because we could have missed something.
    // Henk



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



  • 3.  RE: Data Length is not updated in Data Module

    Posted Mon April 27, 2020 01:37 PM
    HI @HENK CAZEMIER,

    Database team increased a field length in Database. Now when I re-import the metatdata in data server and check in new Data Module, I can see changed length for the field. However, in existing Data Module, when I try to reimport  metadata for impacted table, the length doesn't change for the impacted field.

    Only way I can update length by online specification editing; however for large Data Module, it just doesn't open online and have to find another way to update this specification for the field.

    If there is any alternate method without recreating whole thing, please let me know.

    Thanks!



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