Is it possible to create one query subject from two different data sources

[inu]

HI
I created two data sources viz; SH, HR. Imported tables from both the data sources. After i created database layer and created relationship between query subjects individually.
Then i created one namespace and named it presentation layer. when i try to create a query subject and take the query items from both the data sources, it creates error and indicates the broken link.
Is there any solution for accomplishing this issue.


thanks
Inam

[linbai]

if error:  RQP-DEF-0103 Cross joins are not permitted.Enable cross joins in the model
try this:
1. Open the model in Framework Manager.
2. Click the "Project" menu, and then "Edit Governors..."
3. Set "Cross-Product joins" to "Allow."
4. Publish the package.

[MFGF]

HI
I created two data sources viz; SH, HR. Imported tables from both the data sources. After i created database layer and created relationship between query subjects individually.
Then i created one namespace and named it presentation layer. when i try to create a query subject and take the query items from both the data sources, it creates error and indicates the broken link.
Is there any solution for accomplishing this issue.


thanks
Inam

Oh dear. You forgot to give us any detail about what the error message says.

MF.

[inu]

HI MFGF,
sorry i didn't mention the error, but  yes,  the error libnai has posted, the same i m getting.
See i have imported Sales and Customer table from SH datasources, and Department and Employees from HR datasource.
I given the joins between sales and customer, and second join between department and employees individually.
Now in Presentation Layer, if i drag items from customer and department and make it as single Query subject, then it throws error as cross join.

Dont laugh, if it is silly, but i want to make clear myself. that what should i do in this case.
In addition to this , i want to know that , when i need to import tables from different data source.

I m sharing the relevant screen shots.
Please elaborate it sir


Thanks Inam

[bdbits]

Use the steps linbai gave to eliminate the error.

Bear in mind that spanning multiple data sources like this will probably not be very efficient. Because they are on different data sources, Cognos will join them on the Cognos server. If you have large tables, this can be somewhat intensive. If possible, it would be better to import all of the tables to a separate data warehouse database and point your package to that.