Skip Headers
Oracle® Fusion Middleware Modeling and Implementation Guide for Oracle Business Process Management
11g Release 1 (11.1.1.6.3)

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

Go to previous page
Previous
PDF · Mobi · ePub

B Integrating with Business Intelligence using Process Star Schema Views

This appendix describes how to integrate Oracle BPM with Business Intelligence using process star schema views. It also contains reference material for standard and process specific views.

This appendix contains these topics:

B.1 About Integrating Oracle BPM Process Star Schema with Business Intelligence (BI)

Oracle BPM provides process star schema views. These provide access to the BPM Process Cubes data and can be used by any external BI tool for analysis and reporting purposes.

If cubes are enabled, the the BPM process cubes is populated when BPMN Service engine runs the processes in your project. To view the data stored in these process star schema, you use the dashboards provided by Oracle Business Process Management Workspace.

For more information about generating process metrics, see Oracle Fusion Middleware Modeling and Implementation Guide for Oracle Business Process Management.

For information about how process metrics are displayed in Process Workspace, see Oracle Fusion Middleware User's Guide for Oracle Business Process Management.

Note:

Data in the process star schema is not permanent. It can be deleted as a result of process undeployment. It can result from data expiration configuration in Enterprise Manager. It can also result from executing a purge script to delete a large number of instances at a system level.

Oracle recommends that, for any historic analysis or reporting needs, process star schema data be pulled from a separate data warehouse at a periodic time interval.

Also, for performance reasons, Oracle recommends against analyzing data directly over process star schema views.

B.2 Standard Views

During Oracle BPM installation, standard facts and dimension views are created on top of the process star schema.

This section contains these topics:

B.2.1 Dimension Views

During installation, the following dimension views are created:

  • Process definition view

  • Activity defintion view

  • Role definition view

B.2.2 Standard Fact Views

Standard views contain information about standard metrics—for example, the cycle-time and the number of instances for such standard dimensions as process, activity, and participant. These views contain process and activity data about all available processes. Standard fact views are created during installation time.

Standard views are organized as follows:

B.2.2.1 Views Representing Fact Tables

Table B-1 lists and describes the standard fact views and their corresponding tables.

Table B-1 Standard Fact View Tables

View Description Table

Task Performance

Provides information on standard metrics for completed activities, completed intervals, measurement marks and counters for both in-flight and completed processes.

BPM_ACTIVITY_PERFORMANCE_V

Process Performance

Provides information on standard metrics for completed processes.

BPM_PROCESS_PERFORMANCE_V

Active Activity Instances

Provides information on standard metrics for in-flight activity and interval instances. This information is relevant only for the snapshot time at which the view is queried. As processes move forward, information in this view changes to reflect the new state.

BPM_ACTIVITY_INSTANCE_V

Active Process Instances

Provides information on standard metrics for in-flight process instances. This information is relevant only for the snapshot time at which the view is queried. As processes move forward, information in this view changes to reflect the new state.

BPM_PROCESS_INSTANCE_V


B.2.2.2 Views Representing Standard Dimension Tables

Table B-2 lists the standard dimension views and the corresponding tables.

Table B-2 Standard Dimension Views and Tables

View Table

Process

BPM_PROCESS_DEFINITION_V

Activity

BPM_ACTIVITY_DEFINITION_V

Role

BPM_ROLE_DEFINITION_V


Figure B-1 Process Star Schema for Standard Views

Shows the process star schema for standard views.

B.2.2.3 BPM_ACTIVITY_PERFORMANCE_V

BPM_ACTIVITY_PERFORMANCE_V is the standard task performance view.

B.2.2.3.1 Data Granularity

This view contains a record corresponding to each of the following for both in-flight and completed processes.

  • Completed process activities

  • Faulted process activities

  • Completed intervals

  • Measurement marks

  • Measurement counters

B.2.2.3.2 Unique Key

Following columns form the unique key for this view

  • SEQUENCE_ID

  • PROCESS_ID

  • ACTIVITY_ID

  • PROCESS_INSTANCE_ID

