Cognos Analytics

 View Only
  • 1.  Cognos dashboard: sort table by column not in table

    Posted Mon May 30, 2022 12:30 PM

    Hi!

    I have a table in Cognos Dashboard that I'd like to have sorted by a column that I do not wish to have in the table.
    Is it possible?

    (more specifically: I would like to have rows sorted by a similarity value, but the similarity should not be seen by the final user) 



    ------------------------------
    Sergio Marinho da Silva
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos dashboard: sort table by column not in table

    Posted Mon May 30, 2022 02:49 PM

    You are restricted to sorting by a column in the table.  

    You can hide columns.   

    Another approach would be to create a view using the two tables which includes the query items you want to expose in the report.  That allows you to sort your column by the other column as they would be in the view, and hide those which you do not want to have exposed.

    There could be other variables in play which are not mentioned and would affect how one would define the problem and how to deal with it.

    I'm not quite sure what "similarity value" means.  I'm assuming you mean 'similar value'.



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



  • 3.  RE: Cognos dashboard: sort table by column not in table

    IBM Champion
    Posted Tue May 31, 2022 01:55 AM
    Hi Sergio,

    If you are using Data Module, you can sort a column (Month) based on a Month number column that will not be displayed in your dashboard.


    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 4.  RE: Cognos dashboard: sort table by column not in table

    Posted Thu June 09, 2022 05:07 PM
    I submitted an Idea about this: https://ibm-data-and-ai.ideas.ibm.com/ideas/CA-I-3751
    Please feel free to vote for it.

    ------------------------------
    David Hill
    ------------------------------