Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Data module - replace table 1 with table 1a

    Posted Thu May 06, 2021 10:46 AM
    Hi all,

    I'm working on version 11.1.7 and wanted to know if Data modules have the capability of replacing a table already present in the DM with a new table was added to the database. Scenario is that we have Table 1 already being used in a DM and we have created a new copy of Table 1 as Table 1a with a few additional fields. I want to replace Table 1 in DM with Table 1a but I could not find an option to do so. Does this capability currently not exist? Or am I just missing the correct place to find it?

    Any help is much appreciated.

    Thanks,

    ------------------------------
    Nipun Gupta
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data module - replace table 1 with table 1a

    Posted Thu May 06, 2021 10:52 AM
    I'd recommend the PMsquare CogBox. The free edition contains the rename function for DM query identifiers.

    https://pmsquare.com/cogbox

    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------



  • 3.  RE: Data module - replace table 1 with table 1a

    Posted Fri May 07, 2021 01:07 PM
    Thanks Robert. I'll check it out.

    ------------------------------
    Nipun Gupta
    ------------------------------