B.2.2.3.3 Metrics Information

Following metrics information is available as part of this view

  • ACTIVITY_START_TIME

  • ACTIVITY_END_TIME

  • ACTIVITY_RUNNING_TIME_IN_MSEC

Table B-3 BPM_ACTIVITY_PERFORMANCE_V

Column Name Data Type Description

SEQUENCE_ID

NUMBER

Numeric sequence

PROCESS_ID

NUMBER

process id. References BPM_PROCESS_DEFINTION_V.PROCESSID

PROCESS_NAME

VARCHAR2

Name of the process

REVISION

VARCHAR2

Revision of the process

ACTIVITY_ID

NUMBER

Activity Id. References BPM_ACTIVITY_DEFINTION_V.ACTIVITYID

ACTIVITY_LABEL

VARCHAR2

Activity Label

PROCESS_INSTANCE_ID

VARCHAR2

Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY

COMPOSITE_INSTANCE_ID

VARCHAR2

Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID

ACTIVITY_DISCRIMINATOR

VARCHAR2

Used for determining if this record corresponds to a faulted activity. For faulted task performance records, the value of this column is set to "INSTANCE_FAULT"

ACTIVITY_ROLE_ID

NUMBER

Role Id. References BPM_ROLE_DEFINTION_V.ROLEID

ACTIVITY_ROLE_NAME

VARCHAR2

Role Name associated with the activity instance

ACTIVITY_START_TIME

TIMESTAMP

Time at which activity instance started execution

ACTIVITY_END_TIME

TIMESTAMP

Time at which activity instance finished execution

ACTIVITY_RUNNING_TIME_IN_MSEC

NUMBER

Duration in millisecs for which activity instance executed

ACTIVITY_PARTICIPANT

VARCHAR2

Participant user associated with the activity instance

ACTIVITY_PRIORITY

NUMBER

Priority of activity instance (not available in PS2)

ECID

VARCHAR2

ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking


B.2.2.4 BPM_PROCESS_PERFORMANCE_V

BPM_PROCESS_PERFORMANCE_V is the standard process performance view.

B.2.2.4.1 Data Granularity

This view contains a record for the following

  • Completed Processes

  • Aborted Processes

  • Faulted Processes

B.2.2.4.2 Unique Key

Following columns form the unique key

  • SEQUENCE_ID

  • PROCESS_ID

  • PROCESS_INSTANCE_ID

B.2.2.4.3 Metrics Information

Following metrics information is available as part of this view

  • PROCESS_START_TIME

  • PROCESS_END_TIME

  • PROCESS_RUNNING_TIME_IN_MSEC

Table B-4 BPM_PROCESS_PERFORMANCE_V

Column Name Data Type Description

SEQUENCE_ID

NUMBER

Numeric sequence

PROCESS_ID

NUMBER

process id. References BPM_PROCESS_DEFINTION_V.PROCESSID

PROCESS_NAME

VARCHAR2

Name of the process

REVISION

VARCHAR2

Revision of the process

PROCESS_INSTANCE_ID

VARCHAR2

Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY

COMPOSITE_INSTANCE_ID

VARCHAR2

Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID

PROCESS_DISCRIMINATOR

VARCHAR2

Used for determining if this record corresponds to a faulted process. For faulted process performance records, the value of this column is set to "INSTANCE_SYSTEM_FAULT"

PROCESS_START_TIME

TIMESTAMP

Time at which process instance started execution

PROCESS_END_TIME

TIMESTAMP

Time at which process instance finished execution

PROCESS_RUNNING_TIME_IN_MSEC

NUMBER

Duration in millisecs for which process instance executed

ECID

VARCHAR2

ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking


B.2.2.5 BPM_ACTIVITY_INSTANCE_V

BPM_ACTIVITY_INSTANCE_V view provides information about each in-flight running activity instance across all processes.

B.2.2.5.1 Data Granularity

This view contains a record corresponding to each in-flight activity instance.

