If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Howto - truncating content of IM_ tables after the GTP

Started by jan.herout, 15 Jun 2009 02:49:19 AM

Previous topic - Next topic

jan.herout

Have a nice day,

seems to me that Contributor does NOT delete content of IM_* tables (that are filled by Admin link) after the prepare import & GTP is run. Does that mean that I have to delete content of those tables manually via CAC after each GTP cycle, or face the fact that with each initialization at the beginning of month number of records in IM_ tables will grow?

Can truncating of IM tables content be automated using CTB macros somehow?

Please advice...

jan.herout

One more comment - this applies to Oracle in "locked down" environment. Perhaps it is relevant.

jan.herout

Sorry to bother you, PROBLEM SOLVED.

a) when importing new set of data, there is a option on level of admin link element "delete existing data" that does the job
b) after the GTP, data should be deleted by "import queue tidy" job
    (however, in my environment this job is not run, which is strange)

Best regards,

-J