[Mondrian] SQL WHERE clause

William Back wback at pentaho.com
Mon Feb 4 13:07:53 EST 2013


I assume you are using 3.x of Mondrian.  Add a <Sql> clause to the tables to be restricted and use a dynamic schema processor to modify the schema.  The LocalizingDynamicSchemaProcessor is an example you can look at.

Bill

--


From: Nizar Mabroukeh <nmabroukeh at crosscommercemedia.com<mailto:nmabroukeh at crosscommercemedia.com>>
Reply-To: Mondrian developer mailing list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Date: Monday, February 4, 2013 12:26 PM
To: Mondrian developer mailing list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Subject: [Mondrian] SQL WHERE clause

Can someone please direct me to the appropriate mondrian class that enables to generate WHERE clause in SQL statements?
I want to modify the code such that mondrian always generates WHERE in sql statements and always appends to it a condition based on some session variables.


Best regards and thank you in advance


Nizar Mabroukeh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130204/cad8ef16/attachment.html 


More information about the Mondrian mailing list