Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  SQL query sorting in Data Module in CA 11.1.6

    Posted 07/31/20 11:36 AM
    Hi All,

    I see Sorting option is disabled for SQL based Tables in Data Module. 

    Is it by design or something missing to be correct in CA?


    Thanks!






    ​​

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

    #CognosAnalyticswithWatson


  • 2.  RE: SQL query sorting in Data Module in CA 11.1.6

    Posted 08/03/20 07:47 PM

    You can sort any query item in a SQL-based query subject in a model.  



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



  • 3.  RE: SQL query sorting in Data Module in CA 11.1.6

    Posted 08/06/20 03:08 PM
    Thanks @IAN HENDERSON!

    For me, somehow options are appearing grayed out. May be I am missing something? 
    sorting
    ​

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

    Original Message


  • 4.  RE: SQL query sorting in Data Module in CA 11.1.6

    Posted 08/06/20 03:38 PM
    Hi Buddhi,
    Please switch for Automatic to Enable on the property Members: above.
    // Henk

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

    Original Message


Related Content