Using Report Studio with Power Cubes

[robinsks]

Hi,

How can I filter a value out of a powercube dataset in report studio?
I can do this when using tables using for example <> 'X' in the filter.
If I try this when the data comes from a powercube then I get an error
'Invalid coercion from 'hierarchy' to 'string'. If I remove the quotes I get a parsing error.

How can use this type of filter with a cube using report studio?

Thanks

Kevin

[almeids]

I'm not on C8 but have seen reference to a "caption" function as a means of referencing category values in a cube datasource
HTH

[rockytopmark]

Use the Filter() function, and incorporate the caption() function to get the strings of the member(s). 

Also, the use of Filter() will be on your row/column edge expressions in a crosstab, not in a query filter.  If in a list, it will be one of your columns, obvioiusly, again not in a query filter.

There is a lot of good help in the Report Studio on-line help and of course the user guide, that explains all the dimensional reporting functions, like Filter() and Caption()