Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Data Module Union Query

    Posted Tue November 03, 2020 02:21 PM
    Hi All,

    I am not finding option to refresh union if I add/delete columns from base query subjects in Data Module.

    Is there any work around without recreating Union query after each updates?

     
    Thanks for any inputs!

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

    #CognosAnalyticswithWatson


  • 2.  RE: Data Module Union Query

    Posted Wed November 04, 2020 03:14 PM
    I tried by creating calculation on final Union query but it didn't work. Only work around is to recreate Union and change identifier to original Union to avoid impact to subsequent Models. 

    It would have been great to provide interface for Join, Union similar to when we create View to be able to modify when base queries are changed.


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