If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Topcount of member

Started by Ammus1234, 10 Mar 2016 06:52:52 AM

Previous topic - Next topic

Ammus1234

Hello,

Cognos version 10.2.2
Backend: Microsoft analysis service cube

I want to find the top 10 records based on the creation date of an order which has an amount.

I tried something like
head(order(<member>,caption(<member>),basc),10)

But I didn't manage to get any data for this report.
order(<order number member>,caption(<order creation member>),basc) works but when I take the head no data available.

I couldn't use topCount function as it gives an error saying a value is required. I couldn't use member caption in topcount.

Could someone help.
Thanks in advance.