COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: collierd on 04 Feb 2015 10:26:11 AM

Title: Audit Powerplay report usage
Post by: collierd on 04 Feb 2015 10:26:11 AM
Hello

I have been asked to provide figures behind powerplay usage
Individuals create a and save reports
We need to know how many of these reports are actively in use (say from 1st Jan 2015)

Standard Report Studio reports are fairly easy (using Audit log)
Powerplay on the other hand is proving difficult
I'm aware of the logs that are generated but I can't go through loads of pages to get an answer
Is there a simpler way?

It's part of an all round Cognos usage assessment

Thanks

Title: Re: Audit Powerplay report usage
Post by: CognosAnalytics on 04 Feb 2015 02:14:03 PM
Hello collierd,
There are some audit tables created for powerplay usage, in your audit database.

COGIPF_POWERPLAY
COGIPF_POWERPLAY_DIM_USAGE
COGIPF_POWERPLAY_MEASURE_USAGE

Won't these work?

Thanks,
-Cognos810

Title: Re: Audit Powerplay report usage
Post by: collierd on 16 Feb 2015 02:56:36 AM
I think I can work with this, so will have a go at generating a report

Thanks