COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: Jaspire on 13 May 2008 09:24:28 AM

Title: Deleted a datasource and tried to insert again, but
Post by: Jaspire on 13 May 2008 09:24:28 AM
Hi,
When creating a cube, I inserted a datasource in transformer. But I deleted the datasource for some reason and then again, when I tried to insert the same datasource again, it says that there is already a datasource existing with that name.
Transformer doesn't delete a dtasource completely if I delete from the datasources? Do I need to delete it in any other place also?
Thanks,
Jaspire
Title: Re: Deleted a datasource and tried to insert again, but
Post by: almeids on 13 May 2008 10:06:50 AM
No, it should delete completely...
Try closing the model after you delete and reopening it before adding the data source again.
If you are working with a binary version of the model (.py?) try saving as .mdl and then reopening.
FWIW I recommend always working with .mdl, I've seen no compelling argument for working with the binary format.  Aside from avoiding issues with corruption and model growth, you can also see what's going on with any text editor when you need to.

Title: Re: Deleted a datasource and tried to insert again, but
Post by: Jaspire on 13 May 2008 12:22:54 PM

Thank you.
I didn't think that we can see .mdl file in text editor. Its interesting to know.