<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=264132619-20122006><FONT face=Verdana
color=#000080 size=2>You can qualify a table with a schema
name:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=264132619-20122006><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=264132619-20122006><FONT
face="Courier New"><</FONT><A
href="file:///e:/open/mondrian/doc/schema.html#XML_Table"><FONT
face="Courier New">Table</FONT></A><FONT face="Courier New"> schema="foodmart"
name="sales_fact_1997"/></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=264132619-20122006><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=264132619-20122006><FONT face=Verdana
color=#000080 size=2>Also, </FONT></SPAN><SPAN class=264132619-20122006><FONT
face=Verdana color=#000080 size=2>I know that Oracle supports synonyms which
cross schemas. So you can log into schema A, and if you need to reference a
table in schema B, create a synonym in schema A referencing that table. Other
databases have similar features.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=264132619-20122006><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=264132619-20122006><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>prakash
tiwary<BR><B>Sent:</B> Wednesday, December 20, 2006 5:54 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Mondrian OLAP connection
problem<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV> </DIV>
<DIV>Hi, </DIV>
<DIV> Greetings for the day!</DIV>
<DIV> I am very new to Mondrian. I am having following
problem</DIV>
<DIV> Can mondrian underlying DB swtich from one schema to another,
given a single instance of DB.</DIV>
<DIV> </DIV>
<DIV>Details:</DIV>
<DIV> DB URL= localhost:3306</DIV>
<DIV> Suppose i want to use tables from two different
schema? How can i do it?</DIV>
<DIV> A and B are two schemas. A contains TableA & B
Contains TableB.</DIV>
<DIV> MDX query will need informations of TableA as well as
TableB.</DIV>
<DIV> </DIV>
<DIV> In order to get Result we use following two lines of code:</DIV>
<DIV> </DIV>
<DIV>mondrian.olap.Query query =
connection.parseQuery(queryString);<BR> <BR> Result
result = connection.execute(query);</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>connection is Connection to OLAP server , suppose it is related
to localhost:3306/A</DIV>
<DIV> </DIV>
<DIV>How will i parse a query which is related to schema B with this
connection?</DIV>
<DIV> </DIV>
<DIV>It may be becoz, i am confused with OLAP connection & connecting two
schema of a DB.</DIV>
<DIV>Kindly help me.</DIV>
<DIV> </DIV>
<DIV>Thanks & Regards</DIV>
<DIV>Prakash</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>