Cognos Analytics

Expand all | Collapse all

Sorting within a data module

  • 1.  Sorting within a data module

    Posted Thu September 10, 2020 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
    ------------------------------


  • 2.  RE: Sorting within a data module

    Posted Thu September 10, 2020 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 Thu September 10, 2020 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
    ------------------------------



  • 4.  RE: Sorting within a data module

    Posted Thu September 10, 2020 09:43 AM
    Edited by IAN HENDERSON Thu September 10, 2020 09:48 AM

    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 Thu September 10, 2020 10:04 AM
    Thanks, Ian - I'll try out the folders you mentioned.

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



  • 6.  RE: Sorting within a data module

    Posted Fri September 11, 2020 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
    ------------------------------



  • 7.  RE: Sorting within a data module

    Posted Fri September 11, 2020 10:19 AM
    Will this be in the accelerator catalog?

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



  • 8.  RE: Sorting within a data module

    Posted Mon September 14, 2020 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 Mon September 14, 2020 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
    ------------------------------



  • 10.  RE: Sorting within a data module

    Posted Mon September 14, 2020 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.





  • 11.  RE: Sorting within a data module

    Posted Mon September 14, 2020 09:50 AM

    What version of Cognos are you using with Magic?



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



  • 12.  RE: Sorting within a data module

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