Based on following link, I am trying to build a custom web Dynpro Application.
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 .
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,