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

Audit Log / Duplicate Time Stamps

Started by jasp, 23 Nov 2011 04:33:29 PM

Previous topic - Next topic

jasp

Hi Guys,

any advice would be greatly appreciated

I am trying to count how many times specific reports are run by users , using the audit package - heres my issue

i have a list report with the following

USER    REPORT NAME   COUNT OF TIMESTAMP

When the user runs a report in the database i am getting 3 records for everytime a user runs a report so 3 timestamp entries so then i used  COUNT([Timestamp]) / 3 to convert the three entries back to one, however what i noticed in the database was some entries had only one timestamp for particular reports so using this formula had me dividing one entry by three, what i realised was these reports were run of a scheduler and all the other reports were run from the cognos connection hence resulting in three entries.

Does anyone know what the code would be for dividing the count stamp by 3 or 1 depending on how may rows are in the database for the report and the timestamp relating to the report.

i tried used the following.....

total(count(distinct [Report name] for [Time stamp] ))

however this gave me the total number of timestamps...any ideas