[Mondrian] prd3.5ga mdx external parameters

[Julian Hyde]

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>
http://forums.pentaho.org/showthread.php?t=72548
 
Julian


  _____  

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
parameters.

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

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