Filter on a dataitem

[Manu0521]

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,

[Lynn]

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.

[MFGF]

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

MF.