Framework Manager

Newbie to Framework Manager,

I currently have a report that is using 2005 SQL database/datasource connection and I have migrated some of the tables to Oracle except for maybe two in this one report. I was asked if I could create a view in framework manager to point this report to so that it would stay on SQL2005 until the rest of the tables has been moved over to Oracle. Is there anyone that could provide step-by-step instructions on how this can be done in framework manage. Would have to make a view of this table and point it back to SQL2005 and leave the current table pointed to Oracle.

This was originally in SQL 2005 and I migrated it Oracle. But now there is one column that I’m having an issue with and the DBA suggested that I create a view or alias to put this one report back to the SQL 2005 tables and leave the currently table mapped to Oracle. This way I can update Framework Manager with the Oracle updates. Does this make sense?

We are using Cognos 10.2.1, and SQL 2005. Please let me know if I need to provide additional information on this request.