Skip to Content

Portal SP9: Portal Activity Report

The following is one in a series of weblogs on new features in SAP Enterprise Portal 6.0 SP9.

The portal now lets you quickly and easily generate reports on activity in the portal, either reports on how many users were logged on to the portal or reports on the most popular pages and iViews.

The portal includes an out-of-the-box iView template, called the Portal Activity Report iView, that you can add to any page or workset. You can then configure the iView (during design time) to display the exact information that you want.

The following shows the default Template Selection page for SP9, which is displayed after you specify that you want to create an iView:


After creating the iView, you open the following editor in order to configure the iView and display only the information you want:


You can configure the following settings:

  • The time period to report on (a fixed time frame)
  • The time interval (that is, whether to show how many users were logged on during each hour or each day or each week within the selected time period of the report)
  • The type of report (that is, what information to display), either: (1) The number of users who logged on for a specific period; (2) The number of hits that were recorded for specific iViews and pages.

For reports that show you the number of hits for iViews and pages, you select the iViews and pages to be included in the report. This tyoe of report shows you only the total number of hits during the time period for the report, and does not break it down for each interval.

The following is an example of a portal activity report (this one shows the number of users who logged on during the selected period):


You can set up a variety of portal activity reports, each one for a different period of time or a different group of pages and iViews.

A setting in the portal activity service lets you indicate to the portal not to collect data on certain iViews and pages. For example, by default, no data is collected for the built-in navigation iViews.

In order to make the whole thing work, you must set up the portal mechanism for collecting the data to report. This mechanism has two parts:

  • Data Collection Service: This service gathers raw data from the Portal Runtime (PRT) about processed pages, iViews, and the activities of logged on users.
  • Aggregator Application: A stand-alone application that synchronizes and combines the collected data from all the nodes in the cluster.

This setup work is quick and easy (setting up the Data Collection Service may involve only changing a service parameter in the portal to true).

For more information on setting up Portal Activity Reports, see Portal Activity Report in the NetWeaver Administration Guide for the portal.

FUTURE PLANS: The capabilities of the Portal Activity Report are being expanded to include a report that shows which users logged on and how often. Additional settings enable you to see only the most active users, or only those users in a specified group.

Previous articles in this series:

