First of all, you have to create two different Universe if the tables you are are in two different data bases.

you cannot point same universe to multiple data sources. That means that Universe cannot have multiple connection. Only single connection. So you can only bring tables from one database.

You best bet is to create two universes and merge them together in Infoview.

Create two universe, First Gateway and Second Isoft.

1. Create a query containing objects from Gateway. Click on Add query and add objects from Isoft Universe.

2. Run both queries.

3. Click on Merge Dimensions. You will see two diamond shaped icon on the tool bar.

4. You will see objects from Query 1 and Query 2. If you have  isoftfilename on Query one and orginalfilename on Query 2. Click on both of them and click Merge on the Right.

5. Now you should be able to create a report with both those queries. The problem was that you are not linking or merging the common objects from two queries thereore it is not allowing you to report on multiple universes as they are not compatible when not merged.

Now, regarding your error where it says, 'table or view doesn't exist', it seems to me that you have designer access but donot have atleast a read-only access to the database. Make sure that the database you are trying to use, gives you the right to select tables.

hope that helps.