[Mondrian] Store/Restore MDX Query ?

Julian Hyde jhyde at pentaho.org
Fri Nov 16 11:34:17 EST 2007

Mondrian doesn't support this.
One option is to convert explicit members into parameters. This is useful if
you are creating a set of reports, less useful for end users saving their
Matt Campbell recentedly (change 10052) added an option to tell mondrian's
parser/validator to ignore invalid members: see
mondrian.rolap.ignoreInvalidMembersDuringQuery in MondrianProperties.java.
This will be in mondrian 3.0.


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Eduardo Andrade
Sent: Friday, November 16, 2007 3:23 PM
To: Mondrian Mailing List
Subject: [Mondrian] Store/Restore MDX Query ?

we're using using jPivot+Mondrian to provide multidimensional analysis.
We permit that users save their "views" of data (MDX Query) and restore them
The problem is that some MDX queries that jPivot built, contains explicit
referneces to dimension members, thus limiting the view of the underliyng
data. So if data changes on the datasource, the view doesn't present those
Is there a way to achieve this ? Storing something that is independent of
the data, automatically ?

P.S.: I know that probably this is a jPivot limitation but i just want to be
sure that I can't use mondrian to store/restore the model with some
arbitrary state reflecting a user's view of the data. 

Thank you so much,
Eduardo Andrade
eduardofandrade at gmail.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20071116/285ea998/attachment.html 

More information about the Mondrian mailing list