Oracle Analytics Best Practices: Oracle EPM Cloud as a Data Source for a Repository Subject Area

November 21, 2023 | 4 minute read
Anitha Ramarao
Consulting Solutions Architect
Srinivasa Pula
Consulting Member of Technical Staff
Ahmed Awan
Director, Customer Excellence, Analytics
Text Size 100%:

This is part of a series of  best practice blogs for Oracle Analytics.

Introduction

Connecting from Oracle Analytics to Oracle EPM Cloud for creating visualizations is quite straightforward.  Simply create a connection using the built-in connector, fill in the details, and start visualizing.

DV EPM Cloud Connector

Modeling Oracle EPM Cloud data in a subject area is a different matter.  To import Oracle EPM Cloud metadata into the repository (.rpd) requires additional configuration on the Windows desktop/laptop running Oracle Analytics Client Tools.

Prerequisites

You must have the following:

  • Latest version of JDK 1.8.
  • Oracle Analytics Client Tool version 6.4.
  • Connectivity from the desktop/laptop running Oracle Analytics Client Tools to Oracle EPM Cloud instance.

Once the prerequisites have been met, two steps need to be followed to copy the Oracle EPM Cloud metadata to the repository:

  1. Start the JavaHost.
  2. Import the metadata.

More detail on each of these steps follows.

Starting the JavaHost

The JavaHost needs to be up and running before beginning.  Start the JavaHost by running ..\bi\bifoundation\javahost\bin\startOnClient.bat.

Verify the JavaHost is available by running ..\bi\bifoundation\javahost\bin\stopOnClient.bat.  The following message is returned:

JavaHost Running

Importing the Metadata

Open the Model Administration Tool (admin tool) using the repository the metadata is to be imported into. 

Fill in the Import Metadata – Select Data Source screen.

  • For Connection Type select Hyperion ADM.
  • For Provider Type select Hyperion Planning.
  • In the URL, between the server and port nodes, ‘%3A’ must be used instead of ‘:’.

When using Oracle EPM Cloud as a data source, the URL is

adm:thin:com.hyperion.ap.hsp.HspAdmDriver:<Server>%3A<Port>:<Application>? locale=en_US;

When using Oracle EPM Freeform as a data source, the URL is:

adm:thin:com.hyperion.ap.hsp.HspAdmDriver:<Server>%3A<Port>:<Application>? locale=en_US;<tenantName=xxxxx>;<hubProtocol=yyyyy>;

Connection

Next, select the desired cube and import:

Importing Metadata

Click Finish:

Finished

The physical layer is now built.  Develop the business model and mapping and presentation layers as needed:

Physical Layer

Troubleshooting

  • The JavaHost is not running:

JavaHost not running

When looking at the logs in xxx_NQSAdminTool.log found in ..\Oracle_Home\domains\bi\servers\obis1\logs, the following error is seen:

[2023-08-08T13:15:23.354-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 459c]  [nQSError: 77029] Java Host is not available inside the function ADMImportService of SAW RPC modules. [[file: server\Utility\Generic\Src\SUServerLog.cpp; line: 767]]

[2023-08-08T13:15:23.420-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 459c]  [nQSError: 60001] Connection failed for: RemoteService-JavaHost-ADMImportService with message: [nQSError: 77029] Java Host is not available inside the function ADMImportService of SAW RPC modules.. [[file: server\Utility\Generic\Src\SUServerLog.cpp; line: 767]]

  • Proxy or firewall is blocking access to Oracle EPM Cloud:

Proxy Issue

  • The user trying to connect to Oracle EPM Cloud does not have access:

No Access

Call to Action

Setting up an Oracle EPM Cloud data source in a repository is a little trickier than setting up other data sources.  Hopefully, this article makes setup a little easier.

For more information about setting up a repository file (.rpd), see Managing Metadata Repositories for Oracle Analytics Server.

For more information about setting up connections in OAC, see Connecting Oracle Analytics Cloud to Your Data.

For performance tuning best practices when working with Oracle EPM Cloud, see Best Practices for Performance of Oracle Analytics Cloud with Enterprise Performance Management Cloud.

To learn more about Oracle Analytics, visit oracle.com/analytics, follow us on twitter@OracleAnalytics, and connect with us on LinkedIn.

Visit the Oracle Analytics Community site to ask questions and post ideas.

For more details, check the Help Center for Oracle Analytics.

 

Doug Marshik

Anitha Ramarao

Consulting Solutions Architect

Srinivasa Pula

Consulting Member of Technical Staff

Oracle Analytics Service Excellence, CEAL Team

Ahmed Awan

Director, Customer Excellence, Analytics


Previous Post

Embedded AI and ML capabilities in Oracle Analytics

Benjamin Arnulf | 5 min read

Next Post


Building a Marimekko chart in Oracle Analytics

Prasenjit Thakur | 9 min read