B.2.2.5.2 Unique Key

Following columns form the unique key for this view

  • SEQUENCE_ID

  • PROCESS_ID

  • ACTIVITY_ID

  • PROCESS_INSTANCE_ID

B.2.2.5.3 Metrics Information

Following metrics information is available as part of this view

  • ACTIVITY_START_TIME

  • PROCESS_START_TIME

Table B-5 BPM_ACTIVITY_INSTANCE_V

Column Name Data Type Description

SEQUENCE_ID

NUMBER

Numeric sequence

PROCESS_ID

NUMBER

process id. References BPM_PROCESS_DEFINTION_V.PROCESSID

PROCESS_NAME

VARCHAR2

Name of the process

REVISION

VARCHAR2

Revision of the process

ACTIVITY_ID

NUMBER

Activity Id. References BPM_ACTIVITY_DEFINTION_V.ACTIVITYID

ACTIVITY_LABEL

VARCHAR2

Activity Label

PROCESS_INSTANCE_ID

VARCHAR2

Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY

COMPOSITE_INSTANCE_ID

VARCHAR2

Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID

PROCESS_THREAD_ID

NUMBER

Thread id of Process thread executing the activity

ACTIVITY_ROLE_NAME

VARCHAR2

Role Name associated with the activity instance

ACTIVITY_PARTICIPANT

VARCHAR2

Participant user associated with the activity instance

ACTIVITY_PRIORITY

NUMBER

Priority of activity instance

ACTIVITY_START_TIME

TIMESTAMP

Time at which activity instance started execution

PROCESS_START_TIME

TIMESTAMP

Time at which process instance started execution

ECID

VARCHAR2

ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking


B.2.2.6 BPM_PROCESS_INSTANCE_V

BPM_PROCESS_INSTANCE_V view provides information about each in-flight process instance across all processes.

B.2.2.6.1 Data Granularity

This view contains a record corresponding to each in-flight process instance.

B.2.2.6.2 Unique Key

Following columns form the unique key for this view

  • SEQUENCE_ID

  • PROCESS_ID

  • PROCESS_INSTANCE_ID

B.2.2.6.3 Metrics Information

Following metrics information is available as part of this view

  • PROCESS_START_TIME

Table B-6 BPM_PROCESS_INSTANCE_V

Column Name Data Type Description

SEQUENCE_ID

NUMBER

Numeric sequence

PROCESS_ID

NUMBER

process id. References BPM_PROCESS_DEFINTION_V.PROCESSID

PROCESS_NAME

VARCHAR2

Name of the process

REVISION

VARCHAR2

Revision of the process

PROCESS_INSTANCE_ID

VARCHAR2

Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY

COMPOSITE_INSTANCE_ID

VARCHAR2

Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID

PROCESS_START_TIME

TIMESTAMP

Time at which process instance started execution

ECID

VARCHAR2

ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking


B.2.2.7 BPM_PROCESS_DEFINITION_V

BPM_PROCESS_DEFINITION_V view provides the information about BPMN processes.

Table B-7 BPM_PROCESS_DEFINITION_V

Column Name Data Type Description

PROCESSID

NUMBER

Process id.

PROCESSNAME

VARCHAR2

Name of the process

DOMAINNAME

VARCHAR2

Domain name

COMPOSITENAME

VARCHAR2

Composite name

REVISION

VARCHAR2

Composite Revision

SCALABEL

VARCHAR2

Composite SCA Label

COMPOSITEDN

VARCHAR2

Composite DN

LABEL

VARCHAR2

Process Label (BPMN NAME)

PROCESSTYPE

VARCHAR2

Type of the process (e.g. 'BPMN' etc)

STATUS

SMALLINT

Process deployment status. " 1" = Deployed "-1" = Undeployed

UNDEPLOYDATE

TIMESTAMP

Process undeployment date


B.2.2.8 BPM_ACTIVITY_DEFINITION_V

