[Mondrian] Mondrian OLAP connection problem

[prakash tiwary]

Hi,
 Greetings for the day!
  I am very new to Mondrian.  I am having  following problem
  Can mondrian underlying DB swtich from one schema to another, given a
single instance of DB.

Details:
    DB URL= localhost:3306
    Suppose i want to use tables from two different schema? How can i do it?
    A and B are two schemas. A contains TableA & B Contains TableB.
    MDX query will need informations of TableA as well as TableB.

  In order to get Result we use following two lines of code:

mondrian.olap.Query query = connection.parseQuery(queryString);

  Result result = connection.execute(query);


connection is Connection to OLAP server , suppose it is related
to  localhost:3306/A

How will i parse a query which is related to schema B with this connection?

It may be becoz, i am confused with OLAP connection & connecting two schema
of a DB.
Kindly help me.

Thanks & Regards
Prakash
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20061220/7ab99b34/attachment.html