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
Back to discussions
Expand all | Collapse all

Sorting within a data module

  • 1.  Sorting within a data module

    Posted 09/10/20 09:05 AM
      |   view attached

    Is it possible to sort data items in a data module? I am not seeing a way to do that and my users have to browse through long lists of data to find what they need. 

    I've attached a pic of what the GOSALESHR data module looks like. I want to sort the items under Employee alphabetically.



    ------------------------------
    Dave Chirayath
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Sorting within a data module

    Posted 09/10/20 09:12 AM
    What version are you on?
    At least In 11.1.5 and 11.1.7 it is simply drag and drop in the data module

    Never mind the errors, just an example where I'm dragging an item to reorder it.



    ------------------------------
    Sandeep Dhirad
    Elkjøp Nordic
    ------------------------------



  • 3.  RE: Sorting within a data module

    Posted 09/10/20 09:30 AM

    I am on 11.1.4. 

    So you have to manually order the items in the data module then? I was looking for a way to sort everything within the data module that wasn't so time-consuming.



    ------------------------------
    Dave Chirayath
    ------------------------------

    Original Message


  • 4.  RE: Sorting within a data module

    Posted 09/10/20 09:43 AM
    Edited by System Admin 01/20/23 04:50 PM

    You need to manually sort query items in the module.   This is done by drag and drop.  This will allow you to present the query items in the order you want.   

    You can put query items into folders, which can organize query items by some subject area.

    There is a search control at the top of the metadata tree in dashboards and authoring.  This allows users to search for objects which they know by name.



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



  • 5.  RE: Sorting within a data module

    Posted 09/10/20 10:04 AM
    Thanks, Ian - I'll try out the folders you mentioned.

    ------------------------------
    Dave Chirayath
    ------------------------------

    Original Message


  • 6.  RE: Sorting within a data module

    Posted 09/11/20 09:48 AM
    PMsquare is going to be releasing a utility that allows this very soon!

    ------------------------------
    Ryan Dolley
    2019 IBM Champion
    www.ibmblueview.com
    www.pmsquare.com
    Connect with me on LinkedIn: linkedin.com/in/ryandolley
    ------------------------------

    Original Message


  • 7.  RE: Sorting within a data module

    Posted 09/11/20 10:19 AM
    Will this be in the accelerator catalog?

    ------------------------------
    Jo Marie Sellner
    ------------------------------

    Original Message


  • 8.  RE: Sorting within a data module

    Posted 09/14/20 03:48 AM
    What type of sorting would you want?

    Right now when you click my extension it opens a table that lists every table in the model and presents three buttons. Ascending, Descending, Magic.

    Magic groups the data items by type then sorts ascending by name

    With magic it sorts by
    1. Folder
    2. Filter
    3. Identifier
    4. Attribute
    5. Facts
    6. <Anything else>

    Can you think of any other sorting mechanisms?

    ------------------------------
    Paul Mendelson
    ------------------------------



  • 9.  RE: Sorting within a data module

    Posted 09/14/20 08:11 AM

    I want the sorting you describe for easier navigation for my users who are building out data modules. 

    I am not seeing the buttons you describe. Is magic an extension? I am not seeing it listed in the Accelerator Catalog.



    ------------------------------
    Dave Chirayath
    ------------------------------

    Original Message


  • 10.  RE: Sorting within a data module

    Posted 09/14/20 09:37 AM
    It's going to be part of the toolset PMsquare is releasing. I'm not entirely sure when it will be released, but it soon be soon.



    Original Message


  • 11.  RE: Sorting within a data module

    Posted 09/14/20 09:50 AM

    What version of Cognos are you using with Magic?



    ------------------------------
    Dave Chirayath
    ------------------------------

    Original Message


  • 12.  RE: Sorting within a data module

    Posted 09/14/20 12:27 PM
    I've tested it on r5 through r7 and it works great. It's not released yet, but will be soon.



    Original Message


Related Content