[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