StrToSet doesn't work in JPivot
Brought to you by:
avix
When using a StrToSet expression in JPivot, Mondrian throws the following error:
2008-06-26 08:36:18,226 ERROR [STDERR] Caused by: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature 'StrToSet(<String>, <Hierarchy>)'
The same statement executes successfully using SchemaWorkbench 3.0.3.
I believe the second parameter for StrToSet is a Dimension not a Hierarchy and hence why Mondrian cannot find it.