Copy and attached queries to new ODS
I was changing the technical name of my ODS by deleting it first and then recreating it, instead of making a copy and then deleting. I think it also asked whether I wanted to exclude the deletion of its queries and I think I said to exclude from deletion, but now I can't seem to recover the queries to attached to the new ODS. The queries are shown in the History and Favorites. Is there a way to copy the queries shown from the History and Favorites to the newly created ODS? It seems that I have to create it again for the new ODS.
try to create again the old ODS, copy from new ODS,
then try if you can use RSZC to copy query between that 2 ODS (from old ods to new ods).
hope this helps.