[Mondrian] MDX Expression like <Member> <Op> <String> failed
Julian Hyde
jhyde at pentaho.com
Thu Jun 4 07:59:27 EDT 2009
> I have not exactly understood what kind of testcase I should supply.
When I ask for a testcase I mean a small program that anyone can run, and
reproduces the problem on the foodmart data set.
See the method testUdfToString I added as part of this fix.
> I
> can explain situation when I had a problem. I create function which
> returns <String>:
>
> <String> AbcTest(...)
>
> returns one of ('A', 'B', 'C'). And than tried to use in MDX
> expression
>
> with
> member [Measure].[M:Revenue ABC] as 'AbcTest(...)'
>
> member [Measure].[M:Revenue] as
> '[Measure].[Revenue]'
> , FORMAT = '|#,##0.00|color=' || Iif([Measure].[M:Revenue
> ABC] = 'A', 'red', Iif([Measure].[M:Revenue ABC] = 'B', 'green',
> 'blue'))
> ...
>
> as result catch exception in log. Because <Member> can not be
> cast to <String>.
Fixed in change 12851.
Julian
More information about the Mondrian
mailing list