SQL Select Top 100 in Cognos?

[wskacz]

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

[cognosjon]

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

[MFGF]

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.