Skip to Content

The Final Word (Hopefully) on the Portal Activity Report

OK, so you can’t get enough of the Portal Activity Report? I’m here satisfy that craving. I wanted to update you on some changes and fixes for the Portal Activity Report (especially for those who complain about not seeing any data in their reports), and then to provide some guidance on what might happen to the feature in the future (as far as i know). Hopefully, this will be my last blog for a while on this feature. Wish me luck.

Changes/Fixes to the Portal Activity Report

SAP has invested a lot of effort in ironing out some of the problems with the activity report, and has published a central SAP Note 998653 that describes all of the problems, fixes and related notes for the activity report in SAP NetWeaver 2004 and 2004s (7.0). The following are some of the highlights of the issues and changes. All changes are expected to be made to 2004 SP Stack 21 and 2004s SP Stack 13.

Aggregation of Data in a Cluster

In a cluster environment, problems can occur because the aggregation application is run repeatedly on each node, even though there is only a need to run it once, as there is only one database. Occasionally, a problem with synchronization can occur that will cause the aggregation application to halt and stop creating data for the reports. Without going into more detail, you should check out SAP Note 1054145.

GMT and Report Interval

When a fixed period is specified for an hourly report, the user specifies a time in GMT (whether he realizes it or not); this is the way the feature is supposed to work (despite objections from some of you). That is, if he selects 2 to 4 p.m. GMT time, that’s what is displayed. But when a user picks a fixed period with an interval of daily, weekly, quarterly or monthly, it doesn’t work this way. The user does not have to pick a start and end time (since it’s not an hourly report), yet the implicit time of midnight to midnight is assumed to be local time, and is adjusted to GMT. So if a user in Germany picks May 1-7 with a daily interval, the first row would show from April 30 at 11 p.m. to May 1 at 11 p.m. The real problem is this: the aggregation of data occurs at midnight, yet the report is looking for data at 11 p.m. So many reports show no data even though data does exist. This problem has been fixed for the next release.

Adjusting Fixed Period for the Interval

Ever wonder what happens when you pick a time period that doesn’t correspond to the report interval? For example, you pick a 9-day period for a weekly report? Or a 43-day period for a monthly report? You get the idea. Up until now, to be honest, I’m not sure it is clear how the report would handle this. But for the next release, the time period is expanded, if necessary, to fit the interval. The start time is moved earlier and the end date is moved later. For example, if you specify a monthly report from May 15 to June 15, the period is automatically adjusted to May 1 to June 30, and the report displays two rows of data. The same is true for weekly and quarterly reports. image

The Future of Activity Reporting

In addition, to improvements in the Portal Activity Report, there is work on two new tools for reporting on activity, which should provide a richer set of data on portal activity, and greater freedom in displaying the data. Among the new types of data collected is performance data, that is, how long an iView takes to display its content. In addition, more information is collected on administrator actions, for example, what administrators changed what content in the PCD, or created or deleted which users. In addition, I believe there will be greater freedom to access the raw data, and to use BI, Excel or whatever tools to display and breakdown the data. I will write about the changes and improvements as soon as I get more concrete information.  

You must be Logged on to comment or reply to a post.
  • We spend a great deal of time creating Excel-based “inventories” of portal document hierarchies. I would like to have the ability to create a report that would “extract” the names of documents from any node of my folder structure. Ideally, it would have the ability to export the results into Excel. That way, we could run a report of available documents on the fly.
    • Hi Mary,

      When you refer to documents are you referring to documents in KM? Also, what kind of reports do you want, just an inventory of documents, or statistics on their usage?

      I think a simple list would be relatively straightforward.


  • Hi Daniel,

    What could be interesting, is having the possibility to also select periods in the “Most Recent Activity” that are months and years.

    So I could have the number of userID logged in per month for last year, or last 6 months.
    This is now not possible, as the system does not accept a monthly report for a “Most Recent Activity” = 52 Weeks.


    • Hi Vincent,

      I have forwarded your comments to the developing of the Portal Activity Report.

      Now we’ll both have to wait and see. If I here anything more, I will let you know.


  • HI Daniel,

    But still in SP21, data genrated through portal activity report is not correct. It is giving wrong data. Can you put some light on this.


    • Can you describe the problems you are having?

      I will be happy to pass along any problems you may have. In addition, I would suggest entering a support ticket.

  • Hi,
    I am unable to open the note #998653 i have tried lot of times .I have a services market place account .also I tried with my normal sdn acoount can you provide me any other link for this note