Skip Headers
Oracle® Fusion Middleware Developer's Guide for Oracle WebCenter
11g Release 1 (11.1.1.5.0)

Part Number E10148-16
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

I WebCenter Analytics Database Schema

This appendix describes the underlying database design for Oracle WebCenter Analytics. This information is useful to developers building custom analytics data queries, as described in Section 46.3, "Building Analytics Reports.".

This appendix contains the following topics:

I.1 Analytics Database Schema Overview

This section contains the following topics:

I.1.1 Analytics Database Model Overview

The Oracle WebCenter Analytics database schema is modeled as a star-schema to optimize performance and provide fast response times.

Analytics data is stored in fact and dimension fact tables:

  • Analytics Fact Tables are created when the Analytics Collector runs for the first time. Each fact table stores a specific event type, for example, page views, Space views, document uploads, blog views, wiki edits, and so on. Columns in these fact tables mostly contain integer IDs that reference descriptive data stored in dimension tables.

    Table I-1, "Analytics Facts Tables (Prefixed ASFACT_WC)" lists types of analytics events that can be collected and stored, and the associated tables.

  • Analytics Dimension Tables are also created when the Analytics Collector runs for the first time. Dimension tables store redundant descriptive data associated with analytics events. When a value is not found in these tables, a new record is added. Typical analytics dimension data includes: page name, browser name, document name, Space name, and so on.

    Table I-2, "Analytics Dimension Tables (Prefixed ASDIM_WC)" lists the different types of analytics dimensions that can be collected and stored, and the associated table names.

The Oracle WebCenter Analytics database schema also contains a few application tables that store information such as system configuration parameters. Application tables are created during installation.

Figure I-1 shows the relationship between predefined fact, dimension, and application tables in the analytics database schema.

Figure I-1 Analytics Database Model

Description of Figure I-1 follows
Description of "Figure I-1 Analytics Database Model"

Tables shown in Figure I-1 store the following analytics data:

  • Application configuration

  • Event metadata

  • Report metadata

Application Configuration

Figure I-2 shows which entities are used to store system parameters for the Analytics service.

Figure I-2 Application Configuration Entities

Description of Figure I-2 follows
Description of "Figure I-2 Application Configuration Entities"

Event Metadata

Figure I-3 shows which entities are used to store event data. The Users and Times entities are mainly dimensions that provide user/time oriented views of the event data.

Event metadata records which events are collected, the tables where events are stored, as well as dimensions that are saved each time an event occurs.

Figure I-3 Event Metadata Entities

Description of Figure I-3 follows
Description of "Figure I-3 Event Metadata Entities"

Report Metadata

Figure I-4 shows which entities represent out-of-the-box analytics reports. Metadata in these tables are the primary source for information such as report metrics, report structure, and columns listed.

Report metadata stores out-of-the-box report configurations for Oracle WebCenter Analytics. Each report contains many columns to display in the report and which filters to apply. Some reports are composed from other reports.

Figure I-4 Report Metadata Entities

Description of Figure I-4 follows
Description of "Figure I-4 Report Metadata Entities"

I.1.2 Analytics Database Table Overview

This section lists and describes database tables in the analytics schema:

Note:

Table names for analytics event and dimension tables are automatically generated based on analytics event and dimension names. The mapping between analytics event and dimension names and their corresponding table names is defined in the ASSYS_EVENTS and ASSYS_EVENTDIMENSIONS tables.

For an example of how to use a query to return the table names associated with a specific event, see Section I.1.2.1, "Sample SQL Query: Finding Table Names Associated with Specific Events".

Table I-1 Analytics Facts Tables (Prefixed ASFACT_WC)

Event Object Table Name Event Table Description

Pages

ASFACT_WC_PAGECRE_0

Stores event information captured by the Analytics service when a page is created.

 

ASFACT_WC_PAGEDEL_0

Stores event information captured by the Analytics service when a page is deleted.

 

ASFACT_WC_PAGEEDI_0

Stores event information captured by the Analytics service when a page is edited.

 

ASFACT_WC_PAGETAG_0

Stores event information captured by the Analytics service when a page is tagged.

 

ASFACT_WC_PAGEVIE_0

Stores event information captured by the Analytics service when a page is viewed.

Discussions

ASFACT_WC_DISCUSS_0

Stores event information captured by the Analytics service when a discussion topic is viewed.

 

ASFACT_WC_DISCUSS_1

Stores event information captured by the Analytics service when an announcement is viewed.

 

ASFACT_WC_DISCUSS_2

Stores event information captured by the Analytics service when a discussion forum is created.

 

ASFACT_WC_DISCUSS_3

Stores event information captured by the Analytics service when a discussion forum is deleted.

 

ASFACT_WC_DISCUSS_4

Stores event information captured by the Analytics service when a discussion topic is created.

 

ASFACT_WC_DISCUSS_5

Stores event information captured by the Analytics service when a discussion topic is edited.

 

ASFACT_WC_DISCUSS_6

Stores event information captured by the Analytics service when a discussion topic is deleted.

 

ASFACT_WC_DISCUSS_7

Stores event information captured by the Analytics service when a discussion topic is tagged.

 

ASFACT_WC_DISCUSS_8

Stores event information captured by the Analytics service when someone replies to a discussion topic message.

 

ASFACT_WC_DISCUSS_9

Stores event information captured by the Analytics service when a discussion topic message is liked.

 

ASFACT_WC_DISCUSS_A

Stores event information captured by the Analytics service when an announcement is created.

 

ASFACT_WC_DISCUSS_B

Stores event information captured by the Analytics service when an announcement is edited.

 

ASFACT_WC_DISCUSS_C

Stores event information captured by the Analytics service when an announcement is deleted.

Documents - Blog - Wikis

ASFACT_WC_DOCLIB__0

Stores event information captured by the Analytics service when a document is viewed.

 

ASFACT_WC_DOCLIB__1

Stores event information captured by the Analytics service when a document is downloaded.

 

ASFACT_WC_DOCLIB__2

Stores event information captured by the Analytics service when a document is created.

 

ASFACT_WC_DOCLIB__3

Stores event information captured by the Analytics service when a document is edited.

 

ASFACT_WC_DOCLIB__4

Stores event information captured by the Analytics service when a document is tagged.

 

ASFACT_WC_DOCLIB__5

