Database qualifiers in iqd

[Guest_imported]

I have a cube with several .iqds and a couple of them utilise a different catalogue from the others and when I try to build the cube, the user I am using to attach to the database (Oracle) cannot access some of the tables so I am getting errors. The tables are in the same database but different schemas. The only way I can find to vercome the prob;em is to manually amend the .iqds to add the qualifier in front of the database names. This is obviously not the long-term answer so I was wondering if there is a way of setting Impromtu to do this for me??

 

[n30er]

The Qualify More/Less option should help you out. If you can't get any more info than you need Oracle synonymns(?) can be used to help you out, I believe.