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

Part Number E10148-20
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
PDF · Mobi · ePub

G 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 46.3, "Building Analytics Reports.".

This appendix contains the following topics:

G.1 Analytics Database Schema Overview

This section contains the following topics:

G.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 G-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 G-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 G-1 shows the relationship between predefined fact, dimension, and application tables in the analytics database schema.

Figure G-1 Analytics Database Model

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

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

  • Application configuration

  • Event metadata

  • Report metadata

Application Configuration

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

Figure G-2 Application Configuration Entities

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

Event Metadata

Figure G-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 G-3 Event Metadata Entities

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

Report Metadata

Figure G-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 G-4 Report Metadata Entities

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

G.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.

Some table names include double underscores, for example, ASFACT_WC_DOCLIB__0. This is because all the table names include a component value that is 7 characters long, and in some cases one of those characters is an underscore (for example, DOCLIB_ ).

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

Table G-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 deleted.

 

ASFACT_WC_EVENT_E_0

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

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 G-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 G-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.


G.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

G.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 G-1, "Analytics Facts Tables (Prefixed ASFACT_WC)".

G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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.

 

G.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


G.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.

 

G.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


G.2.28 ASFACT_WC_EVENT_D_0

Fact table that stores event information captured by the Analytics service when someone deletes an event from 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


G.2.29 ASFACT_WC_EVENT_E_0

Fact table that stores event information captured by the Analytics service when someone edits and 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

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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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


G.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

 

G.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.

 

G.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


G.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


G.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


G.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


G.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 G-2, "Analytics Dimension Tables (Prefixed ASDIM_WC)".

G.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 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.

 

G.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

 

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

 

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

 

NAME_

NULL

NVARCHAR2(254)

WebCenter Portal resource name, that is, the name of the discussion forum.

 

G.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 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

 

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

 

NAME_

NULL

NVARCHAR2(254)

WebCenter Portal resource name, that is, name of the announcement.

 

G.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 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.

 

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

 

NAME_

NULL

NVARCHAR2(254)

WebCenter Portal resource name, that is, the name of the space event.

 

G.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 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 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.

 

G.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 Portal resource name, that is, the name of the list.

 

RESOURCEID_

NOT NULL

NVARCHAR2(254)

WebCenter Portal resource ID.

 

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

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

 

NAME_

NULL

NVARCHAR2(254)

Name of the page.

 

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

 

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

 

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

 

NAME_

NULL

NVARCHAR2(254)

Producer name.

 

G.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

 

G.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.

 

G.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.

 

G.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.

 

G.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.

 

G.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.

 

G.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.

 

G.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.

 

G.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.

G.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.

 

G.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.

 

G.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


G.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


G.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.

 

G.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.

 

G.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.

 

G.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.

 

G.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)

 

G.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.

G.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.

 

G.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:

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

G.5.1 User Property Tables - Overview

Figure G-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 G-5 User Property Dimensions for Analytics

Description of Figure G-5 follows
Description of "Figure G-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.

G.5.2 User Property Dimension Tables

User property dimension tables are described in the following topics:

G.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.


G.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.)


G.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 G-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 G-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.

G.6 Analytics Event and Dimension Data Types

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

Table G-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