Stores event information captured by the Analytics service when a document is liked.

 

ASFACT_WC_DOCLIB__6

Stores event information captured by the Analytics service when a document is commented.

 

ASFACT_WC_DOCLIB__7

Stores event information captured by the Analytics service when a document is deleted.

Space Events

ASFACT_WC_EVENT_C_0

Stores event information captured by the Analytics service when a Space event is created.

 

ASFACT_WC_EVENT_D_0

Stores event information captured by the Analytics service when a Space event is edited.

 

ASFACT_WC_EVENT_E_0

Stores event information captured by the Analytics service when a Space event is deleted.

Spaces

ASFACT_WC_GROUPSP_0

Stores event information captured by the Analytics service when a Space is viewed.

 

ASFACT_WC_GROUPSP_1

Stores event information captured by the Analytics service when a Space is created.

 

ASFACT_WC_GROUPSP_2

Stores event information captured by the Analytics service when someone joins a Space.

 

ASFACT_WC_GROUPSP_3

Stores event information captured by the Analytics service when a Space is deleted.

Lists

ASFACT_WC_LIST_CR_0

Stores event information captured by the Analytics service when a list is created.

 

ASFACT_WC_LIST_DE_0

Stores event information captured by the Analytics service when a list is deleted.

 

ASFACT_WC_LIST_ED_0

Stores event information captured by the Analytics service when a list is edited.

Logins

ASFACT_WC_LOGINS_0

Stores event information captured by the Analytics service when a user logs in to the site.

People

ASFACT_WC_PEOPLEC_0

Stores event information captured by the Analytics service when someone adds a connection.

 

ASFACT_WC_PEOPLEC_1

Stores event information captured by the Analytics service when someone posts on a wall.

 

ASFACT_WC_PEOPLEC_2

Stores event information captured by the Analytics service when someone edits a profile.

 

ASFACT_WC_PEOPLEC_3

Stores event information captured by the Analytics service when someone edits status information.

Portlets

ASFACT_WC_PORTLET_0

Stores event information captured by the Analytics service when a portlet is viewed.

Searches

ASFACT_WC_SEARCHE_0

Stores event information captured by the Analytics service when a search is performed.


Table I-2 Analytics Dimension Tables (Prefixed ASDIM_WC)

Dimension Name Table Name Dimension Table Description

Applications

ASDIM_WC_APPLICA_0

Stores names of WebCenter applications accessing analytics data.

IP Clients

ASDIM_WC_CLIENT__0

Stores client IP addresses received in analytics events.

Discussion Topics

ASDIM_WC_DISCUSS_0

Stores discussion topic details received in analytics events.

Discussion Forums

ASDIM_WC_DISCUSS_1

Stores discussion forum details received in analytics events.

Discussion Messages

ASDIM_WC_DISCUSS_2

Stores discussion message details received in analytics events.

Announcements

ASDIM_WC_DISCUSS_3

Stores announcement details received in analytics events.

Documents

ASDIM_WC_DOCUMENT_0

Stores document details received in analytics events.

Lists

ASDIM_WC_LISTS_0

Stores list details received in analytics events.

Pages

ASDIM_WC_PAGES_0

Stores WebCenter page details received in analytics events.

Portlets

ASDIM_WC_PORTLET_0

Stores portlet information received in analytics events.

Portlet Instances

ASDIM_WC_PORTLET_1

Stores portlet instance information received in analytics events.

Portlet Producers

ASDIM_WC_PRODUCE_0

Stores producers associated with portlet.

Referrers

ASDIM_WC_REFERRE_0

Stores referred URLs where analytics events come from.

Searches

ASDIM_WC_SEARCHE_0

Stores search phrases received in analytics events.

Space Events

ASDIM_WC_EVENTS_0

Stores Space event details, received in analytics events.

Spaces

ASDIM_WC_GROUPSP_0

Stores Space information received in analytics events.

Tags

ASDIM_WC_TAGS_0

Stores tags received in analytics events.

Browsers

ASDIM_WC_USER_AG_0

Stores information about which browsers are used to access analytics.

Times

ASDIM_TIME

Stores times used to group analytics reports.

Users

ASDIM_USERS

Stores user details received in analytics events.

User Properties

ASDIM_USERPROPERTIES

Stores user properties.

User Property Values

ASDIM_USERPROPERTYVALUES

Stores user property values.


Table I-3 Analytics System Tables (Prefixed ASSYS)

Entity Name Table Name Table Description

Configuration

ASSYS_CONFIG

Stores system configuration details.

Dimension Properties

ASSYS_DIMENSIONPROPS

Stores configuration details for each dimension.

Event Dimensions

ASSYS_EVENTDIMENSIONS

Stores dimensions associated with each event.

Event Facts

ASSYS_EVENTFACTS

Stores facts associated with each event.

Events

ASSYS_EVENTS

Stores the different types of analytics events that are collected by the Analytics service.

An analytics event represents a single user action, such as document view, user login, and so on.

Namespaces

ASSYS_NAMESPACES

Stores the namespace in which analytics events are registered.

Report Composition

ASSYS_REPORTCOMPOSITION

Stores out-of-the-box composite analytics reports.

Report Group

ASSYS_REPORTGROUP

Stores out-of-the-box analytics report groups, such as portlets, services, and so on.

Report Items

ASSYS_REPORTITEMS

Stores items included in each analytics report.

Report Item Values

ASSYS_REPORTITEMVALUES

Stores values associated with each item in an analytics report.

Reports

ASSYS_REPORTS

Stores out-of-the-box analytics reports.


I.1.2.1 Sample SQL Query: Finding Table Names Associated with Specific Events

This section provides a sample SQL query to return the names of tables associated with a specific event. This query uses a filter to return tables associated with the Documents service.

SELECT tablename "Table Name",
       displayname "Event Display Name"
FROM   assys_events
WHERE tablename like 'ASFACT_WC_DOCLIB%'
ORDER BY 1;

Sample Report Output

