Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: techieaman on 13 May 2010 03:45:24 AM

Title: Building model from 2 schemas of a single database
Post by: techieaman on 13 May 2010 03:45:24 AM
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
Title: Re: Building model from 2 schemas of a single database
Post by: MFGF on 13 May 2010 04:56:33 AM
What is the problem?  This should be very straightforward.  Are you getting errors of some sort?

Regards,

MF.
Title: Re: Building model from 2 schemas of a single database
Post by: tupac_rd on 13 May 2010 08:40:17 AM
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
Text only | Text with Images