Print Page - SQL Select Top 100 in Cognos?

Title: SQL Select Top 100 in Cognos?
Post by: wskacz on 14 Dec 2009 09:26:44 AM

Any idea how this is done? My business user only wants to see select records based on some criteria. Thanks, Walter

Title: Re: SQL Select Top 100 in Cognos?
Post by: cognosjon on 15 Dec 2009 03:37:36 AM

Hi,
I'm sure one on here will be able to help you with your question but I think you'll need to be a little more descriptive as to the problem you have and what you've tried so far. Once you post that info everyone will have a better understanding of how to help you move forward.

Thanks

Title: Re: SQL Select Top 100 in Cognos?
Post by: MFGF on 17 Dec 2009 09:02:20 AM

Hi Walter,

Depends on whether you are using a dimensional or non-dimensional package;

For a non-dimensional package (Query Subjects and Query Items) first rank the relevant column then filter on the rank (<= 100)
For a dimensional package, use a calculation calling the TopCount() function.

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: wskacz on 14 Dec 2009 09:26:44 AM