A Process Star Schema Views
Process Star schema data objects are created in BAM 12c. You can use Oracle SQL to access Process Star schema data objects by their database view synonyms. You can then use the views to integrate a Process Star schema with any external business intelligence tool. You can use the BAM 12c composer to browse the individual columns of the Process Star schema data objects.
Standard Data Objects
The following table lists each of the standard physical data objects and its corresponding database view synonym name.
Table A-1 Standard Data Objects to DB View Synonym Name Mapping
| Sno | Display Name | Internal Name | DB View Synonym Name | Star Schema Member Type |
|---|---|---|---|---|
|
1 |
oracle/processanalytics/internal/physical/Composite Definition (physical) |
ORACLE_PROCESSANALYTICS_COMPOSITE_DEFINITION |
BPM_PV_COMPOSITE_DEFINITION_V |
Dimension |
|
2 |
oracle/processanalytics/internal/physical/Process Definition (physical) |
ORACLE_PROCESSANALYTICS_PROCESS_DEFINITION |
M_PV_PROCESS_DEFINITION_V |
Dimension |
|
3 |
oracle/processanalytics/internal/physical/Activity Definition (physical) |
ORACLE_PROCESSANALYTICS_ACTIVITY_DEFINITIO |
BPM_PV_ACTIVITY_DEFINITION_V |
Dimension |
|
4 |
oracle/processanalytics/internal/physical/Role Definition (physical) |
ORACLE_PROCESSANALYTICS_ROLE_DEFINITION |
PM_PV_ROLE_DEFINITION_V |
Dimension |
|
5 |
oracle/processanalytics/internal/physical/CM Case Activity Definition |
ORACLE_PROCESSANALYTICS_CASE_ACTIVITY_DEF |
BPM_PV_CASE_ACTIVITY_DEF_V |
Dimension |
|
6 |
oracle/processanalytics/internal/physical/CM Case Definition |
ORACLE_PROCESSANALYTICS_CASE_DEFINITION |
N/A |
Dimension |
|
7 |
oracle/processanalytics/internal/physical/HWF Task Definition |
ORACLE_PROCESSANALYTICS_TASK_DEFINITION |
BPM_PV_HWF_TASK_DEFINITION_V |
Dimension |
|
8 |
oracle/processanalytics/internal/physical/Process (physical) |
ORACLE_PROCESSANALYTICS_PROCESS |
BPM_PV_PROCESS_V |
Fact |
|
9 |
oracle/processanalytics/internal/physical/Activity (physical) |
ORACLE_PROCESSANALYTICS_ACTIVITY |
BPM_PV_ACTIVITY_V |
Fact |
|
10 |
oracle/processanalytics/internal/physical/HWF Assignment (physical) |
ORACLE_PROCESSANALYTICS_ASSIGNMENT |
BPM_PV_HWF_ASSIGNMENT_V |
Fact |
|
11 |
oracle/processanalytics/internal/physical/HWF Task (physical) |
ORACLE_PROCESSANALYTICS_TASK |
BPM_PV_HWF_TASK_V |
Fact |
|
12 |
oracle/processanalytics/internal/physical/CM Case |
ORACLE_PROCESSANALYTICS_CASE |
BPM_PV_CASE_V |
Fact |
|
13 |
Oracle/processanalytics/internal/physical/CM Case Activity |
ORACLE_PROCESSANALYTICS_CASE_ACTIVITY |
BPM_PV_CASE_ACTIVITY_V |
Fact |
|
14 |
oracle/processanalytics/internal/physical/CM Case Stake Holder |
ORACLE_PROCESSANALYTICS_CASE_STAKE_HOLDER |
BPM_PV_CASE_STAKE_HOLDER_V |
Fact |
|
15 |
oracle/processanalytics/internal/physical/CM Case Stake Holder Member |
ORACLE_PROCESSANALYTICS_CASE_STAKE_HOLDER_MEMBER |
BPM_PV_CASE_STAKE_HOLDER_MEM_V |
Fact |
Composite-Specific Data Objects
The following table lists each of the composite-specific physical data objects and its corresponding database view synonym name. If you enable the BAM 12c analytics data target, then composite-specific data objects are created when the composite is deployed.
Note:
<In the following table, <COMPOSITENAME> is the composite name truncated to 70 chars, and <IDENTIFIER> is the analytics view identifier specified for the composite.
The maximum is 10 chars. No database view synonyms are created when the analytics view identifier is not specified for a composite.
Table A-2 Composite-Specific Data Objects to DB View Synonym Mapping
| Sno | Display Name | Internal Name | DB View Synonym Name | Star Schema Member Type |
|---|---|---|---|---|
|
1 |
oracle/processanalytics/internal/physical/<COMPOSITE NAME> Process (physical) |
ORACLE_PROCESSANALYTICS_<COMPOSITENAME>_PROCESS |
BPM_PV_PRCS_<IDENTIFIER>_V |
Fact |
|
2 |
oracle/processanalytics/internal/physical/<COMPOSITE NAME> Activity (physical |
ORACLE_PROCESSANALYTICS_<COMPOSITENAME>_ACTIVITY |
BPM_PV_ACTV_<IDENTIFIER>_V |
Fact |