Building model from 2 schemas of a single database

[techieaman]

Hi All,

Can anyone shed some light on the possibility of using 2 schemas from the same database for FM MODEL creation?

database is oracle and the 2 schemas in question have views/tables needed for the model.

Thanks in advance for your inputs

regards,

aman

[MFGF]

What is the problem?  This should be very straightforward.  Are you getting errors of some sort?

Regards,

MF.

[tupac_rd]

You definitely can include tables/views from 2 different schemas in FM. Only in FM you will see 2 instances of the same datasource, for eg. if your initial datasource for a database was named DS, and you pull a new table from a different schema using the same datasource, only in FM you will see a datasource called DS1, and so on as you keep adding tables from different schemas. So, the SQL only in FM for these database querysubjects would show up as select * from [DS].table1 or select * from [DS1].table2 etc.,.....

HTH
2pac