Portal activity Report problem

49 Views

Hi,

Based on following link, I am trying to build a custom web Dynpro Application.

"http://help.sap.com/saphelp_nw04/helpdata/en/48/6aa9429b930b31e10000000a1550b0/frameset.htm"

I am using WCR_WEBCONTENTSTAT and WCR_USERFIRSTLOGON database tables to get information about which users viewed which pages or iViews.

I also tried to use SAP out of box iview. When I execute this iView for certain fixed period. Its giving me valid results. But when I am executing my custom application for same fixed period, it showing less no of records. I am using following query to fetch records for Hourly time interval .

select

WCR_WEBContentstat.CUSTOM,

WCR_WEBContentstat.IMPRESSIONS,

WCR_USERPAGEUSAGE.LOGONID

from WCR_WEBContentstat , WCR_USERPAGEUSAGE

where WCR_USERPAGEUSAGE.Hourly_ID = WCR_WEBContentstat.ID

Similarly I am chaining where condition as "where WCR_USERPAGEUSAGE.Daily_ID = WCR_WEBContentstat.ID"

to get Daily data .

As data is populated in SAP's portal activity report correctly. Portal Activity configuration setting are fine.

Can you please help me to resolve this Issue. Thanks in Advance.

Thanks & Regards,

Shrikant Kamble