I WebCenter Portal Analytics Database Schema

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

This appendix contains the following topics:

Section I.1, "Analytics Database Schema Overview"
Section I.2, "Analytics Fact Table Descriptions"
Section I.3, "Analytics Dimension Table Descriptions"
Section I.4, "Analytics System Table Descriptions"
Section I.5, "Analytics User Properties"
Section I.6, "Analytics Event and Dimension Data Types"

I.1 Analytics Database Schema Overview

This section contains the following topics:

Section I.1.1, "Analytics Database Model Overview"
Section I.1.2, "Analytics Database Table Overview"

I.1.1 Analytics Database Model Overview

Oracle WebCenter Portal's 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 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 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 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 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 WebCenter Portal's 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 Report Metadata Entities"

I.1.2 Analytics Database Table Overview

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

Table I-1, "Analytics Facts Tables (Prefixed ASFACT_WC)"
Table I-2, "Analytics Dimension Tables (Prefixed ASDIM_WC)"
Table I-3, "Analytics System Tables (Prefixed ASSYS)"

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 Portal 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 Portal 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 Portal 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 Portal 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 Portal 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 Portal 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 Portal 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 Portal resource ID.

I.2.27 ASFACT_WC_EVENT_C_0

Fact table that stores event information captured by the Analytics service when someone creates an event in 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
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 an event in 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
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 the Spaces application.

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 the Spaces application.

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 the Spaces application.

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 Portal applications accessing analytics data, for example webenter (Spaces application).

Column Name	NOT NULL?	Data Type	Description
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
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
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 Portal 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
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 Portal resource ID.
NAME_	NULL	NVARCHAR2(254)	WebCenter Portal 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
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 Portal resource name, that is, the name of the discussion message.
RESOURCEID_	NOT NULL	NVARCHAR2(254)	WebCenter Portal 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
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 Portal resource ID.
NAME_	NULL	NVARCHAR2(254)	WebCenter Portal 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
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 Portal 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
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 Portal resource ID.
NAME_	NULL	NVARCHAR2(254)	WebCenter Portal 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 (Spaces application only).

Column Name	NOT NULL?	Data Type	Description
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 the Home space (0) or a group space (1).
RESOURCEID_	NOT NULL	NVARCHAR2(254)	WebCenter Portal 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
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 Portal resource name, that is, the name of the list.
RESOURCEID_	NOT NULL	NVARCHAR2(254)	WebCenter Portal 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
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 Portal 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
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 Portal 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
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 Portal 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
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 Portal 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
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
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
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
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
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
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
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
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
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
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
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 Portal applications. This section contains the following topics:

Section I.5.1, "User Property Tables - Overview"
Section I.5.2, "User Property Dimension Tables"
Section I.5.3, "Out-of-the-Box User Properties for WebCenter Portal"

For sample queries related to user properties, see Section 47.3.3, "Sample Queries for User Metrics" in Chapter 47, "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 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:

Section I.5.2.1, "ASDIM_USERPROPERTIES"
Section I.5.2.2, "ASDIM_USERPROPERTYVALUES"

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

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 Portal

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

Note:

WebCenter Portal 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 Portal

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