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.