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??
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.