[Mondrian] prd3.5ga mdx external parameters

Hector Berges hberges at gmail.com
Mon Jan 25 07:26:51 EST 2010

Hi folks,

I have a problem using prd3.5ga and mdx queries containing external

But basically the issue is about the parameters upon calculations, for

with member Measures.mitja as '(Measures.contavis)/(parameter("NAgencies",
Integer, 52)' select Measures.mitja ON COLUMNS,
{[event_time].[month].currentmember} ON ROWS from [MyCube] where
parameter('ppeer', [peer], [peer].[peer1])

I've tried a lot of syntax in order to get that 'NAgencies' to work.
I got an error as if 'Integer' was not in the cube, so I understand that
mondrian recognizes the parameters if they follow this syntax:
parameter('param_name', [dim], [dim].[default_param_value])
where 'dim' is the dimension where the parameter will be applied to.

Then, I just want to know if is it possible to do this, my current
workaround is ugly and not sustainable at all.

Thanks in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100125/a4b38af3/attachment.html 

More information about the Mondrian mailing list