Cognos Analytics

Expand all | Collapse all

Data Module Table Update

Jump to Best Answer
  • 1.  Data Module Table Update

    Posted Mon April 13, 2020 04:20 PM
    Hi All,

    In Data Module, When I create a table using few data server tables, I want to add one more table to it later. I am not seeing option to add new table(s) once a view is created.

    Please let me know if I am missing anything.

    Thanks for inputs!

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


  • 2.  RE: Data Module Table Update

    Posted Tue April 14, 2020 04:42 AM
    Hi Buddhi

    I have the same problem using 11.1.5

    One way is to create a new view on top of the current view and also select the new table(s) and then change the Identifier on both views, so the new view gets the old views Identifier, this way the relations use the new view.

    Another workaround I use is creating a new calculation(s) in the View, there you can select the fields from the new table(s).


    Hope this help.

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



  • 3.  RE: Data Module Table Update

    Posted Fri April 17, 2020 12:36 AM
    Hi Buddhi,
    It's not currently supported, but on the list of things to be addressed.
    // Henk

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



  • 4.  RE: Data Module Table Update
    Best Answer

    Posted Fri April 17, 2020 01:17 AM
    Edited by MOHAMMED OMAR KHAN Fri April 17, 2020 01:17 AM
      |   view attached
    Hi @Buddhi Gupta,

    As Henk mentioned, this is not in the product now but is a well known enhancement request and we definitely recognize the need for it. Glad to say that this is on the roadmap to be addressed.

    In the meantime, I attached a document written by @DENNY NAREZNY with a workaround which highlights how you can achieve this today.

    Best Regards,​​

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

    Attachment(s)