Document Access Report

[Former Member]

I have implemented the below KM report in my local 2004s SP9 portal. I am able to get the report to run but it does not show the number of times each document has been accessed nor does it show who access the document. Is there a service that I need to enable to get this information ? I am not running TREX.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7d28a67b-0c01-0010-8d9a-d7e...

[detlev_beutner · Accepted solution]

Hi David,

you have to activate the RepositoryService (AccessDataCollectorService) coming along with that example on the repository which you want to control.

Hope it helps

Detlev

[Former Member · Accepted solution]

Hi Detlev -

I think that I've done that. Here are the steps that I took.

First, I went to System Administration -> System Configuration -> Knowledge Management -> Content Management -> Repository Services. I opened the AccessDataCollectorService service and created a new service "DataCollector"

Next, I went to System Administration -> System Configuration -> Knowledge Management -> Content Management -> Repository Managers -> Reporting Repository and changed the "reporting" service so that the repository service "DataCollector" is selected.

Lastly, I restarted the j2ee engine.

Are these the correct steps ?

[Former Member · Accepted solution]

Hi David,

No, that's not correct. The new "AccessDataCollectorService" repository service is needed for collecting the access data on user basis and to store it as application properties in the database. So this thing, which some might think is done by default in KM, is needed on every KM repository where you want to run this report. Hence, you must go to Repository Managers -> CM Repository -> documents (or whatever repository you want to run the report on) and add your new "DataCollector".

Do a restart, access some documents, and tell us if that was successfully.

Hope this helps.

Robert

[Former Member · Accepted solution]

Hi Robert -

Thanks for the feedback. This solved my problem. However, the report is not working correctly. I must run it for all documents ( as opposed to just the ones that have been read ) and the properties unique_count and last_accessed are not being tracked. If you happen to know anything about this report I would appreciate your feedback. In the meantime I'll poke around at the code.

Thanks!

David

[Former Member · Accepted solution]

One small correction. The property "lastaccessed" is working.

[Former Member · Accepted solution]

Hi David,

as mentioned above the delivered repository service creates two new application properties for every document that is accessed for the first time. The name of the properties are: access_count and access_time (property_id).

You can use the <a href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/75336f09-0801-0010-4ea6-90ca92e98b28">RFExplorer</a> to see that the properties are created and updated.

Hope this helps,

Robert

[Former Member · Accepted solution]

Thanks again for the feedback Robert. This will help me gain a better understanding of the repository service.

For those who view this thread later on, I found the following weblog to be very useful in customizing the output of this report => https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4637

[former_member189409 · Accepted solution]

Hi Robert Briese

The Collect only accumulated data in "DataCollector" shoud be set value to yes,no or not set.

Thank you

[Former Member · Accepted solution]

Is it possible show an iview with the documents order by hits???

Thanks in advance,

Regards,