Skip to main content

Connecting to multiple Oracle Cloud Environments


Connect to multiple EPBCS environments via Smart View Shared Connections XML

Switching environments, changing domains, logging in, logging out…

Why not save valuable time by creating a Smart View environments short-cut?


Shared Connections Drop Down List


Here’s how!
First, gather the following details for each environment that you would like to add to your drop-down list:

1. Environment URL (PBCS/EPBCS)
Recently provisioned environments:
https://epm-exampleDoM.epm.exampleDC.oraclecloud.com/HyperionPlanning/SmartView

Environments provisioned before 2020:
(If unsure, check your web URL - does it start with planning or epm, match URL)
https://planning-exampleDoM.pbcs.exampleDC.oraclecloud.com/HyperionPlanning/SmartView

            (where Domain name = exampleDoM and Data centre = exampleDC)


2. Chosen Shortcut Name: ie. Finance PBCS Production

Tip 1: Other Oracle Provider Types
I have only included the PBCS connection as an example here. See the Oracle Documentation for examples on how to connect to Essbase, EPRCS and more!

Tip 2: Connecting Smart View to Oracle Financials Cloud ERP
For those that use Oracle Financials Cloud as a data source for Oracle PBCS, you may wish to use Smart View to query the ERP data which you can do by connecting to the underlying Essbase ASO cube.
Use the Essbase Connections URL:
https://exampleDoM.bi.exampleDC.oraclecloud.com/aps/SmartView
For more tips on how to pull data from Oracle Financials Cloud to PBCS see Lydia’s blog.

Edit 22-01-2021: You don't need the '.fa' in the URL
Edit 22-01-2021: If you have issues with the shortcut name of your connection showing as Oracle Essbase, try changing Product id="HP". It seems illogical but worked for me!

Step 1.
Open a text editor  to begin creating your XML file – Notepad will do.

Begin the XML as follows:

<?xml version="1.0" encoding="UTF-8"?>
<res_GetProvisionedDataSources>

Step 2.
For each environment you wish to add to the drop-down list add the following syntax:

EPBCS/PBCS Environments:
<Product id="HP" name="HP-11.1.2" displayVersion="version">
<Server name="EPBCS Production Environment" context="https://planning- exampleDoM.epm.exampleDC.oraclecloud.com/HyperionPlanning/SmartView"></Server>
</Product>
Step 3.
              Once all the environments have been listed, finish the XML as follows:
             
</res_GetProvisionedDataSources>
Click Save As, then change the document type to XML. Save the file in the SmartView folder that contains the SmartView exe file, if possible.

Step 4.
              Reference the XML file location in your SmartView Options URL setting.
              For example, I store the XML file in the SmartView install folder and therefore the URL is:
     C:/Oracle/SmartView/bin/SmartViewConnections.xml






Ta Da!


The full script should resemble the below:

<?xml version="1.0" encoding="UTF-8"?>
<res_GetProvisionedDataSources>
<Product id="HP" name="HP-11.1.2" displayVersion="version">
<Server name="EPBCS Production Environment" context="https://planning-domain.pbcs.datacenter.oraclecloud.com/HyperionPlanning/SmartView"></Server>
</Product>

<Product id="HP" name="HP-11.1.2" displayVersion="version">
<Server name="EPBCS Test Environment" context="https://planning-test-domain.pbcs.datacenter.oraclecloud.com/HyperionPlanning/SmartView"></Server>
</Product>

<Product id="HP" name="HP-11.1.2" displayVersion="version">
<Server name="Oracle Financials Production Environment (Essbase cube)" context="https://domain.bi.datacenter.oraclecloud.com/aps/SmartView"></Server>
</Product>

</res_GetProvisionedDataSources>

Comments

  1. Reduced risk as opposed to retail-boxed licensed software. The software is always accessible, and you don't sacrifice productivity time should a workstation have to be rebuilt and you have to reinstall software. free Calendly review

    ReplyDelete

Post a Comment

Popular posts from this blog

Transfer of Smart List Values to Members in Calculation Manager

  This blog features instructions for retrieving and transforming a Smart List entry (stored against a dimension member) into a member name to be used within a calculation script. This member name is in a valid format for use with cross dimensional operators. This functionality is particularly useful for Staff Costing models. It can be used to retrieve a grade or payscale point from a staff member and lookup its relevant base salary. I came across this trick when writing a calculation script that would pass through each employee in a Staff Cost model and retrieve their pay scale point – a Smart List value – and then transform this into a member in order to retrieve the corresponding base pay associated to that pay scale point. Pay scale points are members in my ‘Employee’ dimension. Upon configuration of the pay scale Smart List, I selected ‘Create from Members’. This is compulsory in order for the trick to work! I have attached this Smart List to a member in the Metric dim

Smart Lists as Run Time Prompts

How to Create a Drop-Down Box Smart List Prompt Image 1: Business rule containing Smart List Run Time Prompt Smart Lists are very powerful tools within Planning Budgeting Cloud Service (PBCS) software. I have recently created a PBCS Forecasting system that utilises Smart Lists to drive the Forecast Process; allowing users to populate the forecast using a customised forecast method selection tool.  The Forecast Process is as follows: 1.        An admin will load in the latest month of Actual data and open the new Forecast for use; 2.        A business rule will be launched to pre-populate the whole Forecast with a single Forecast Method of choice; ·        For example - The forecast method ‘Average’ is chosen and so ‘Forecast 3+9’ becomes populated with 3 months’ worth of Actual data and the remaining 9 months are populated with the average of the first 3 months’ Actual data, for the whole forecast. 3.        Users then review the forecast and apply the following actio