Cognos Analytics

 View Only
Expand all | Collapse all

First post / new Cognos user: How do I create a list containing only the summary rows?

  • 1.  First post / new Cognos user: How do I create a list containing only the summary rows?

    Posted Fri February 05, 2021 06:25 PM
    Hi all,
         This is my first post and I just started using Cognos this week.  I am working toward creating some KPI reports for a client, and came across a challenge I haven't figured out.  I have a list with summary counts, and I want ONLY the summary rows, not the data rows, for a brief summary chart.  I haven't found a way to hide the other rows.
         Any tips would be greatly appreciated.  At some point I want to create a bar chart but haven't been able to figure out how to get the data in there yet, so will tackle that in the future.

    Jim



    ------------------------------
    Jim Denton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: First post / new Cognos user: How do I create a list containing only the summary rows?

    IBM Champion
    Posted Sun February 07, 2021 12:10 PM
    Hello @Jim Denton

    I understood that you would like to see:
    00101-Count:4
    00103-Count:2

    Create a query containing substring("Subnum",1,5) + one query item with "COUNT(1 for substring("Subnum",1,5))". Have autosummarize selected in your query.

    Depending on your datamodel and the indexed columns there might be a faster / more elegant solution. 

    See theses screenshots for details:


    Gives me the numer of items per AccAreaID:



    hth.





    ------------------------------
    Ralf Roeber
    https://linkedin.com/in/ralf-roeber-470425a/
    ------------------------------



  • 3.  RE: First post / new Cognos user: How do I create a list containing only the summary rows?

    Posted Mon February 08, 2021 01:10 AM
    Another alternative would be to select the cells you'd like to hide and in the properties panel under the title BOX, select Box Type = None

    ------------------------------
    Mauro Santos Otero
    ------------------------------