When you install Essbase with Oracle Business Intelligence, you do not perform a full Enterprise Performance Management System installation. Therefore, instructions for completing certain tasks can be different to those documented in the EPM documentation.
Use the table below to help you decide what to use to perform certain tasks in Oracle Business Intelligence compared to EPM systems, and which guides to reference.
| Essbase-Related Tasks Performed in Oracle BI and EPM Systems | How to Perform Essbase-Related Tasks in an Oracle BI System and Which Guides to Reference | How to Perform Essbase-Related Tasks in an 11g EPM System and Which Guides to Reference |
|---|---|---|
|
Authentication |
Essbase should be setup as part of the installation process and all security in the 12.2.1 release should be handled automatically through the BI security. Refer to EPM 11g guides. |
When using an 11g EPM system, use HSS, MaxL. Refer to EPM guides. |
|
Authorization |
Essbase should be setup as part of the installation process and all security in the 12.2.1 release should be handled automatically through the BI security. Refer to EPM 11g guides. |
When using an 11g EPM system, use HSS, MaxL. Refer to EPM guides. |
|
Data Security (Provisioning) |
When using Essbase and associated tools installed with Oracle Business Intelligence, use Fusion Middleware Control and Security. Refer to EPM 11g guides. Note: There is no need to define Essbase filters for row level security; it is handled by BI security privileges. Filters will need to be created for Essbase when there is a 12c cube that will be accessed directly by the user, non-acceleration cubes. |
When using an 11g EPM system, use HSS. Refer to EPM guides. |
|
Data Security (filter definitions) |
When using Essbase installed with Oracle Business Intelligence, use MaxL. Refer to EPM 11g guides. There is no need to define Essbase filters for row level security; it is handled by BI security privileges. Filters will need to be created for Essbase when there is a 12c cube that will be accessed directly by the user, non-acceleration cubes. |
When using an 11g EPM system, use EAS (GUI) or Maxl (Command Line). Refer to EPM guides. |
|
System Configuration |
When using Essbase and associated tools installed with Oracle Business Intelligence, use Fusion Middleware Control, and essbase.cfg. Refer to Oracle Business Intelligence guides. |
When using an 11g EPM system, use a text editor and MaxL, essbase.cfg. Refer to EPM guides (for EAS and Studio). |
|
Backup and Recovery |
When using Essbase and associated tools installed with Oracle Business Intelligence use Fusion Middleware Control. Refer to Administering Oracle Fusion Middleware and Oracle Business Intelligence guides. |
Refer to EPM guides (see also for backing up Studio). |
|
Migration (Test to Production) |
Migration should use a file system copy for artifacts while partitions, CDF/M, security filters and data should be exported via Maxl for EPM column. |
Refer to Lifecycle Management guides. |
|
Essbase cubes |
When using Essbase you use the Acceleration Wizard. |
Build and manage cubes using EAS and Studio. Refer to EPM guides (references to EAS and Studio). Refer to Oracle Essbase Database Administrator's Guide. |
|
Capacity |
N/A, Uses Active/Passive model (one cluster only). Refer to Oracle Business Intelligence guides. |
Use N Clusters 1, 2, 3, 4 agents. Uses the Active/Active or Active/Passive model. Refer to EPM guides. |
|
Availability |
Use Fusion Middleware Control. Uses - Active/Passive model. Refer to Oracle Business Intelligence guides. |
Refer to EPM guides. Uses Active/Passive model. |
|
Financial Reporting |
Financial Reports, Calculation Manager and Workspace are not part of the 12c deployment. |
Refer to EPM guides. |
|
Calculation Manager |
Financial Reports, Calculation Manager and Workspace are not part of the 12c deployment. |
Refer to EPM guides. |
|
Workspace |
Financial Reports, Calculation Manager and Workspace are not part of the 12c deployment. |
Refer to EPM guides. |
|
APIs |
No need for custom API work in 12.2.1. |
NA |