BPM_ACTIVITY_DEFINITION_V view provides the information about activities corresponding to all available BPMN processes.

Table B-8 BPM_ACTIVITY_DEFINITION_V

Column Name Data Type Description

ACTIVITYID

NUMBER

Activity id.

PROCESSID

NUMBER

Process Id. Refers to BPM_PROCESS_DEFINTION_V.PROCESSID

ACTIVITYNAME

VARCHAR2

Name of the Activity (BPMN ID)

ACTIVITYTYPE

VARCHAR2

Type of activity (UserTask, Gateway, Event, Measurement Interval etc.)

LABEL

VARCHAR2

Activity label (BPMN NAME)


B.2.2.9 BPM_ROLE_DEFINITION_V

BPM_ROLE_DEFINITION_V view provides the information about roles corresponding to all available BPMN processes

Table B-9 BPM_ROLE_V

Column Name Data Type Description

ROLEID

NUMBER

Role id.

PROCESSID

NUMBER

Process Id. Refers to BPM_PROCESS_DEFINTION_V.PROCESSID

ROLENAME

VARCHAR2

Role name

APPROLENAME

VARCHAR2

Application role name

LABEL

VARCHAR2

Role Label

ISPROCESSOWNER

VARCHAR2

Is process owner (Y/N)


B.3 Process-Specific Views

To capture any business dimensions and measures specified for a given Oracle BPM project, you must create views specific to each process.

A process-specific view provides access to data across all corresponding process versions. It has columns for business indicators across all process versions.

For a given process, Oracle Business Process Management resolves all business indicators to their corresponding flex columns across all process versions. It then creates all the process-specific views.

When a BPMN process is deployed, the corresponding process-specific views are created.

When a BPMN process is undeployed, the corresponding process specific views are either:

These views use the following naming convention:

Table B-10

View Table

Task Performance

BPM_ACTV_PERF_<IDENTIFIER>_V

Process Performance

BPM_PRCS_PERF_< IDENTIFIER >_V

Active Activity Instances

BPM_ACTV_INST_<IDENTIFIER>_V

Active Process Instances

BPM_PRCS_INST_<IDENTIFIER>_V


Note:

  • IDENTIFIER is the analytics view identifier defined for a BPMN process during design time. It has a maximum length of 10. If "Analytics View Identifier" is not defined for a process, then process-specific views are not created for that process.

    You can define an analytics view identifier for a BPMN process in Oracle BPM Studio.

  • In Oracle BPM Studio, the length of the business indicator name cannot exceed 28 characters.

Figure B-2 Process Star Schema for Process-Specific Views

Shows process star schema for process-specific views.

B.3.1 BPM_ACTV_PERF_<IDENTIFIER>_V

BPM_ACTV_PERF_<IDENTIFIER>_V is the process specific task performance view.

B.3.1.1 Data Granularity

This view contains a record corresponding to each of the following for both in-flight and completed processes.

  • Completed activities

  • Faulted activities

  • Completed intervals

  • Measurement marks

  • Measurement counters

B.3.1.2 Unique Key

Following columns form the unique key for this view

  • SEQUENCE_ID

  • PROCESS_ID

  • ACTIVITY_ID

  • PROCESS_INSTANCE_ID

B.3.1.3 Metrics Information

Following metrics information is available as part of this view

  • ACTIVITY_START_TIME

  • ACTIVITY_END_TIME

  • ACTIVITY_RUNNING_TIME_IN_MSEC

  • All Business indicator values as of activity end time.

Table B-11 BPM_ACTV_PERF_<IDENTIFIER>_V

Column Name Data Type Description

SEQUENCE_ID

NUMBER

Numeric sequence

PROCESS_ID

NUMBER

Process id. References BPM_PROCESS_DEFINTION_V.PROCESSID

PROCESS_NAME

VARCHAR2

Name of the process

REVISION

VARCHAR2

Revision of the process

ACTIVITY_ID

NUMBER

Activity Id. References BPM_ACTIVITY_DEFINTION_V.ACTIVITYID