Table Name            Event Display Name 
-----------------------------------------
ASFACT_WC_DOCLIB__0   {HTTP://WWW.ORACLE.COM/ANALYTICS/WC}DOCLIB_DOCUMENTVIEWS
ASFACT_WC_DOCLIB__1   {HTTP://WWW.ORACLE.COM/ANALYTICS/WC}DOCLIB_DOCUMENTDOWNLOADS
ASFACT_WC_DOCLIB__2   {HTTP://WWW.ORACLE.COM/ANALYTICS/WC}DOCLIB_DOCUMENTCREATE
ASFACT_WC_DOCLIB__3   {HTTP://WWW.ORACLE.COM/ANALYTICS/WC}DOCLIB_DOCUMENTEDIT
ASFACT_WC_DOCLIB__4   {HTTP://WWW.ORACLE.COM/ANALYTICS/WC}DOCLIB_DOCUMENTTAG
ASFACT_WC_DOCLIB__5   {HTTP://WWW.ORACLE.COM/ANALYTICS/WC}DOCLIB_DOCUMENTLIKE
ASFACT_WC_DOCLIB__6   {HTTP://WWW.ORACLE.COM/ANALYTICS/WC}DOCLIB_DOCUMENTCOMMENT
ASFACT_WC_DOCLIB__7   {HTTP://WWW.ORACLE.COM/ANALYTICS/WC}DOCLIB_DOCUMENTDELETES

I.2 Analytics Fact Table Descriptions

Analytics fact tables are created when the Analytics Collector runs for the first time. Each fact table stores a specific event type, for example, page views, Space views, document uploads, blog views, wiki edits, and so on. Columns in these fact table mostly contain integer IDs that reference descriptive data stored in dimension tables.

This section describes each of the tables listed in Table I-1, "Analytics Facts Tables (Prefixed ASFACT_WC)".

I.2.1 ASFACT_WC_PAGECRE_0

Fact table that stores event information captured by the Analytics service when someone creates a page.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time the dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
PAGE_ NULL NUMBER(38) Page ID dimension. ASDIM_WC_PAGES_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID. ASDIM_WC_APPLICA_0.ID

I.2.2 ASFACT_WC_PAGEDEL_0

Fact table that stores event information captured by the Analytics service when someone deletes a page.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time the dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
PAGE_ NULL NUMBER(38) Page ID dimension. ASDIM_WC_PAGES_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.3 ASFACT_WC_PAGEEDI_0

Fact table that stores event information captured by the Analytics service when someone edits a page.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
PAGE_ NULL NUMBER(38) Page ID dimension. ASDIM_WC_PAGES_0.ID

I.2.4 ASFACT_WC_PAGETAG_0

Fact table that stores event information captured by the Analytics service when someone tags a page.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
TAG_ NULL NUMBER(38) Tag ID dimension. ASDIM_WC_USER_AG_0.ID
PAGE_ NULL NUMBER(38) Page ID dimension. ASDIM_WC_PAGES_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.5 ASFACT_WC_PAGEVIE_0

Fact table that stores event information captured by the Analytics service when someone views a page.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
RESPONSE_TIME_ NULL NUMBER(16) Response time (ms).  
CLIENT_IP_ NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID.  
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
REFERRER_ NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
PAGE_ NULL NUMBER(38) Page ID dimension. ASDIM_WC_PAGES_0.ID
USER_AGENT_ NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.6 ASFACT_WC_DISCUSS_0

Fact table that stores event information captured by the Analytics service when someone views a discussion topic.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
CLIENT_IP_ NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
USER_AGENT_ NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID
FORUM_ NULL NUMBER(38) Discussion forum associated with the event. ASDIM_WC_DISCUSS_1.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID.  
TOPIC_ NULL NUMBER(38) Discussion topic associated with the event. ASDIM_WC_DISCUSS_0.ID
REFERRER_ NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.7 ASFACT_WC_DISCUSS_1

Fact table that stores event information captured by the Analytics service when someone views an announcement.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
CLIENT_IP_ NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
REFERRER_ NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
USER_AGENT_ NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID.  
ANNOUNCEMENT_ NULL NUMBER(38) Announcement associated with the event. ASDIM_WC_DISCUSS_3.ID

I.2.8 ASFACT_WC_DISCUSS_2

Fact table that stores event information captured by the Analytics service when someone creates a discussion forum.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
DISCUSSION_FORUM_ NULL NUMBER(38) Discussion forum ID dimension. ASDIM_WC_DISCUSS_0.ID

I.2.9 ASFACT_WC_DISCUSS_3

Fact table that stores event information captured by the Analytics service when someone deletes a discussion forum.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
DISCUSSION_FORUM_ NULL NUMBER(38) Discussion forum ID dimension. ASDIM_WC_DISCUSS_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.10 ASFACT_WC_DISCUSS_4

Fact table that stores event information captured by the Analytics service when someone creates a discussion topic.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
DISCUSSION_TOPIC_ NULL NUMBER(38) Discussion topic ID dimension. ASDIM_WC_DISCUSS_0.ID
DISCUSSION_MESSAGE_ NULL NUMBER(38) Discussion message ID dimension. ASDIM_WC_DISCUSS_2.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.11 ASFACT_WC_DISCUSS_5

Fact table that stores event information captured by the Analytics service when someone edits a discussion topic.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
DISCUSSION_TOPIC_ NULL NUMBER(38) Discussion topic ID dimension. ASDIM_WC_DISCUSS_0.ID

I.2.12 ASFACT_WC_DISCUSS_6

Fact table that stores event information captured by the Analytics service when someone deletes a discussion topic.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
DISCUSSION_TOPIC_ NULL NUMBER(38) Discussion topic ID dimension. ASDIM_WC_DISCUSS_0.ID

I.2.13 ASFACT_WC_DISCUSS_7

Fact table that stores event information captured by the Analytics service when someone tags a discussion topic.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
TAG_ NULL NUMBER(38) Tag ID dimension. ASDIM_WC_TAGS_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
DISCUSSION_TOPIC_ NULL NUMBER(38) Discussion topic ID dimension. ASDIM_WC_DISCUSS_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.14 ASFACT_WC_DISCUSS_8

Fact table that stores event information captured by the Analytics service when someone replies to a discussion topic message.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
DISCUSSION_MESSAGE_ NULL NUMBER(38) Discussion message ID dimension. ASDIM_WC_DISCUSS_2.ID
DISCUSSION_TOPIC_ NULL NUMBER(38) Discussion topic ID dimension. ASDIM_WC_DISCUSS_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.15 ASFACT_WC_DISCUSS_9

Fact table that stores event information captured by the Analytics service when someone likes a discussion topic message.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
DISCUSSION_MESSAGE_ NULL NUMBER(38) Discussion message ID dimension. ASDIM_WC_DISCUSS_2.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
DISCUSSION_TOPIC_ NULL NUMBER(38) Discussion topic ID dimension. ASDIM_WC_DISCUSS_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.16 ASFACT_WC_DISCUSS_A

Fact table that stores event information captured by the Analytics service when someone creates an announcement.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
DISCUSSION_ANNOUNCEMENT_ NULL NUMBER(38) Announcement ID dimension. ASDIM_WC_DISCUSS_3.ID

I.2.17 ASFACT_WC_DISCUSS_B

Fact table that stores event information captured by the Analytics service when someone edits an announcement.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
DISCUSSION_ANNOUNCEMENT_ NULL NUMBER(38) Announcement ID dimension. ASDIM_WC_DISCUSS_3.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.18 ASFACT_WC_DISCUSS_C

Fact table that stores event information captured by the Analytics service when someone deletes an announcement.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
DISCUSSION_FORUM_ NULL NUMBER(38) Discussion forum ID dimension. ASDIM_WC_DISCUSS_1.ID

I.2.19 ASFACT_WC_DOCLIB__0

Fact table that stores event information captured by the Analytics service when someone views a document.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL DATE Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
RESPONSE_TIME_ NULL NUMBER(16) Response Time (ms).  
CLIENT_IP_ NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID.  
GROUPSPACE NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
REFERRER NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
DOCUMENT NULL NUMBER(38) Document ID dimension. ASDIM_WC_DOCUMENT_0.ID
USER_AGENT NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID
APPLICATION NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.20 ASFACT_WC_DOCLIB__1

Fact table that stores event information captured by the Analytics service when someone downloads a document.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL DATE Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
DOCUMENT NULL NUMBER(38) Document ID dimension. ASDIM_WC_DOCUMENT_0.ID
REFERRER_ NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
CLIENT_IP_ NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
USER_AGENT_ NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID.  
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.21 ASFACT_WC_DOCLIB__2

Fact table that stores event information captured by the Analytics service when someone creates document.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL DATE Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
WEBCENTER_RESOURCE_ NULL NUMBER(38) WebCenter resource ID.  
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.22 ASFACT_WC_DOCLIB__3

Fact table that stores event information captured by the Analytics service when someone edits a document.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
WEBCENTER_RESOURCE_ NULL NUMBER(38) WebCenter resource ID.  
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.23 ASFACT_WC_DOCLIB__4

Fact table that stores event information captured by the Analytics service when someone tags a document.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
TAGS NULL NUMBER(38) Tag added to the document.  
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
WEBCENTER_RESOURCE_ NULL NUMBER(38) WebCenter resource ID.  
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.24 ASFACT_WC_DOCLIB__5

Fact table that stores event information captured by the Analytics service when someone "likes" a document.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
WEBCENTER_RESOURCE_ NULL NUMBER(38) WebCenter resource ID.  

I.2.25 ASFACT_WC_DOCLIB__6

Fact table that stores event information captured by the Analytics service when someone comments on a document.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
WEBCENTER_RESOURCE_ NULL NUMBER(38) WebCenter resource ID.  
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.26 ASFACT_WC_DOCLIB__7

Fact table that stores event information captured by the Analytics service when someone deletes a document.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
WEBCENTER_RESOURCE_ NULL NUMBER(38) WebCenter resource ID.  

I.2.27 ASFACT_WC_EVENT_C_0

Fact table that stores event information captured by the Analytics service when someone creates a Space event.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
EVENT_ NULL NUMBER(38) Event Identifier. ASDIM_WC_EVENTS_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.28 ASFACT_WC_EVENT_D_0

Fact table that stores event information captured by the Analytics service when someone edits a Space event.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
EVENT_ NULL NUMBER(38) Event Identifier. ASDIM_WC_EVENTS_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.29 ASFACT_WC_EVENT_E_0

Fact table that stores event information captured by the Analytics service when an event is deleted.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
EVENT_ NULL NUMBER(38) Event Identifier. ASDIM_WC_EVENTS_0.ID

I.2.30 ASFACT_WC_GROUPSP_0

Fact table that stores event information captured by the Analytics service when someone views a Space.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
CLIENT_IP_ NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID.  
RESPONSE_TIME_ NULL NUMBER(16) Response time (ms).  
REFERRER_ NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
USER_AGENT_ NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.31 ASFACT_WC_GROUPSP_1

Fact table that stores event information captured by the Analytics service when someone creates a Space in WebCenter Spaces.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.32 ASFACT_WC_GROUPSP_2

Fact table that stores event information captured by the Analytics service when someone joins a Space in WebCenter Spaces.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.33 ASFACT_WC_GROUPSP_3

Fact table that stores event information captured by the Analytics service when someone deletes a Space in WebCenter Spaces.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.34 ASFACT_WC_LIST_CR_0

Fact table that stores event information captured by the Analytics service when someone creates a list.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
LIST_ NULL NUMBER(38) List ID. ASDIM_WC_LISTS_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID

I.2.35 ASFACT_WC_LIST_DE_0

Fact table that stores event information captured by the Analytics service when someone deletes a list.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
LIST_ NULL NUMBER(38) List ID. ASDIM_WC_LISTS_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.36 ASFACT_WC_LIST_ED_0

Fact table that stores event information captured by the Analytics service when someone edits a list.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
LIST_ NULL NUMBER(38) List ID. ASDIM_WC_LISTS_0.ID
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.2.37 ASFACT_WC_LOGINS_0

Fact table that stores login event information captured by the Analytics service with related data for each event.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID  
USER_AGENT_ NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID
REFERRER_ NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
CLIENT_IP_ NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID

I.2.38 ASFACT_WC_PEOPLEC_0

Fact table that stores event information captured by the Analytics service when someone adds a people connection.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
TARGET_USER NULL NUMBER(38) User ID  

I.2.39 ASFACT_WC_PEOPLEC_1

Fact table that stores event information captured by the Analytics service when someone posts on a wall.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
TARGET_USER NULL NUMBER(38) User ID.  

I.2.40 ASFACT_WC_PEOPLEC_2

Fact table that stores event information captured by the Analytics service when someone edits a profile.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID

I.2.41 ASFACT_WC_PEOPLEC_3

Fact table that stores event information captured by the Analytics service when someone edits status information.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID

I.2.42 ASFACT_WC_PORTLET_0

Fact table that stores information captured by the Analytics service when portlets are accessed by end users.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
CACHED_ NULL NUMBER(5) Indicates whether the portlet was displayed from the cache.  
PORTLET_ NULL NUMBER(38) Portlet. ASDIM_WC_PORTLET_1.ID
REFERRER_ NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
PRODUCER_ NULL NUMBER(38) Portlet producer. ASDIM_WC_PRODUCE_0.ID
PAGE_ NULL NUMBER(38) Page ID dimension. ASDIM_WC_PAGES_0.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID.  
CLIENT_IP NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID
PORTLET_INSTANCE_ NULL NUMBER(38) Portlet instance.  
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID
RESPONSE_TIME_ NULL NUMBER(16) Response time (ms).  
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
USER_AGENT_ NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID

I.2.43 ASFACT_WC_SEARCHE_0

Fact table that stores event information captured by the Analytics service when someone performs a search.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
OCURRED NOT NULL DATE Date event occurred.  
TIMEID NOT NULL NUMBER(38) Time dimension event occurred. This column is used for partitioning. ASDIM_TIME.ID
USERID NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
EVENTID NULL NUMBER(38) Event ID dimension. ASSYS_EVENTFACTS.ID
PAGE_ NULL NUMBER(38) Page ID dimension. ASDIM_WC_PAGES_0.ID
USER_AGENT_ NULL NUMBER(38) User agent. ASDIM_WC_USER_AG_0.ID
CLIENT_IP_ NULL NUMBER(38) Client IP ID dimension. ASDIM_WC_CLIENT__0.ID
APPLICATION_ NULL NUMBER(38) Application ID dimension. ASDIM_WC_APPLICA_0.ID
SESSION_ID_ NULL NVARCHAR2(254) Session ID.  
REFERRER_ NULL NUMBER(38) Referrer ID dimension. ASDIM_WC_REFERRE_0.ID
SEARCHED_PHRASE NULL NUMBER(38) Search phrase.  
GROUPSPACE_ NULL NUMBER(38) Space ID dimension. ASDIM_WC_GROUPSP_0.ID

I.3 Analytics Dimension Table Descriptions

Analytics dimension tables are created when the Analytics Collector runs for the first time. Dimension tables store redundant descriptive data associated with analytics events. When a value is not found in these tables, a new record is added. Typical analytics dimension data includes: page name, browser name, document name, Space name, and so on.

This section describes each of the tables listed in Table I-2, "Analytics Dimension Tables (Prefixed ASDIM_WC)".

I.3.1 ASDIM_WC_APPLICA_0

Dimension table that stores the names of WebCenter applications accessing analytics data, for example webenter (WebCenter Spaces application).

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
NAME_ NOT NULL NVARCHAR2(254) Application name.  

I.3.2 ASDIM_WC_CLIENT__0

Dimension table that stores client IP address details captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
IP NOT NULL NVARCHAR2(15) Client IP address  

I.3.3 ASDIM_WC_DISCUSS_0

Dimension table that stores discussion topic details captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
ICONURL_ NULL NVARCHAR2(254) Icon URL  
NAME_ NULL NVARCHAR2(254) Discussion topic name.  
DESCRIPTION_ NULL NVARCHAR2(254) Discussion topic description.  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.  

I.3.4 ASDIM_WC_DISCUSS_1

Dimension table that stores discussion forum details captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
ICONURL_ NULL NVARCHAR2(254) Icon URL  
DESCRIPTION_ NULL NVARCHAR2(254) Discussion forum description.  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.  
NAME_ NULL NVARCHAR2(254) WebCenter resource name, that is, the name of the discussion forum.  

I.3.5 ASDIM_WC_DISCUSS_2

Dimension table that stores discussion message details captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date records last modified.  
NAME_ NULL NVARCHAR2(254) WebCenter resource name, that is, the name of the discussion message.  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.  
DESCRIPTION_ NULL NVARCHAR2(254) Discussion message description.  
ICONURL_ NULL NVARCHAR2(254) Icon URL  

I.3.6 ASDIM_WC_DISCUSS_3

Dimension table that stores announcement details captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
DESCRIPTION_ NULL NVARCHAR2(254) Announcement description.  
ICONURL_ NULL NVARCHAR2(254) Icon URL  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.  
NAME_ NULL NVARCHAR2(254) WebCenter resource name, that is, name of the announcement.  

I.3.7 ASDIM_WC_DOCUMENT_0

Dimension table that stores information captured by the Analytics service when documents are accessed by end users.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
CONTENTTYPE_ NULL NVARCHAR2(254) Document content type.  
CONTEXT NULL NVARCHAR2(512) Document prefix (for identification purposes):
  • Document prefix - Folder URL for parent Space

  • Blog prefix - Blog title name

  • Wiki prefix - Wiki title name

 
NAME_ NULL NVARCHAR2(254) Document name.  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.  
DESCRIPTION_ NULL NVARCHAR2(254) Document description.  
ICONURL_ NULL NVARCHAR2(254) Icon URL  
PATH_ NULL NVARCHAR2(512) Document path.  
OBJECTTYPE_ NULL NVARCHAR2(254) Object type.  

I.3.8 ASDIM_WC_EVENTS_0

Dimension table that stores information about Space events captured by the Analytics service when a user creates an event in his or her calendar.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.  
NAME_ NULL NVARCHAR2(254) WebCenter resource name, that is, the name of the Space event.  

I.3.9 ASDIM_WC_GROUPSP_0

Dimension table that stores information captured by the Analytics service when a Space is accessed by an end user (WebCenter Spaces only).

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
ICONURL_ NULL NVARCHAR2(254) Icon URL  
DESCRIPTION_ NULL NVARCHAR2(254) Description.  
PERSONAL_ NULL NUMBER(5) Indicates whether the Space is a Home Space (0) or a Group Space (1).  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.  
NAME_ NULL NVARCHAR2(254) Name of the Space.  

I.3.10 ASDIM_WC_LISTS_0

Dimension table that stores list details captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
NAME_ NULL NVARCHAR2(254) WebCenter resource name, that is, the name of the list.  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.  

I.3.11 ASDIM_WC_PAGES_0

Dimension table that stores information captured by the Analytics service when pages are accessed by end users.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
PERSONAL_ NULL NUMBER(5) Indicates whether the page is a personal page (in the Home Space) or belongs to a Group Space.  
RESOURCEID_ NOT NULL NVARCHAR2(254) WebCenter resource ID.

The full page path, for example, /oracle/webcenter/page/sda254765_f950/Home.jspx

 
NAME_ NULL NVARCHAR2(254) Name of the page.  

I.3.12 ASDIM_WC_PORTLET_0

Dimension table that stores information captured by the Analytics service when portlets are accessed by end users.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record modified.  
DEFAULT_TITLE_ NULL NVARCHAR2(254) Default portlet title.  
RESOURCEID_ NOT NULL NVARCHAR2(512) WebCenter resource ID.  

I.3.13 ASDIM_WC_PORTLET_1

Dimension table that stores portlet instance information captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
TITLE_ NULL NVARCHAR2(254) Portlet title.  
RESOURCEID_ NOT NULL NVARCHAR2(512) WebCenter resource ID.  

I.3.14 ASDIM_WC_PRODUCE_0

Dimension table that stores portlet producer information captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record modified.  
RESOURCEID_ NOT NULL NVARCHAR2(512) WebCenter resource ID.  
NAME_ NULL NVARCHAR2(254) Producer name.  

I.3.15 ASDIM_WC_REFERRE_0

Dimension table that stores information captured by the Analytics service related to the location (URL) to which the user was navigating when the analytics event was captured.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
URL NOT NULL NVARCHAR2(2000) Referred URL  

I.3.16 ASDIM_WC_SEARCHE_0

Dimension table that stores search phrases captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
PHRASE NOT NULL NVARCHAR2(254) Search phrase.  

I.3.17 ASDIM_WC_TAGS_0

Dimension table that stores tag information captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
VALUE NOT NULL NVARCHAR2(254) Tag value.  

I.3.18 ASDIM_WC_USER_AG_0

Dimension table that stores information about whichbrowsers are used to access analytics data.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
OS NULL NVARCHAR2(100) Operating system.  
AGENT NOT NULL NVARCHAR2(512) User agent ID.  
BROWSER NULL NVARCHAR2(255) Name of the browser.  
BROWSER_VERSION NULL NVARCHAR2(30) Browser version.  

I.3.19 ASDIM_TIME

Dimension table that stores times used to group analytics reports. An entry is created every hour. analytics reports use this table to group data within a specific time frame.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
PERIODSTART NULL DATE Current period start.  
PERIODEND NULL DATE Current period end.  
HOUROFDAY NULL NUMBER(5) Hour corresponding to this time period.  
DAYOFMONTH NOT NULL NUMBER(5) Current day of the month.  
DAYOFYEAR NULL NUMBER(5) Current day of the year.  
WEEKOFYEARSUNDAY NULL NUMBER(5) Week number of Sunday year.  
WEEKOFYEARMONDAY NULL NUMBER(5) Week number of Monday year.  
WEEKOFYEARSATURDAY NULL NUMBER(5) Week number of Saturday year.  
MONTHOFYEAR NOT NULL NUMBER(5) Month corresponding to the period's year.  
YEAR NOT NULL NUMBER(5) Current year.  

I.3.20 ASDIM_USERS

Dimension table that stores user details captured by the Analytics service when an analytics event is received.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
USERID NOT NULL NVARCHAR2(255) User ID.

For example: weblogic

 
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  

I.3.21 ASDIM_USERPROPERTIES

Dimension table that stores user properties, such as Title, Department, and so on.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
PROPERTYID NOT NULL NUMBER(38) Property ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NULL DATE Date record last modified.  
NAME NOT NULL NVARCHAR2(255) Property name.  

I.3.22 ASDIM_USERPROPERTYVALUES

Dimension table that stores values for user properties.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
USERID NOT NULL NUMBER(38) User ID dimension. ASDIM_USERS.ID
PROPERTYID NOT NULL NUMBER(38) Property ID. ASDIM_USERPROPERTIES.ID
VALUE NULL NVARCHAR2(255) Property ID value.  
TYPE NULL NUMBER(38) Property type.  

I.4 Analytics System Table Descriptions

System tables are created during installation to store application information such as system configuration parameters. Each table is described in this section.

I.4.1 ASSYS_CONFIG

System table that stores system configuration information. Each row contains value pairs—configuration type/value.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
NAME NULL NVARCHAR2(510) Name of configuration parameter, for example, collector_port.  
CONFIGTYPEID NOT NULL NUMBER(38) Configuration type ID.  
INTVAL NULL NUMBER(38) Integer value associated with the configuration.  
STRVAL NULL NVARCHAR2(2000) String value associated with the configuration.  

I.4.2 ASSYS_DIMENSIONPROPS

System table that stores dimension configuration information. Each row represents property values for a dimension.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
DIMENSIONID NOT NULL NUMBER(38) Dimension ID. ASSYS_EVENTDIMENSIONS.ID
DISPAYNAME NOT NULL NVARCHAR2(510) Dimension property display name.  
COLUMNNAME NOT NULL NVARCHAR2(510) Column name.  
COLUMNTYPE NULL NUMBER(38) Column type.  
COLUMNLENGTH NULL NUMBER(38) Column length.  
ISKEY NULL NUMBER(38) Indicates whether this is a key dimension property.  

I.4.3 ASSYS_EVENTDIMENSIONS

System table that stores dimensions associated with each analytics event.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
DISPAYNAME NOT NULL NVARCHAR2(510) Dimension event display name.  
TABLENAME NOT NULL NVARCHAR2(510) Table name associated with the dimension.  
ISUNIQUE NULL NUMBER(38) Deprecated.  
IDENTIFYINGUSER NOT NULL NUMBER(38) User ID. ASDIM_USERS.ID

I.4.4 ASSYS_EVENTFACTS

System table that stores facts associated with each analytics event.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
EVENTID NULL NUMBER(38) Event ID dimension. ASDIM_WC_EVENTS_0.ID
DISPAYNAME NOT NULL NVARCHAR2(510) Event fact display name.  
COLUMNAME NOT NULL NVARCHAR2(510) Event fact column name.  
COLUMNTYPEID NULL NUMBER(38) Indicates the data type of the event fact: INTEGER (1), STRING (2), DATE (3), FLOAT (4), BOOLEAN (5)If the event fact is a dimension, COLUMNTYPEID is -1.  
COLUMNLENGTH NULL NUMBER(38) User ID.  
EVENTDIMENSIONID NULL NUMBER(38) Dimension ID. ASSYS_EVENTDIMENSIONS.ID

I.4.5 ASSYS_EVENTS

System table that stores the different analytics events representing one user action that is captured. Both out-of-the-box analytics events and custom (user-defined) analytics events are stored. Each row represents the event captured with its associated data such as active status, and table name where data is stored.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
DISPAYNAME NOT NULL NVARCHAR2(510) Event fact display name.  
DESCRIPTION NULL NVARCHAR2(510) Event description.  
TABLENAME NOT NULL NVARCHAR2(510) Table name.  
ISCUSTOM NOT NULL NUMBER(38) Indicates whether or not the event is a custom event. (0/1)  
ISACTIVE NOT NULL NUMBER(38) Deprecated.  
ISPERSISTENT NOT NULL NUMBER(38) Indicates whether or not to create a fact table for the event. (0/1)  
ISACTION NOT NULL NUMBER(38) Not used.  

I.4.6 ASSYS_NAMESPACES

System table that stores the different namespaces in which analytics events are registered.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
PREFIX NOT NULL NVARCHAR2(510) Namespace prefix.  
URI NOT NULL NVARCHAR2(510) Universal resource identifier for the namespace.  

I.4.7 ASSYS_REPORTCOMPOSITION

System table that stores the composition for reports provided by the Analytics service.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
PARENTREPORTID NOT NULL NUMBER(38) Reference to parent report ID. ASSYS_REPORTS.ID
CHILDREPORTID NOT NULL NUMBER(38) Reference to child report ID. ASSYS_REPORTS.ID
SEQUENCE NULL NUMBER(10) Sequence of report composition.  
NAME NOT NULL NVARCHAR2(510) Name of report composition.  
DESCRIPTION NULL NVARCHAR2(510) Description of report composition.  

I.4.8 ASSYS_REPORTGROUP

System table that stores the report groups included for the Analytics service. Report groups enable end users to display analytics data in a specific way.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record was last modified.  
NAME NOT NULL NVARCHAR2(510) Report group name.  
DESCRIPTION NULL NVARCHAR2(510) Report group description.  
SEQUENCE NULL NUMBER(10) Sequence.  

I.4.9 ASSYS_REPORTITEMS

System table that stores item information in each report. Each row represents a specific item belonging to one report.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
REPORTID NOT NULL NUMBER(38) Report ID. ASSYS_REPORTS.ID
ITEMTYPE NOT NULL VARCHAR2(30) Item type.  
ITEMDESCRIPTION NULL NVARCHAR2(510) Item description.  
ITEMVALUE NULL NUMBER(5) Item value.  
EVENTDIMENSIONID NULL NUMBER(38) Dimension ID. ASSYS_EVENTDIMENSIONS.ID
EVENTDIMENSIONNAME NULL NVARCHAR2(510) Dimension name.  
EVENTFACTID NULL NUMBER(38) Event fact ID. ASSYS_EVENTFACTS.ID
EVENTFACTNAME NULL NVARCHAR2(510) Event fact name.  
PROPERTYNAME NULL NVARCHAR2(510) The name of the column in the dimension table to be selected in the query performed, for example, name or ID.  
AGGREGATEFUNCTION NULL VARCHAR2(60) SQL function for grouping purposes (AVG, MIN, MAX, COUNT, COUNT DISTINCT).  
DISPLAYFLAG NOT NULL NUMBER(5) Indicates whether or not to display the item in the report. (0/1)  
IDENTIFIERFLAG NOT NULL NUMBER(5) Indicates whether or not to use this item as an identifier (SQL: whether or not to group by this column). (0/1)  

I.4.10 ASSYS_REPORTITEMVALUES

System table that stores the values associated to each item in a report. Each row represents a specific value (char, float or date) for one report item instance.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
REPORTITEMID NOT NULL NUMBER Report item ID. ASSYS_REPORTITEMS.ID
VALUETYPE NOT NULL VARCHAR2(30) Value type: CVALUE, NVALUE or DVALUE.  
CVALUE NULL NVARCHAR2(510) Char value.*  
NVALUE NULL NUMBER Numeric value.*  
DVALUE NULL DATE Date value.*  

*Only one of CVALUE, NVALUE or DVALUE has a value.

I.4.11 ASSYS_REPORTS

System table that stores the different out-of-the-box reports to be provided by the Analytics service. Each row represents a single report and the report's configuration.

Column Name NOT NULL? Data Type Description Foreign Key
ID NOT NULL NUMBER(38) Internal table ID.  
CREATED NOT NULL DATE Date record created.  
LASTMODIFIED NOT NULL DATE Date record last modified.  
NAME NOT NULL NVARCHAR2(510) Report item ID.  
DESCRIPTION NULL NVARCHAR2(255) Report description.  
SEQUENCE NULL NUMBER(10) Sequence.  
GROUPID NULL NUMBER (38) Group ID for the report. ASSYS_REPORTGROUP.ID
EVENTTYPEID NULL NUMBER(38) Associated event ID. ASSYS_EVENTS.ID
EVENTDISPLAYNAME NULL NVARCHAR2(510) Denormalized. Display name of associated event.  
GROUPSPACEFILTERENABLED NOT NULL VARCHAR2(1) Indicates whether users can filter the report 'by Space'. If set to true (1), the report displays the Space selector UI.  
DEFAULTCHARTSTYLE NULL NVARCHAR2(255) Default chart style for the report.  
DEFAULTCHARTTYPE NULL NUMBER(2) Default chart type.  
DEFAULTDISPLAYCOUNT NULL NUMBER(2) Default display count.  
DEFAULTTIMEFRAME NULL NUMBER(2) Default time frame.  
DEFAULTGROUPBYTIMEINTERVAL NULL NUMBER(2) Default group time interval.  
DEFAULTGROUPBYUSERPROPERTY NULL NUMBER(38) Default "group by user" property.  
SHOWMETRICSELECTOR NOT NULL NVARCHAR2(1) Indicates whether or not to display selector UI for this metric. (Y/N)  
SHOWCHARTTYPEOPTIONS NOT NULL NVARCHAR2(1) Indicates whether or not to display chart type options in the UI. (Y/N)  
SHOWDISPLAYOPTIONS NOT NULL NVARCHAR2(1) Indicates whether or not the field to select display options will be shown in the UI. (Y/N) (The field is a drop-down list to select between: Top n, Bottom n, All records, or List of specific records.)  
SHOWDISPLAYTOPOPTION NOT NULL NVARCHAR2(1) Indicates whether or not users will be able to select the "Top n" option. (Y/N)
If N, the "Top n" option will not be available in the combo box.
 
SHOWDISPLAYBOTTOMOPTION NOT NULL NVARCHAR2(1) Indicates whether or not users will be able to select the "Bottom n" option. (Y/N) If N, the "Bottom n" option will not be available in the combo box.  
SHOWDISPLAYALLOPTION NOT NULL NVARCHAR2(1) Indicates whether or not users will be able to select the "All records" option. (Y/N) If N, the "All records" option will not be available in the combo box, and users will only be able to select from Top n, Bottom n or a list of specific records.  
SHOWOBJECTPICKER NOT NULL NVARCHAR2(1) Indicates whether or not users will be able to select a list of specific records option. (Y/N) If N, the "Select ..." option will not be available in the combo box. If Y the "Select ..." option will be available and a picker dialog will be displayed to select the list of objects to be included in the report.  
SHOWTIMEFRAMEFILTER NOT NULL NVARCHAR2(1) Indicates whether or not to display time frame filter. (Y/N)  
SHOWUSERPROPERTYFILTER NOT NULL NVARCHAR2(1) Indicates whether or not to display user property filter (Y/N).  
SHOWGROUPBYOPTIONS NOT NULL NVARCHAR2(1) Indicates whether or not to display "group by" options. (Y/N)  
COMPOSEDREPORT NOT NULL NVARCHAR2(1) Indicates whether this is a composed report.  
PORTLETTYPEID NULL NUMBER(38) Portlet type ID.  

I.5 Analytics User Properties

The Analytics service uses several tables to store information about users who are triggering analytics events in WebCenter applications. This section contains the following topics:

For sample queries related to user properties, see Section 46.3.3, "Sample Queries for User Metrics" in Chapter 46, "Integrating the Analytics Service."

I.5.1 User Property Tables - Overview

Figure I-5 shows the database model used by the Analytics service to store information about users. The user dimension table has a single property column (USERID). In addition, there are two other tables (ASDIM_USERPROPERTIES and ASDIM_USERPROPERTYVALUES) that store user properties as key-value data. This model enables additional user properties to be added without changing the user dimension definition.

Figure I-5 User Property Dimensions for Analytics

Description of Figure I-5 follows
Description of "Figure I-5 User Property Dimensions for Analytics"

The ASDIM_USERPROPERTIES table stores the names of user properties received by the Analytics service. User properties (attributes of the user including name, position, email, address, etc) are captured by the Analytics service as an event when a user logs in to Spaces, not when the properties are modified. If a user changes a property, the value of the property will be updated in analytics the next time the user logs in.

The ASDIM_PROPERTYVALUES table stores one row per property, per user, where each row corresponds to a value for a property associated with a specific user.

I.5.2 User Property Dimension Tables

User property dimension tables are described in the following topics:

I.5.2.1 ASDIM_USERPROPERTIES

Dimension table that stores the names of user properties received by the Analytics service.

Column Name Data Type Description
ID NUMBER(38,0) Table primary key. Value obtained from the sequence.
NAME VARCHAR(255) Name of the user property.

Names are converted to uppercase and whitespace characters are removed.


I.5.2.2 ASDIM_USERPROPERTYVALUES

Dimension table that stores one row per property per user, where each row corresponds to a value for a property associated with a specific user.

Column Name Data Type Description
ID NUMBER(38,0) Table primary key. Value obtained from the sequence.
USERID NUMBER(38,0) Foreign key to the ASDIM_USERS table.
PROPERTYID NUMBER(38,0) Foreign key to the ASDIM_USERPROPERTIES table.
VALUE VARCHAR(255) The value of a particular property (identified by the PROPERTYID column) for a particular user (identified by the USERID column). For example, if the property is "CITY" and the user "weblofig", this column will be storing the city name where that user works (for example "San Francisco").
TYPE NUMBER(38,0) User property value type. (Property values are always stored as strings.)

I.5.3 Out-of-the-Box User Properties for WebCenter

WebCenter applications send a specific set of user properties to the Analytics service, as shown in Table I-4.

Note:

WebCenter applications can only send properties that are set by the user or available in the user directory. If a property value is blank, no row is created for it in the ASDIM_USERPROPERTYVALUES table for that user.

Table I-4 Out-of-the-Box User Properties for WebCenter

Property Name Property Label (displayed in reports) Example Value

IMUSER

IM User

dfrabott

DISPLAYNAME

Display

Diego Frabotta

PHONE

Phone

+5411-2222-1234

TITLE

Title

Software Engineer

DEPARTMENT

Department

Analytics

MANAGER

Manager

uid=dsabaris,cn=users,dc=us,dc=myco,dc=com

COMPANY

Company

MyCo

STREET*

Street

Parque Austral, Edificio Insignia M3

ZIPCODE

ZIP Code

12345

STATEORPROVINCE

State or Province

Buenos Aires

COUNTRY

Country

Argentina

EMPLOYEEID

Employee Id

55555

CITY

City

Pilar


* STREET stores the user's home address street.

I.6 Analytics Event and Dimension Data Types

Table I-5 shows how analytics event and dimension data types map to data types in Oracle, Microsoft SQL Server, and IBM DB2 databases.

Table I-5 Analytics Event and Dimension Data Types

Analytics Event and Dimension Type Oracle
Microsoft SQL Server IBM DB2

INTEGER

NUMBER

BIGINT

INTEGER

STRING

NVARCHAR

NVARCHAR

VARGRAPHIC

DATE

DATE

DATETIME

TIMESTAMP

FLOAT

FLOAT

FLOAT

DECFLOAT

BOOLEAN

NUMBER(5)

TINYINT

SMALLINT