Portal Activity reports inside BI

15 Views

All

I hope i post this question in the whrigt forum.

At first some system information:

BI 7.0 java and abap instance on service pack 13

Enterprise Portal 7.0 with support pack 13.

We already created some activity reports with the iview template SAP provides buth these are not complete for out usage.

We have a new challenge. We want to create activity reports of the portal inside our BI system. So we want to fill cubes with the data collected in the EP and create reports over this data.

I know the portal collects data and stores this data inside the tables: [Link To Help File|http://help.sap.com/saphelp_nw04s/helpdata/en/58/728ea01cf64fff996b827f2a06f9b1/frameset.htm]

WCR_USERSTAT

WCR_WEBCONTENTSTAT

WCR_USERFIRSTLOGON

WCR_USERPAGEUSAGE

The first question is how to import the data from the EP system inside the BI system?

Edited by: J. Beckers on Jul 7, 2008 8:50 AM Added links