PPES Audit Info

[JGirl]

Hi,

Has anyone out there done anything neat with the PPES audit logs? I'm looking at building an audit cube from the data and I'd heard that Cognos were looking at providing some sort of utility to process the data, but I dont know too much about it.

Can anyone bring me up to date?

J

 

[DoubleD]

I believe there is a company called Envision that does this already. A bunch of former Cognos consultants who got together and wrote a bunch of code for reporting against Cognos.

If you want to start from scratch, look through the documentation on PPES auditing. You'll have to grab the text file that gets generated and parse it out to be at all meaningful.

Pain is stress leaving the body.

DoubleD

 

[flex13]

You casn bring in the file to Excel and save it as an XLS. From there, create an ODBC connection with Impromptu to read the XLS file. Create an IQd and then build your cube.

Or use the other product as mentioned above.

 

[JGirl]

Thanks for the replies guys. I've already got the audit file and loaded it into an access table which I can report from, but its a bit weird looking at the moment (ie, the data doesnt mean a lot to me and I dont want to jump to any assumptions).

What I'd heard was that Cognos had a utility that processed the audit file into a DB, but I guess its not out yet......Maybe in a newer version of PPES......

Cheers
J

 

[flex13]

There was an application called the audit processor that was written by a Cognos consultant. The utility should be downloadable from the Support web site.

 

[christenhusz]

That's right,

It reads the ppesaudit.log file and convert it to csv and us it as a datasource for transformer, to create a cube. Very neat. note: You must enable detailed logging in the PPES and it works best with secured cubes if you are interested with USER accesed a cube or report.

cheers.