<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>