ACTIVITY_LABEL

VARCHAR2

Activity Label

PROCESS_INSTANCE_ID

VARCHAR2

Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY

COMPOSITE_INSTANCE_ID

VARCHAR2

Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID

PROCESS_THREAD_ID

VARCHAR2

Id of the thread executing the activity. Parallel activities in a process are executed by different thread and hence will have different thread id.

ACTIVITY_DISCRIMINATOR

VARCHAR2

Used for determining if this record corresponds to a faulted activity. For faulted task performance records, the value of this column is set to "INSTANCE_FAULT". For counter records, the value of this column is set to 'MEASUREMENT_COUNTER'

ACTIVITY_ROLE_ID

NUMBER

Role Id. References BPM_ROLE_DEFINTION_V.ROLEID

ACTIVITY_ROLE_NAME

VARCHAR2

Role Name associated with the activity instance

ACTIVITY_START_TIME

TIMESTAMP

Time at which activity instance started execution

ACTIVITY_END_TIME

TIMESTAMP

Time at which activity instance finished execution

ACTIVITY_RUNNING_TIME_IN_MSEC

NUMBER

Duration in millisecs for which activity instance executed

ACTIVITY_PARTICIPANT

VARCHAR2

Participant user associated with the activity instance

ACTIVITY_PRIORITY

NUMBER

Priority of activity instance

ECID

VARHCAR2

ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking

D_<dimension1…n>

VARCHAR2 / NUMBER / TIMESTAMP

Dimension business indicators associated with the activity instance. These may indirectly refer to some functional tables

R_<dimension1…n>

VARCHAR2

Range information corresponding to numeric/date type dimension business indicators associated with the activity instance

M_<measure1…n>

NUMBER

Measure business indicators associated with the activity instance

C_<counter1…n>

NUMBER

Counter business indicator associated with the activity instance


B.3.2 BPM_PRCS_PERF_< IDENTIFIER >_V

BPM_PRCS_PERF_< IDENTIFIER >_V is the process specific process performance view.

B.3.2.1 Data Granularity

This view contains a record for the following

  • Completed Processes

  • Aborted Processes

  • Faulted Processes

B.3.2.2 Unique Key

Following columns form the unique key

  • SEQUENCE_ID

  • PROCESS_ID

  • PROCESS_INSTANCE_ID

B.3.2.3 Metrics Information

Following metrics information is available as part of this view

  • PROCESS_START_TIME

  • PROCESS_END_TIME

  • PROCESS_RUNNING_TIME_IN_MSEC

  • All Business indicator values as of process end time.

Table B-12 BPM_PRCS_PERF_< IDENTIFIER >_V

Column Name Data Type Description

SEQUENCE_ID

NUMBER

Numeric sequence

PROCESS_ID

NUMBER

Process id. References BPM_PROCESS_DEFINTION_V.PROCESSID

PROCESS_NAME

VARCHAR2

Name of the process

REVISION

VARCHAR2

Revision of the process

PROCESS_INSTANCE_ID

VARCHAR2

Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY

COMPOSITE_INSTANCE_ID

VARCHAR2

Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID

PROCESS_DISCRIMINATOR

VARCHAR2

Used for determining if this record corresponds to a faulted process. For faulted process performance records, the value of this column is set to "INSTANCE_SYSTEM_FAULT"

PROCESS_START_TIME

TIMESTAMP

Time at which process instance started execution

PROCESS_END_TIME

TIMESTAMP

Time at which process instance finished execution

PROCESS_RUNNING_TIME_IN_MSEC

NUMBER

Duration in millisecs for which process instance executed

ECID

VARCHAR2

ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking

D_<dimension1…n>

VARCHAR2 / NUMBER / TIMESTAMP

Dimension business indicators associated with the process instance. These may indirectly refer to some functional tables

R_<dimension1…n>

VARCHAR2

Range information corresponding to numeric/date type dimension business indicators associated with the process instance

M_<measure1…n>

NUMBER

