[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: Re: [Mondrian] SQL WHERE clause
From: Nizar Mabroukeh <nmabroukeh () crosscommercemedia ! com>
Date: 2013-02-04 19:06:16
Message-ID: CAK8VKfOk61_5yut+JPAYaXSZi2mFTO9Xy1O0i=qs=J8+1GgORQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Thank you, but I want to avoid using DSP.
Nizar R. Mabroukeh, PhD // Manager of Analytical Engines
Collective[i]=99 // collectivei.com
130 Madison Avenue // 3rd Floor // NYC
Founding member of the Council for Accountable
Advertising<http://councilinsider.com/>
If I emailed you this communication by mistake, please don=92t read it. Oop=
s!
Did you already read it? That is OK, but please do not send it to anyone
else. Seriously, it may be confidential. Any dissemination, distribution,
or copying of this communication, or any of its contents, is really, really
prohibited. Let=92s avoid trouble. If you have received this communication =
in
error, please send it back to me and delete the original message and any
copy of it from your computer, smart phone, tablet or any other cool device
you might use. Thanks. You are the best!
On Mon, Feb 4, 2013 at 1:07 PM, William Back <wback@pentaho.com> wrote:
> 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@crosscommercemedia.com>
> Reply-To: Mondrian developer mailing list <mondrian@pentaho.org>
> Date: Monday, February 4, 2013 12:26 PM
> To: Mondrian developer mailing list <mondrian@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
>
> _______________________________________________
> Mondrian mailing list
> Mondrian@pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
[Attachment #5 (text/html)]
<div dir="ltr">Thank you, but I want to avoid using DSP.<br></div><div \
class="gmail_extra"><br clear="all"><div><div> </div><div> </div><div><br><img \
src="http://collectivei.com/wp-content/uploads/2011/09/Collectivei.jpg" height="24" \
width="112"><font style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif"><br>
<font>Nizar R. Mabroukeh, PhD // Manager of Analytical \
Engines<br></font></font><font><span \
style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif;font-style:normal;fo \
nt-variant:normal;font-weight:normal;text-decoration:none;vertical-align:baseline;background-color:rgb(255,255,255)">Collective[i]™</span><span \
style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif;font-style:normal;fo \
nt-variant:normal;font-weight:normal;text-decoration:none;vertical-align:baseline;background-color:transparent"> \
// </span><a style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif" \
href="http://collectivei.com/" target="_blank"><span \
style="font-style:normal;font-variant:normal;font-weight:normal;vertical-align:baseline;background-color:transparent">collectivei.com</span></a><br \
style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif">
<span style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif;font-style:nor \
mal;font-variant:normal;font-weight:normal;text-decoration:none;vertical-align:baseline;background-color:rgb(255,255,255)">130 \
Madison Avenue // 3rd Floor // NYC</span></font><font size="4"><br>
</font><font face="arial, helvetica,
sans-serif"><span style="font-size:13px"><font><span><font \
color="#333333">
Founding member of the <a href="http://councilinsider.com/" \
target="_blank">Council for Accountable Advertising</a>
</font></span></font></span></font><br \
style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif"><br \
style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif"><font \
style="color:rgb(51,51,51);font-family:arial,helvetica,sans-serif;background-color:rgb(255,255,255)" \
size="1"><span style="text-transform:none;line-height:normal;text-indent:0px;letter-sp \
acing:normal;font-style:normal;font-variant:normal;font-weight:normal;word-spacing:0px;white-space:normal;border-collapse:separate"><span \
style="text-indent:0px">If I emailed you this communication by mistake, please don’t \
read it. Oops! Did you already read it? That is OK, but please do not send it to
anyone else. Seriously, it may be confidential. Any dissemination,
distribution, or copying of this communication, or any of its contents,
is really, really prohibited. Let’s avoid trouble. If you have received
this communication in error, please send it back to me and delete the
original message and any copy of it from your computer, smart phone,
tablet or any other cool device you might use. Thanks. You are the \
best!</span></span></font><br></div></div> <br><br><div class="gmail_quote">On Mon, \
Feb 4, 2013 at 1:07 PM, William Back <span dir="ltr"><<a \
href="mailto:wback@pentaho.com" target="_blank">wback@pentaho.com</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex">
<div style="font-size:14px;font-family:Calibri,sans-serif;word-wrap:break-word"><div><div><div>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.</div>
<div><br></div><div><div \
style="font-family:Helvetica;font-size:medium;word-wrap:break-word">Bill<br><br>--<br><br></div></div></div></div><div><br></div><span><div \
style="border-right:medium \
none;padding-right:0in;padding-left:0in;padding-top:3pt;text-align:left;font-size:11pt;border-bottom:medium \
none;font-family:Calibri;border-top:#b5c4df 1pt \
solid;padding-bottom:0in;border-left:medium none">
<span style="font-weight:bold">From: </span> Nizar Mabroukeh <<a \
href="mailto:nmabroukeh@crosscommercemedia.com" \
target="_blank">nmabroukeh@crosscommercemedia.com</a>><br><span \
style="font-weight:bold">Reply-To: </span> Mondrian developer mailing list <<a \
href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
<span style="font-weight:bold">Date: </span> Monday, February 4, 2013 12:26 \
PM<br><span style="font-weight:bold">To: </span> Mondrian developer mailing list \
<<a href="mailto:mondrian@pentaho.org" \
target="_blank">mondrian@pentaho.org</a>><br>
<span style="font-weight:bold">Subject: </span> [Mondrian] SQL WHERE \
clause<br></div><div><br></div><div><div><div dir="ltr"><div>Can someone please \
direct me to the appropriate mondrian class that enables to generate WHERE clause in \
SQL statements?<br>
</div>
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. \
<div><div><br><br></div><div>Best regards and thank you in \
advance<br><br><br></div><div>Nizar \
Mabroukeh<br></div></div></div></div></div></span></div> \
<br>_______________________________________________<br> Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" \
target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br> \
<br></blockquote></div><br></div>
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic