Cognos Analytics

 View Only
  • 1.  Data Modules: Add new table to "View of Tables" after it's already been created?

    Posted Wed December 16, 2020 12:54 PM
    Hello all. I'm on 11.1.7 (latest fix-patch). Does anyone know a way to add a new table to a "View of Tables" after initially creating it? I have a new table I want to join to the underlying tables and then add to the view, but I'm finding absolutely NO way of doing it.

    If this feature is missing it seems like a major gap in functionality.

    Thank you

    ------------------------------
    Eric Dolley
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Modules: Add new table to "View of Tables" after it's already been created?

    Posted Wed December 16, 2020 09:22 PM
      |   view attached

    Hi Eric,

    That was missed functionality, it is planned for an upcoming release.

    In the meantime, attached is a document with a hacky technique to address this for the time being.

    // Henk



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

    Attachment(s)



  • 3.  RE: Data Modules: Add new table to "View of Tables" after it's already been created?

    Posted Fri December 18, 2020 02:50 PM

    Thank you for this. This will get me by until the functionality is officially added.

    Cheers!

    Eric



    ------------------------------
    Eric Dolley
    ------------------------------



  • 4.  RE: Data Modules: Add new table to "View of Tables" after it's already been created?

    Posted Thu December 17, 2020 01:59 AM

    Hi Eric,

    There is also a nice recording available in the IBM Accellerator Catalog here : https://community.ibm.com/accelerators/catalog/content/Tech-Talk---Framework-Manager-versus-data-modules that handles this topic ( and many other techniques ) in Data Modules

    Kind regards

    Peter



    ------------------------------
    Peter D'Haeyer
    ------------------------------



  • 5.  RE: Data Modules: Add new table to "View of Tables" after it's already been created?

    Posted Thu January 28, 2021 11:28 PM
    I wish I have seen this before. Around the same date I had to build half data module again because I needed to change one table with the subsequent cascade effect, On top of that I had to re-build all the impacted fields on the related reporting. 

    The pdf contains really useful information. Coincidentally I watched  IBM Accellerator Catalog video today

    Thanks for your help, it's good to know there's an alternative solution to building the data module from scratch when a change to a primary tablet is required. In my case I needed to change the table source form a framework package to a dataset. 


    ------------------------------
    Mauro Santos Otero
    ------------------------------