List of Contributions

Tony Barlas

Contact Details

My Content

1 to 11 of 11 total

RE: Cognos Audit database pruning records

Posted By Tony Barlas Mon April 12, 2021 12:46 PM
Found In Egroup: Cognos Analytics \ view thread
You ever try to get stuff from IBM's diagtool? Not terribly helpful. ------------------------------ Tony Barlas ------------------------------

RE: Cognos Audit database pruning records

Posted By Tony Barlas Wed April 07, 2021 11:15 AM
Found In Egroup: Cognos Analytics \ view thread
No problem. I'm surprised that it not more information about pruning records from the audit db is available out in the wild. This scripts was designed using Cognos 11.1.7. ------------------------------ Tony Barlas ------------------------------

Cognos Audit database pruning records

Posted By Tony Barlas Wed April 07, 2021 10:45 AM
Found In Egroup: Cognos Analytics \ view thread
We are planning on holding only 2 years of history in your audit db. I haven't found much help online about pruning records in the audit database. I come up with this, but was curious what other do. SQL Statement: delete FROM COGIPF_ACTION where COGIPF_LOCALTIMESTAMP < DateAdd(yy, -2, GetDate()) ...

IBM Cognos c11AuditExtension

Posted By Tony Barlas Wed June 10, 2020 10:55 AM
Found In Egroup: Cognos Analytics \ view thread
Anybody using the Audit Extension working? https://developer.ibm.com/tutorials/ibm-cognos-11-audit-extension/ I'm trying to use Database type: Microsoft SQL Server (integrated security) and I keep getting error: Error: ERROR - Unable to connect to database - check the settings are correct. ...

IBM Cognos c11AuditExtension

Posted By Tony Barlas Wed June 10, 2020 10:54 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

RE: Cognos Audit Database Missing Report Run Data

Posted By Tony Barlas Fri February 28, 2020 08:45 AM
Found In Egroup: Cognos Analytics \ view thread
Make sure 'Enable TCP' is set to TRUE in logging. By default is set to False which mean it's using UDP. ------------------------------ Tony Barlas ------------------------------

RE: Updating the CSS and UI of Radio Buttons / Checkboxes in CA 11.0 and above

Posted By Tony Barlas Fri December 13, 2019 08:51 AM
Found In Egroup: Cognos Analytics \ view thread
Check out cognospaul. http://cognospaul.com/2015/02/10/styling-checkbox-radio-prompts/ I believe it was done in 10, but should still apply to 11. ------------------------------ Tony Barlas ------------------------------

RE: Cognos 11.1.2 Load Balancing

Posted By Tony Barlas Thu November 14, 2019 11:13 AM
Found In Egroup: Cognos Analytics \ view thread
I would have A and B at 2.0 or 3.0 and leave C at 1.0 ------------------------------ Tony Barlas ------------------------------

Table(s) used for storing "run history" for imports/exports from the admin console

Posted By Tony Barlas Thu November 07, 2019 09:24 AM
Found In Egroup: Cognos Analytics \ view thread
Looking for the table(s) in the databases (cs or audit) that stores the history when a export/import is successful or not. ------------------------------ Tony Barlas ------------------------------ #CognosAnalyticswithWatson

Table(s) used for storing "run history" for imports/exports from the admin console

Posted By Tony Barlas Thu November 07, 2019 09:23 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

RE: Save Cognos output file into Sharepoint URL directly

Posted By Tony Barlas Tue November 05, 2019 10:34 AM
Found In Egroup: Cognos Analytics \ view thread
You could use something like this. http://xploreplus.com/portfolio/corepublisher/ or build your own powershell to copy it into sharepoint. ------------------------------ Tony Barlas ------------------------------