You must be Logged on to comment or reply to a post.
  • Hello there,
    Any one know how to run that tool automaticly, Without starting the batch file each time, and without entering the password for the DB user?
    Maybe I can deploy that tool into the J2EE as a service?

    Natti Nachmias
    ATAL - Basis Team.

    • Hi Natti,
      Unfortunately, this option will only be available in SP13.
      Currently there is no way to run the tool automatically, nor deploy it as a J2EE service.
      • Hey Or,
        I have 2 more questions that you might know the answer (evey body else is welcome to answer too).
        1. Somehow when I'm trying to make the report per day/month/quoter its i'm getting only zeros,
        just when usong hourly report I get the real data. What can cause this problem?

        2. When changing the report configuration I cant see it on the preview for few min (looks like cache problem), I change all the iview parameters about client side caching, but it didnt helped... any idea?


  • Hi I have a question(everybody),  I have had the aggregator app running for a few days. I have also checked the data in the DB tables WCR_USERSTAT and the others. They all seem to have data.
    When I run the user activity report i only get data with the option hourly setting.
    I have also noticed that the data in the DB has 'h' as the aggregation level. I suspect that this might be the reason why the select statement of the reporting iview is only getting data for hourly setting.

    If there is a setting that i have missed please let me know.

    Kind regards

  • Hi,

    Great blog which helped me a lot to quickly understand the Reporting abilities.

    Is there an ability to have reporting on Group basis?
    eg: iView/page X is visited Y times by users of Group X
    Ideally with a drill down to see the number of times content is visited per user.

    This should help us in defining if the content in the Portal intended for a certain Group is also used by that group.

    thanks for any help,


    • Hi Geert,

      Thanks for the note.

      The portal activity report has been significantly enhanced in SP15 -- including the ability to filter based on group. Still, you'd have to check out if the tool fits the exact use case you describe. The group filter is more for seeing what users logged in, as opposed what content was seen.


  • Hi Daniel,

    we tried to follow your post but on SP16 we have the probled described in /thread/119332 [original link is broken]

    there is some solution

    thanks in advance

    Matteo Papetti

      • Hi Parshu,

        In SP11, you had to install the aggreagtion aopplication and, I think, specify true for the data collection service.

        If these weren't done, then you would have no data.

        In addition, aggregation only occurs following the first interval of the reporting period, so even though there may be data collected, it may not have been aggregated yet -- and only aggregated data is displayed.


    • Hi Matteo,

      Sorry for the delay in responding. I do not know the cause, but I have sent the question to development to see if there is an answer.

      Be back as soon as I can.


  • Hi. Very usefull.

    I created the report and configured the collector data service. Everything is working fine, but I have a concern on the date/time format of the result for the Page/iView activity. It's is shown as timestamp and not as an mm/dd/yyyy type of format. Coould you please give any idea?

  • Thank you very much. This blog serves me a lot.

    I've created an Portal Activity Report iview. It works fine, but when I request a monthly report  of 2007 portal accesses, for March row it only shows me the accesses number of the month first day.

    Any idea? Thank you again.


    • Hi Alejandro,

      Its tough to diagnose, but I will try with some questions:

      * What are the exact settings you use for the iView?
      * Where are you located?
      * Are you in a clustered environment? If so, where are all the nodes located?
      * What version are you running?
      * You get bad data for March, but all other months (Jan, Feb, April, May) are OK?

      Please check out my latest blog for a SAP Note that provides a lot fo technical info on issues with the portal activity report?


    • Hi Alejandro,

      It's tough to diagnose, but I'll try:

      * What are the exact settings for your iView? Type of Report and Reporting Period?
      * What version are you using?
      * Is the data for all the other months (Jan, Feb, Apr, May) OK?
      * Where are you located?
      * Are you in a clustered environment? If so, where are all the nodes located?


    • Hi Alejandro,

      It's tough to diagnose, but I'll try:

      * What are the exact settings for your iView? Type of Report and Reporting Period?
      * What version are you using?
      * Is the data for all the other months (Jan, Feb, Apr, May) OK?
      * Where are you located?
      * Are you in a clustered environment? If so, where are all the nodes located?


  • Hi,

    I have created a three different Daily Portal Activity report iview for Page/Iview activity for set of different pages.
    I have set the reporting period as Fixed period from 1 Apr 07 to 31 Dec 08.
    The report was running fine until 24 june and all the three reports stopped after that.
    It is not generating the report anymore. Is there any configuration missing.

    The portal is running on clustered environment with the version of SAPNetweaver 2004s SP10.

    Advance thanks for your help and time.

    Sreedhar G

    • Hi Sreedhar,

      In a clustered environment, there is an issue with "DuplicateKeyException" -- please see note 1054145.

      Also, just to make sure that this is an aggregation issue, I would check the WCR_WEBCNODESTAT table - this is the content raw table, and should contain values only for a duration of 5 minutes ( "XX:55" until "XX(+1):00" ). For any other time it should be empty.

      If all this still doesn't help, feel free to open a CSN.


  • Hi,

    Could you please advise on data consistency collected through Portal activity report in SP21, EP6. Also can you please advise on how to create report through activity data collector(a new feature added in SP21).

    Thank You.

    • Unfortuantely, I am no longer with the group that develops the portal, so for definitive answers, you will have to go elsewhere.

      I am not sure what you mean by "data consistency"?

      As for the Activity Data Collector: The idea behind this is to give more detailed information and to allow you to completely customize your reports. You configure a service by telling it what pieces of data you want to receive -- you do this by editing a string and putting in the codes of the data that you want.

      Once configured, the services basically creates text files, where each line in the file represents a single request and has all the information you requested for each request -- e.g., time of day, user, time it took to handle request, PCD address of the requested page or iView.

      From there, it is up to you to display this information, perhaps in excel, perhaps by parsing the data and uploading to a database.

      I hope this helped.