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.  Need Help formatting a report

    Posted 02/26/20 04:56 PM
    ​I have a report with missing requirements needed to received a degree at Institution X and the person is currently enrolled at Institution Y.  I have a list of courses from Institution Y that will met the requirement at institution X and I know if the person has enrolled in a class that meets the requirement at Institution Y and earn credits.

    Because the list of courses that could meet the requirement from Institution can be long (1 to 30+), they want the courses to show on row instead of multiple rows.  Thus the repeater.

    I need to show a row for each course from Institution Y that they have completed, Units, grade and course.  I am able to get that just fine. 

    What is happening is when I try to add that list into the report, if the requirement has 5 possible courses it shows the courses completed 5 times?

    I attached what they want it to look like and what is happening to, to help visualize what I is happening.

    Thanks!

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

    #CognosAnalyticswithWatson


  • 2.  RE: Need Help formatting a report

    Posted 02/28/20 09:40 AM
    You may want to check using Group Span to avoid repeating rows...

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



  • 3.  RE: Need Help formatting a report

    Posted 02/28/20 11:47 AM
    The group span won't let me select the Course which is the repeated and if I select a different column to do a different column to do the group span on I am losing the repeater to show everything in one column



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



  • 4.  RE: Need Help formatting a report

    Posted 02/28/20 02:41 PM
    You can create a counter and set conditional style to not show remaining repeated rows when counter > 1.

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



  • 5.  RE: Need Help formatting a report

    Posted 03/17/20 04:08 PM

    ​I am closer to what I am trying to accomplish, just can't get the Summary correct for each group




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