[Mondrian] prd3.5ga mdx external parameters

Julian Hyde jhyde at pentaho.com
Mon Jan 25 12:48:24 EST 2010

Argument 2 to the Parameter function is a hierarchy name, level name, or
STRING or NUMERIC. Not Integer.
See  <http://forums.pentaho.org/showthread.php?t=72548>


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Hector Berges
Sent: Monday, January 25, 2010 4:27 AM
To: mondrian at pentaho.org
Subject: [Mondrian] prd3.5ga mdx external parameters

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/23aa34d6/attachment.html 

More information about the Mondrian mailing list