Print Page - Filter on a dataitem

Title: Filter on a dataitem
Post by: Manu0521 on 08 Apr 2014 03:32:44 PM

I have a sales rep data item and I wanted to show the reps whose name doesnt contain " No Rep" . Should I use the filter condition on the data item ?

Filter(SalesRep member set , condition ) What boolean condition should I give - I dont want rep which contain "No Rep" key word in their name.

Thanks,

Title: Re: Filter on a dataitem
Post by: Lynn on 09 Apr 2014 07:25:58 AM

Try using the caption function. The attached guide on dimensional functions will probably help you. It is referring to Cognos 8 but the content is still applicable for 10.

Title: Re: Filter on a dataitem
Post by: MFGF on 09 Apr 2014 08:44:01 AM

filter([Sales Rep level], roleValue('_memberCaption', [Sales Rep level]) <> 'No Rep')

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Manu0521 on 08 Apr 2014 03:32:44 PM