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
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
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()