I want to do something like topCount function in DMR, but is not possible in relational model. I have tried with rank function and filter , but I do not get correct data. Is there any other way to get top 15, where measure is count distinct.

Thanks.

------------------------------
Veljko
------------------------------

#CognosAnalyticswithWatson

Hi,

You can accomplish that using rank() function and creating a filter with "After aggregation" set.

------------------------------
JEAM COELHO
Cognos Solution Architect

LinkedIn: https://www.linkedin.com/in/jeamcoelho/
------------------------------

Original Message:
Sent: Wed August 04, 2021 09:16 AM
From: Veljko
Subject: topCount function for relational model

I want to do something like topCount function in DMR, but is not possible in relational model. I have tried with rank function and filter , but I do not get correct data. Is there any other way to get top 15, where measure is count distinct.

Thanks.

------------------------------
Veljko
------------------------------

#CognosAnalyticswithWatson