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