Cognos Analytics

 View Only
  • 1.  How to Add a new table to a view

    Posted Wed December 18, 2019 10:13 AM
    In Data Module I have created  a view of tables.
    Now I want to add another table to that view.
    If I edit the table view I am only able to add columns from the existing tables in the view. 
    How do I add a column from a table that is not already in the view? Is there something obvious I am missing or do I really have to recreate the view all over again?
    I am running 11.1.4

    ------------------------------
    Jesper Bjerre
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: How to Add a new table to a view

    Posted Thu December 19, 2019 07:24 AM
    How do you create a view in Data Module? Can you share a screen print?

    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------



  • 3.  RE: How to Add a new table to a view

    Posted Thu December 19, 2019 08:49 AM

    There are two ways.  The first is to select the module tree root node and choose new table from the context menu.  The second is to select the tables you want in your view and choose new table from the context menu.

    You can create a view from query subjects in your module, including uploaded files, and from query subjects in FM packages which have been imported into your module.

    You can't add  tables to a view once it has been created.  It would be nice if you could.

    I did not see a RFE for it but it could be already there but my search terms were not sufficient.

    https://ibm-data-and-ai.ideas.aha.io/ideas/search?page=2&project=CAOP&query=edit+view



    ------------------------------
    IAN HENDERSON
    ------------------------------



  • 4.  RE: How to Add a new table to a view

    Posted Thu December 19, 2019 07:02 PM
    Hi @Jesper Bjerre,

    As Ian mentioned, th​is funcitonality doesn't exist in data modules yet. The best to get it is by logging and voting on an idea for it if it is not logged already. 

    The way to achieve this today would be either to recreate the same view from the start and have the table as part of it, or to create a new view with the current view and the new table you want.

    Best Regards,

    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------



  • 5.  RE: How to Add a new table to a view

    Posted Fri May 29, 2020 02:53 PM
    I found the RFE:  https://ibm-data-and-ai.ideas.aha.io/ideas/CAC-I-75

    Please vote on this! :)

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------



  • 6.  RE: How to Add a new table to a view

    Posted Fri May 29, 2020 07:07 PM
      |   view attached
    Thanks @Jeremy Aude! Here is a work around that you could use today.​

    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------

    Attachment(s)



  • 7.  RE: How to Add a new table to a view

    Posted Fri May 29, 2020 10:35 PM
    Thank you Mohammed!  That is exactly what I can use for the workaround!  Have a great weekend.

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------