1/13
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's New in This Guide
Part I Tutorial for Creating Analytics Reports with Custom Parameters
1
About Creating Reports for Analytics
1.1
About This Tutorial
1.2
The 'NewBrowsers' Report
1.3
Prerequisites for Creating Reports with Custom Parameters
1.4
Quick Reference
2
Exercise 1: Adding a New Parameter for Data Capture
2.1
Overview
2.2
Adding the New Parameter to the Image Tag and Its JSP
2.3
Next Steps
3
Exercise 2: Adding a New Parameter to the DetailDefinition Table
3.1
Overview
3.2
Create a Database Entry for a Custom Parameter
3.3
Next Steps
4
Exercise 3: Developing a New Analytics Job
4.1
Overview for Creating an Analytics Job
4.1.1
Example for Developing a New Analytics Job
4.1.1.1
Designing the 'NewBrowsers' Report
4.1.2
Developing an Analytics Job for the 'New Browsers' Report
4.1.2.1
Step 1: Select the Input Location
4.1.2.2
Step 2: Extend the Schema
4.1.2.3
Step 3: Create the Beans
4.1.2.4
Step 4: Create the Mapper Classes
4.1.2.5
Step 5: Adding Beans and Mappers to the Processor Definitions
4.1.3
Configuring Database Injection
4.1.4
Integrating the New Analytics Job with the Existing Hadoop-Jobs Component
4.2
Next Steps
5
Exercise 4: Creating and Preparing a Report for Viewing
5.1
Report Design
5.1.1
'NewBrowsers' Report Code
5.2
Creating and Preparing the 'NewBrowsers' Report for Viewing
5.2.1
Creating and Registering the Report File
5.2.1.1
Step 1: Create the XML File
5.2.1.2
Step 2: Place the XML File in the Analytics Reports Directory
5.2.1.3
Step 3: Label the Report Components
5.2.1.4
Step 4: Make the Report Available to Analytics Users
5.2.1.5
Step 5: Test the New Report
5.2.2
Adding a Table
5.2.3
Adding a Time Period Selector
5.3
Adding a Filter
5.3.1
What Does a Filter Do?
5.3.2
How Do I Add a Filter?
5.3.3
Adding a Chart
5.3.4
Testing the Completed 'NewBrowsers' Report
Part II Reference
6
Enabling Data Capture for Different Types of Reports
6.1
Enabling Data Capture
6.1.1
Enabling Data Capture for General, Content, and User Information Reports
6.1.2
Enabling Data Capture for the "Internal Searches" Report
6.1.3
Enabling Data Capture for Engage Reports
6.2
Testing Your Analytics Installation
7
WebCenter Sites: Analytics Database Schema
7.1
L3 Tables
7.1.1
CS_L3DATEXSITEXOBJXCOUNT
7.1.2
L3_DATEXSITEXCITYXCOUNT
7.1.3
L3_WEEKXSITEXCITYXCOUNT
7.1.4
L3_MONTHXSITEXCITYXCOUNT
7.1.5
L3_DATEXSITEXDLXMIMEXCOUNT
7.1.6
L3_DATEXSITEXGROUPXOICOUNT
7.1.7
L3_DATEXSITEXGROUPXSESCOUNT
7.1.8
L3_DATEXSITEXGROUPXVISCOUNT
7.1.9
L3_WEEKXSITEXGROUPXVISCOUNT
7.1.10
L3_MONTHXSITEXGROUPXVISCOUNT
7.1.11
L3_DATEXSITEXREGIONXCOUNT
7.1.12
L3_WEEKXSITEXREGIONXCOUNT
7.1.13
L3_MONTHXSITEXREGIONXCOUNT
7.1.14
L3_DATEXSITEXJS
7.1.15
L3_DATEXSITEXOBJECTXDURATION
7.1.16
L3_DATEXSITEXBROWSERXCOUNT
7.1.17
L3_DATEXSITEXCOUNTRYXCOUNT
7.1.18
L3_WEEKXSITEXCOUNTRYXCOUNT
7.1.19
L3_MONTHXSITEXCOUNTRYXCOUNT
7.1.20
L3_DATEXSITEXENTRYIDXCOUNT
7.1.21
L3_DATEXSITEXEXITIDXCOUNT
7.1.22
L3_DATEXSITEXHOSTNAMEXCOUNT
7.1.23
L3_DATEXSITEXINTERNALSEARCH
7.1.24
L3_DATEXSITEXIPXCOUNT
7.1.25
L3_DATEXSITEXISPXCOUNT
7.1.26
L3_WEEKXSITEXISPXCOUNT
7.1.27
L3_MONTHXSITEXISPXCOUNT
7.1.28
L3_DATEXSITEXOBJECTTYPEXCOUNT
7.1.29
L3_DATEXSITEXOBJECTXCOUNT
7.1.30
L3_AUDIT_TRAIL
7.1.31
L3_DATEXSITEXOPTYPEXCOUNT
7.1.32
L3_WEEKXSITEXOPTYPEXCOUNT
7.1.33
L3_MONTHXSITEXOPTYPEXCOUNT
7.1.34
L3_DATEXSITEXOSXCOUNT
7.1.35
L3_DATEXSITEXREFERERXCOUNT
7.1.36
L3_DATEXSITEXSCREENRESXCOUNT
7.1.37
L3_DATEXSITEXSESSION
7.1.38
L3_DATEXSITEXSESSIONXQUANTIL
7.1.39
L3_DATEXSITEXSEXKEYWORDXCOUNT
7.1.40
L3_DATEXSITEXVISITORXCOUNT
7.1.41
L3_WEEKXSITEXVISITORXCOUNT
7.1.42
L3_MONTHXSITEXVISITORXCOUNT
7.1.43
REC_L3_RECXCOUNT
7.1.44
REC_L3_RECXSEGXCOUNT
7.1.45
REC_L3_RECXSEGXOBJXCOUNT
7.2
HELP Tables
7.2.1
HELP_CITY
7.2.2
HELP_REGION
7.2.3
HELP_COUNTRY
7.2.4
HELP_DATES
7.2.5
HELP_HOURS
7.2.6
HELP_ISP
7.3
System Configuration and Maintenance Tables
7.3.1
ACCESSRIGHT
7.3.2
BROWSERGROUP
7.3.3
BROWSERIDENTIFICATION
7.3.4
IP2COUNTRYCITY_BLOCKS
7.3.5
IP2ISP_BLOCKS
7.3.6
IPQUICKLIST
7.3.7
ESAUSER
7.3.8
IP2COUNTRY
7.3.9
OBJECTTYPEGROUP
7.3.10
SETTING
7.3.11
OSGROUP
7.3.12
OSIDENTIFICATION
7.3.13
REC_RECOMMENDATION
7.3.14
REC_SEGMENT
7.3.15
REPORT
7.3.16
REPORT2REPORTGROUP
7.3.17
REPORTGROUP
7.3.18
REPORTPARAMETER
7.3.19
SEARCHENGINEGROUP
7.3.20
SEARCHENGINEIDENT
7.3.21
SITE
7.3.22
SITE2OBJECTTYPEGROUP
7.3.23
SITEGROUP
7.3.24
PI_SITEXOBJECTTYPE
7.3.25
USER2USERGROUP
7.3.26
USERGROUP
7.3.27
L2_BROWSER
7.3.28
L2_GROUP
7.3.29
L2_OBJECT
7.3.30
L2_OBJECTNAMEHISTORY
7.3.31
L2_OBJECTTYPE
7.3.32
L2_OS
7.3.33
L2_PIOBJECTTYPE
7.3.34
L2_SEARCHENGINE
7.3.35
L2_VISITOR
7.3.36
TASKSTATUSHISTORY
7.3.37
HDFSAGENTSTATUSHISTORY
7.3.38
DETAILDEFINITION
7.4
Database Indexes
Scripting on this page enhances content navigation, but does not change the content in any way.