Cognos Analytics

 View Only
  • 1.  Data Module - Restrict Table Column Name Changes

    Posted Sun August 02, 2020 05:03 PM
    Hello All,

    When the Tables are imported into the Data Module Column Names with Characters such as underscore (_), dash (-), or slash (\) are replaced with the space character.

    Is there a way to stop this behavior and keep the Database Table Column Names as is in the Data Module ?

    Thank You

    ------------------------------
    Harun Y
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Module - Restrict Table Column Name Changes

    Posted Mon August 17, 2020 03:07 AM
    Anyone has any idea ?

    ------------------------------
    Harun Y
    ------------------------------



  • 3.  RE: Data Module - Restrict Table Column Name Changes

    Posted Mon August 17, 2020 08:14 AM
    From my observations It carries DB names when:-
    • If You select both checkbox under Load Options for all Tables in Data Server
    • If you use Native SQL ( select * from Table)


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



  • 4.  RE: Data Module - Restrict Table Column Name Changes

    Posted Tue August 18, 2020 11:34 PM
    Thank You Buddhi @Buddhi Gupta​ it helped. I checked both Load Options in Data Server and used Pass through SQL (Select * from Table) which now displays the names as is.

    I am currently using Data Module and with the Pass through SQL I wouldn't be able to use the Data Module and give users access to the same Data Module.

    Cognos should have left this as Customer Choice either to replace the names or keep as is.

    ------------------------------
    Harun Y
    ------------------------------



  • 5.  RE: Data Module - Restrict Table Column Name Changes

    Posted Sun August 30, 2020 06:19 AM
    Submitted Enhancement request. Anyone looking for the similar functionality can VOTE for the below enhancement request.

    https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2893

    Thank You

    ------------------------------
    Harun Y
    ------------------------------