Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Cognos Expression Row Number ()

    Posted Thu February 27, 2020 12:05 PM
    Hello, 

    Can you please provide me an example of an expression for Cognos Data Model Calculation to derive a columns similar to SQL query 
    ROW_NUMBER() OVER (PARTITION BY XXXXXX ORDER BY YYYYYYY ASC).
    I am not getting the correct results using the rank function. 

    Thank you

    ------------------------------
    Cynthia Cangialosi
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Expression Row Number ()

    Posted Thu February 27, 2020 05:10 PM
    can you try running-count  for column  function  and see if that works?

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

    Original Message


  • 3.  RE: Cognos Expression Row Number ()

    Posted Fri February 28, 2020 10:06 AM

    running-total (count([some-other-column-such-as-ID])) works well



    ------------------------------
    Victoria Ratkos
    ------------------------------

    Original Message


  • 4.  RE: Cognos Expression Row Number ()

    Posted Fri February 28, 2020 01:36 AM
    if i got right, you can also use under Toolbox > Row Number option..

    ------------------------------
    Hashim Raza
    ------------------------------

    Original Message


Related Content