Reset ODS CCA

[mdewhurstuk@gmail.com]

Hi i am have arrived at a customer site and there production CCA installation is messed up to say the least. I want (without having to re install-reinitialize the DB) to reset the ODS to think its running first time and then create the reports from scratch.

I did it a few years ago by logging into the etl assistant and deleting the ods connecting and adding in a new one but i am not completely sure as it was so long ago. I also cant test it as they have no dev setup.

Does anyone know a easy quick win was to reset ods as to think its running first time ?

Thanks in advance

[Adam G.]

Just drop the DB and recreate it.

Pavel

[JeffreyT]

Is the current environment is still working you can also proceed as follow :
- In DMA deactive ALL layouts (but do not delete them yet)
- In ETL Assistant for each layout set the purge parameters to 0 DAY / 0 DAY (for each one of the 7 levels)
- Stop ETL_Service
- Manually run 1 or 2 ETL_Purge & ETL_Transform
  .. you may have to wait one day to perform this part
- at some point you should be able to drop the Layouts frmo DMA
Hope this helps

A quicker approach is to drop & recreate your ODS & DataMart dabases alltogether (providing the fact that you have carrefully exported your layout templates in XML format)