Transformer - Build Cube from multiple DBs

[spicysudhi]

Hi

we got four databases holding the order details (each represents one country). The order table structure is same in all.

Looking for a cube that consolidates all the four databases. If I write four separate IQDs, from which IQD I should select the measure. Or is there any other alternate methods to achive this.
thanks in advance,
best regards,
sudhi

 

[GJParker]

Sudhi

As long as the measures names are the same in each IQD it doesn't matter.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[drlex]

And if the databases are identical, all you need do is duplicate the iqd and change the DATABASE value in Notepad to match the ODBC setting for each DB.

soi la, soi carre