Measure business indicators associated with instance


B.3.3 BPM_ACTV_INST_<IDENTIFIER>_V

BPM_ACTV_INST_<IDENTIFIER>_V view provides information about each in-flight running activity instance corresponding to a particular process.

B.3.3.1 Data Granularity

This view contains a record corresponding to each in-flight activity and interval instance.

B.3.3.2 Unique Key

Following columns form the unique key for this view

  • SEQUENCE_ID

  • PROCESS_ID

  • ACTIVITY_ID

  • PROCESS_INSTANCE_ID

B.3.3.3 Metrics Information

Following metrics information is available as part of this view

  • ACTIVITY_START_TIME

  • PROCESS_START_TIME

  • Business indicator values as of activity start time.

Table B-13 BPM_ACTV_INST_<IDENTIFIER>_V

Column Name Data Type Description

SEQUENCE_ID

NUMBER

Numeric sequence

PROCESS_ID

NUMBER

Process id. References BPM_PROCESS_DEFINTION_V.PROCESSID

PROCESS_NAME

VARCHAR2

Name of the process

REVISION

VARCHAR2

Revision of the process

ACTIVITY_ID

NUMBER

Activity Id. References BPM_ACTIVITY_DEFINTION_V.ACTIVITYID

ACTIVITY_LABEL

VARCHAR2

Activity Label

PROCESS_INSTANCE_ID

VARCHAR2

Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY

COMPOSITE_INSTANCE_ID

VARCHAR2

Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID

PROCESS_THREAD_ID

NUMBER

Thread id of Process thread executing the activity

ACTIVITY_ROLE_NAME

VARCHAR2

Role Name associated with the activity instance

ACTIVITY_PARTICIPANT

VARCHAR2

Participant user associated with the activity instance

ACTIVITY_PRIORITY

NUMBER

Priority of activity instance

ACTIVITY_START_TIME

TIMESTAMP

Time at which activity instance started execution

PROCESS_START_TIME

TIMESTAMP

Time at which process instance started execution

ECID

VARCHAR2

ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking

D_<dimension1…n>

VARCHAR2 / NUMBER / TIMESTAMP

Dimension business indicators associated with the activity instance. These may indirectly refer to some functional tables

R_<dimension1…n>

VARCHAR2

Range info for numeric/date type dimensions

M_<measure1…n>

NUMBER

Measure Bis associated with the activity instance


B.3.4 BPM_PRCS_INST_<IDENTIFIER>_V

BPM_PRCS_INST_<IDENTIFIER>_V view provides information about each in-flight running process instance corresponding to a particular process.

B.3.4.1 Data Granularity

This view contains a record corresponding to each in-flight process instance.

B.3.4.2 Unique Key

Following columns form the unique key for this view

  • SEQUENCE_ID

  • PROCESS_ID

  • PROCESS_INSTANCE_ID

B.3.4.3 Metrics Information

Following metrics information is available as part of this view

  • PROCESS_START_TIME

  • Business indicator values as of process start time.

Table B-14 BPM_PRCS_INST_<IDENTIFIER>_V

Column Name Data Type Description

SEQUENCE_ID

NUMBER

Numeric sequence

PROCESS_ID

NUMBER

Process id. References BPM_PROCESS_DEFINTION_V.PROCESSID

PROCESS_NAME

VARCHAR2

Name of the process

REVISION

VARCHAR2

Revision of the process

PROCESS_INSTANCE_ID

VARCHAR2

Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY

COMPOSITE_INSTANCE_ID

VARCHAR2

Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID

PROCESS_START_TIME

TIMESTAMP

Time at which process instance started execution

ECID

VARCHAR2

ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking

D_<dimension1…n>

VARCHAR2 / NUMBER / TIMESTAMP

Dimension business indicators associated with the activity instance. These may indirectly refer to some functional tables

R_<dimension1…n>

VARCHAR2

Range info for numeric/date type dimensions

M_<measure1…n>

NUMBER

Measure Business indicators associated with the activity instance