[Solved]changing the source of a table in FM

[BIsrik]

Hi,

During the early stage of modelling all the tables were in from one schema. Now few tables have moved to some other schema. Can we point the source of the tables to point the new schema without importing the tables again. I tried modify the sql but it didn't work. Any help...

Srik

[sir_jeroen]

There's a document on this topic on the latest SupportLink online on Cognos.com

[BIsrik]

went through the FM user guide but couldn't find any thing like that. Even couldn't find my question in the support.

when reading FM guide he describes on how to move to from development to production. In that case there is a change in source to all the tables. But in for my case...there are two schema now in the same connection. And moreover only few tables are moved to the new schema and not all tables..

Could u plz tell me which is the document in support while i will still continue to search there.

Srik

[sir_jeroen]

http://support.cognos.com/supported/supportlink/15n4/hottip01.xml

[BIsrik]

fine i had read this before. But this comes in handy when i am moving from dev to prodn. But in my case few tables were moved to some other schema and the rest remained in the old schema. Both the schema wherein the same connection.

I have now solved it by changing the from clause of the sql. I didn't do that properly before. Well thanks a lot for the support.

Srik