Oracle® Fusion Middleware Developer's Guide for Oracle WebCenter Portal 11g Release 1 (11.1.1.7.0) Part Number E10148-20 |
|
|
PDF · Mobi · ePub |
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:
This section contains the following topics:
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.
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
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.
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.
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 |
Stores event information captured by the Analytics service when a page is created. |
|
Stores event information captured by the Analytics service when a page is deleted. |
||
Stores event information captured by the Analytics service when a page is edited. |
||
Stores event information captured by the Analytics service when a page is tagged. |
||
Stores event information captured by the Analytics service when a page is viewed. |
||
Discussions |
Stores event information captured by the Analytics service when a discussion topic is viewed. |
|
Stores event information captured by the Analytics service when an announcement is viewed. |
||
Stores event information captured by the Analytics service when a discussion forum is created. |
||
Stores event information captured by the Analytics service when a discussion forum is deleted. |
||
Stores event information captured by the Analytics service when a discussion topic is created. |
||
Stores event information captured by the Analytics service when a discussion topic is edited. |
||
Stores event information captured by the Analytics service when a discussion topic is deleted. |
||
Stores event information captured by the Analytics service when a discussion topic is tagged. |
||
Stores event information captured by the Analytics service when someone replies to a discussion topic message. |
||
Stores event information captured by the Analytics service when a discussion topic message is liked. |
||
Stores event information captured by the Analytics service when an announcement is created. |
||
Stores event information captured by the Analytics service when an announcement is edited. |
||
Stores event information captured by the Analytics service when an announcement is deleted. |
||
Documents - Blog - Wikis |
Stores event information captured by the Analytics service when a document is viewed. |
|
Stores event information captured by the Analytics service when a document is downloaded. |
||
Stores event information captured by the Analytics service when a document is created. |
||
Stores event information captured by the Analytics service when a document is edited. |
||
Stores event information captured by the Analytics service when a document is tagged. |
||
Stores event information captured by the Analytics service when a document is liked. |
||
Stores event information captured by the Analytics service when a document is commented. |
||
Stores event information captured by the Analytics service when a document is deleted. |
||
Space Events |
Stores event information captured by the Analytics service when a space event is created. |
|
Stores event information captured by the Analytics service when a space event is deleted. |
||
Stores event information captured by the Analytics service when a space event is edited. |
||
Spaces |
Stores event information captured by the Analytics service when a space is viewed. |
|
Stores event information captured by the Analytics service when a space is created. |
||
Stores event information captured by the Analytics service when someone joins a space. |
||
Stores event information captured by the Analytics service when a space is deleted. |
||
Lists |
Stores event information captured by the Analytics service when a list is created. |
|
Stores event information captured by the Analytics service when a list is deleted. |
||
Stores event information captured by the Analytics service when a list is edited. |
||
Logins |
Stores event information captured by the Analytics service when a user logs in to the site. |
|
People |
Stores event information captured by the Analytics service when someone adds a connection. |
|
Stores event information captured by the Analytics service when someone posts on a wall. |
||
Stores event information captured by the Analytics service when someone edits a profile. |
||
Stores event information captured by the Analytics service when someone edits status information. |
||
Portlets |
Stores event information captured by the Analytics service when a portlet is viewed. |
|
Searches |
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 |
Stores names of WebCenter Portal applications accessing analytics data. |
|
IP Clients |
Stores client IP addresses received in analytics events. |
|
Discussion Topics |
Stores discussion topic details received in analytics events. |
|
Discussion Forums |
Stores discussion forum details received in analytics events. |
|
Discussion Messages |
Stores discussion message details received in analytics events. |
|
Announcements |
Stores announcement details received in analytics events. |
|
Documents |
Stores document details received in analytics events. |
|
Lists |
Stores list details received in analytics events. |
|
Pages |
Stores WebCenter Portal page details received in analytics events. |
|
Portlets |
Stores portlet information received in analytics events. |
|
Portlet Instances |
Stores portlet instance information received in analytics events. |
|
Portlet Producers |
Stores producers associated with portlet. |
|
Referrers |
Stores referred URLs where analytics events come from. |
|
Searches |
Stores search phrases received in analytics events. |
|
Space Events |
Stores space event details, received in analytics events. |
|
Spaces |
Stores space information received in analytics events. |
|
Tags |
Stores tags received in analytics events. |
|
Browsers |
Stores information about which browsers are used to access analytics. |
|
Times |
Stores times used to group analytics reports. |
|
Users |
Stores user details received in analytics events. |
|
User Properties |
Stores user properties. |
|
User Property Values |
Stores user property values. |
Table G-3 Analytics System Tables (Prefixed ASSYS)
Entity Name | Table Name | Table Description |
---|---|---|
Configuration |
Stores system configuration details. |
|
Dimension Properties |
Stores configuration details for each dimension. |
|
Event Dimensions |
Stores dimensions associated with each event. |
|
Event Facts |
Stores facts associated with each event. |
|
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 |
Stores the namespace in which analytics events are registered. |
|
Report Composition |
Stores out-of-the-box composite analytics reports. |
|
Report Group |
Stores out-of-the-box analytics report groups, such as portlets, services, and so on. |
|
Report Items |
Stores items included in each analytics report. |
|
Report Item Values |
Stores values associated with each item in an analytics report. |
|
Reports |
Stores out-of-the-box analytics reports. |
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
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)".
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. |
|
PAGE_ |
NULL |
NUMBER(38) |
Page ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
PAGE_ |
NULL |
NUMBER(38) |
Page ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
PAGE_ |
NULL |
NUMBER(38) |
Page ID dimension. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
TAG_ |
NULL |
NUMBER(38) |
Tag ID dimension. |
|
PAGE_ |
NULL |
NUMBER(38) |
Page ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
RESPONSE_TIME_ |
NULL |
NUMBER(16) |
Response time (ms). |
|
CLIENT_IP_ |
NULL |
NUMBER(38) |
Client IP ID dimension. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
REFERRER_ |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
PAGE_ |
NULL |
NUMBER(38) |
Page ID dimension. |
|
USER_AGENT_ |
NULL |
NUMBER(38) |
User agent. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
CLIENT_IP_ |
NULL |
NUMBER(38) |
Client IP ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
USER_AGENT_ |
NULL |
NUMBER(38) |
User agent. |
|
FORUM_ |
NULL |
NUMBER(38) |
Discussion forum associated with the event. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID. |
|
TOPIC_ |
NULL |
NUMBER(38) |
Discussion topic associated with the event. |
|
REFERRER_ |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
CLIENT_IP_ |
NULL |
NUMBER(38) |
Client IP ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
REFERRER_ |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
USER_AGENT_ |
NULL |
NUMBER(38) |
User agent. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID. |
|
ANNOUNCEMENT_ |
NULL |
NUMBER(38) |
Announcement associated with the event. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
DISCUSSION_FORUM_ |
NULL |
NUMBER(38) |
Discussion forum ID dimension. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
DISCUSSION_FORUM_ |
NULL |
NUMBER(38) |
Discussion forum ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
DISCUSSION_TOPIC_ |
NULL |
NUMBER(38) |
Discussion topic ID dimension. |
|
DISCUSSION_MESSAGE_ |
NULL |
NUMBER(38) |
Discussion message ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
DISCUSSION_TOPIC_ |
NULL |
NUMBER(38) |
Discussion topic ID dimension. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
DISCUSSION_TOPIC_ |
NULL |
NUMBER(38) |
Discussion topic ID dimension. |
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. |
|
TAG_ |
NULL |
NUMBER(38) |
Tag ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
DISCUSSION_TOPIC_ |
NULL |
NUMBER(38) |
Discussion topic ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
DISCUSSION_MESSAGE_ |
NULL |
NUMBER(38) |
Discussion message ID dimension. |
|
DISCUSSION_TOPIC_ |
NULL |
NUMBER(38) |
Discussion topic ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
DISCUSSION_MESSAGE_ |
NULL |
NUMBER(38) |
Discussion message ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
DISCUSSION_TOPIC_ |
NULL |
NUMBER(38) |
Discussion topic ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
DISCUSSION_ANNOUNCEMENT_ |
NULL |
NUMBER(38) |
Announcement ID dimension. |
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. |
|
DISCUSSION_ANNOUNCEMENT_ |
NULL |
NUMBER(38) |
Announcement ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
DISCUSSION_FORUM_ |
NULL |
NUMBER(38) |
Discussion forum ID dimension. |
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. |
|
RESPONSE_TIME_ |
NULL |
NUMBER(16) |
Response Time (ms). |
|
CLIENT_IP_ |
NULL |
NUMBER(38) |
Client IP ID dimension. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID. |
|
GROUPSPACE |
NULL |
NUMBER(38) |
Space ID dimension. |
|
REFERRER |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
DOCUMENT |
NULL |
NUMBER(38) |
Document ID dimension. |
|
USER_AGENT |
NULL |
NUMBER(38) |
User agent. |
|
APPLICATION |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
DOCUMENT |
NULL |
NUMBER(38) |
Document ID dimension. |
|
REFERRER_ |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
CLIENT_IP_ |
NULL |
NUMBER(38) |
Client IP ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
USER_AGENT_ |
NULL |
NUMBER(38) |
User agent. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
WEBCENTER_RESOURCE_ |
NULL |
NUMBER(38) |
WebCenter Portal resource ID. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
WEBCENTER_RESOURCE_ |
NULL |
NUMBER(38) |
WebCenter Portal resource ID. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
TAGS |
NULL |
NUMBER(38) |
Tag added to the document. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
WEBCENTER_RESOURCE_ |
NULL |
NUMBER(38) |
WebCenter Portal resource ID. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
WEBCENTER_RESOURCE_ |
NULL |
NUMBER(38) |
WebCenter Portal resource ID. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
WEBCENTER_RESOURCE_ |
NULL |
NUMBER(38) |
WebCenter Portal resource ID. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
WEBCENTER_RESOURCE_ |
NULL |
NUMBER(38) |
WebCenter Portal resource ID. |
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. |
|
EVENT_ |
NULL |
NUMBER(38) |
Event Identifier. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
EVENT_ |
NULL |
NUMBER(38) |
Event Identifier. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
EVENT_ |
NULL |
NUMBER(38) |
Event Identifier. |
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. |
|
CLIENT_IP_ |
NULL |
NUMBER(38) |
Client IP ID dimension. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID. |
|
RESPONSE_TIME_ |
NULL |
NUMBER(16) |
Response time (ms). |
|
REFERRER_ |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
USER_AGENT_ |
NULL |
NUMBER(38) |
User agent. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
LIST_ |
NULL |
NUMBER(38) |
List ID. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
LIST_ |
NULL |
NUMBER(38) |
List ID. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
LIST_ |
NULL |
NUMBER(38) |
List ID. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID |
|
USER_AGENT_ |
NULL |
NUMBER(38) |
User agent. |
|
REFERRER_ |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
CLIENT_IP_ |
NULL |
NUMBER(38) |
Client IP ID dimension. |
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. |
|
TARGET_USER |
NULL |
NUMBER(38) |
User ID |
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. |
|
TARGET_USER |
NULL |
NUMBER(38) |
User ID. |
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. |
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. |
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. |
|
CACHED_ |
NULL |
NUMBER(5) |
Indicates whether the portlet was displayed from the cache. |
|
PORTLET_ |
NULL |
NUMBER(38) |
Portlet. |
|
REFERRER_ |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
PRODUCER_ |
NULL |
NUMBER(38) |
Portlet producer. |
|
PAGE_ |
NULL |
NUMBER(38) |
Page ID dimension. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID. |
|
CLIENT_IP |
NULL |
NUMBER(38) |
Client IP ID dimension. |
|
PORTLET_INSTANCE_ |
NULL |
NUMBER(38) |
Portlet instance. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
|
RESPONSE_TIME_ |
NULL |
NUMBER(16) |
Response time (ms). |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
USER_AGENT_ |
NULL |
NUMBER(38) |
User agent. |
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. |
|
PAGE_ |
NULL |
NUMBER(38) |
Page ID dimension. |
|
USER_AGENT_ |
NULL |
NUMBER(38) |
User agent. |
|
CLIENT_IP_ |
NULL |
NUMBER(38) |
Client IP ID dimension. |
|
APPLICATION_ |
NULL |
NUMBER(38) |
Application ID dimension. |
|
SESSION_ID_ |
NULL |
NVARCHAR2(254) |
Session ID. |
|
REFERRER_ |
NULL |
NUMBER(38) |
Referrer ID dimension. |
|
SEARCHED_PHRASE |
NULL |
NUMBER(38) |
Search phrase. |
|
GROUPSPACE_ |
NULL |
NUMBER(38) |
Space ID dimension. |
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)".
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. |
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 |
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. |
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. |
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 |
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. |
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):
|
|
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. |
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. |
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. |
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. |
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, |
|
NAME_ |
NULL |
NVARCHAR2(254) |
Name of the page. |
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. |
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. |
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. |
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 |
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. |
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. |
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. |
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. |
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: |
|
CREATED |
NOT NULL |
DATE |
Date record created. |
|
LASTMODIFIED |
NOT NULL |
DATE |
Date record last modified. |
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. |
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. |
|
VALUE |
NULL |
NVARCHAR2(255) |
Property ID value. |
|
TYPE |
NULL |
NUMBER(38) |
Property type. |
System tables are created during installation to store application information such as system configuration parameters. Each table is described in this section.
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. |
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. |
|
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. |
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 |
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. |
|
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. |
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. |
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. |
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. |
|
CHILDREPORTID |
NOT NULL |
NUMBER(38) |
Reference to child report 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. |
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. |
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. |
|
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. |
|
EVENTDIMENSIONNAME |
NULL |
NVARCHAR2(510) |
Dimension name. |
|
EVENTFACTID |
NULL |
NUMBER(38) |
Event fact 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) |
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. |
|
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.
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. |
|
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) |
|
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. |
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."
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
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.
User property dimension tables are described in the following topics:
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. |
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.) |
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.
Table G-5 shows how analytics event and dimension data types map to data types in Oracle, Microsoft SQL Server, and IBM DB2 databases.