DMR Report

[srinu1253]

Hi Guys,

I am using a DMR package and I am tring to filter a data item (Product Line).
I am getting the following Error
QE-DEF-0478 Invalid coercion from 'level' to 'member, measure' for 'rolevalue('_memberCaption',set([Product Line  Members])) like 'Camping Eqipment''.
.Can any one help??

[MFGF]

Hi,

Sounds like you are mixing relational and dimensional reporting styles here.  I'd hazard a guess that you have used this expression in a detail filter?

It's probably best to try an alternative approach.  You could:

a) Just drag in the relevant members ([Camping Equipment] etc) from the package tree and completely delete the filter.
b) Add a Query calculation to the report utilising a filter() function and delete the detail filter - eg filter([Your Product Line Level],[caption([Your Product Line Level]) contains 'Camping Equipment')

If you must stick with this approach, then modify your detail filter expression to be:

rolevalue('_memberCaption',[Your Product Line Level]) like 'Camping Equipment'

MF.