Tuesday, August 8, 2017

What does EPM Automate Utility offer - Part 4

In this series lets see how to read a file and strip a particular value from a column of a CSV file and use that value in the EPM automate script.


Every month the pay details are extracted from the source system and the data file is loaded into the PBCS, to get this automated the file name should be named as MMM-YY (Pay month and year format).

Let us explore how this is achieved using the EPM  automate.

Declaration Part of the Script:
Preparing the File for reading the contents 

Extracting the Pay month & year

Renaming the file and uploading to PBCS

Hope this helps.

Wednesday, June 28, 2017

Using Substitution Variables in Direct Page Links for Forms and Dashboards in PBCS!!!

In my other post Using Direct Page Links for Formsand Dashboards in PBCS!!! We used the POV with hardcoded members for accessing the forms. A anonymous comment on the post asked

So thought of posting on Using the Direct Page Links for forms using substantiation Variables.

In the POV call the Substitution variables as “&SubVar” instead of the actual member.

And the Forms is called using the sub var

Hope this helps !!!

Monday, April 17, 2017

What does EPM Automate Utility offer - Part 3

After the EPM automate serious 1 & 2 let me cover downloading the latest exported file & logs related to a specific Data export job.

Currently we don’t have a specific command to download the latest exported file and when you run a export data command it prefix the job id ad the end and created the export file.

Let’s see how to download the latest file or the latest log file using EPM automate 

Sunday, April 16, 2017

What does EPM Automate Utility offer - Part 2

Continuing with the EPM automate commands as part 2 after Part 1

The Replay Command

The replay command replays the Oracle Smart View for Office load on a service instance to enable performance testing under heavy load to verify that user experience is acceptable when the service is under specified load.

For example, you can test the user experience on a test instance under heavy load to ensure that the service will perform well after you migrate the application from the test instance to the production instance.

Friday, March 24, 2017

Using Direct Page Links for Forms and Dashboards in PBCS!!!

Like we had the smartcuts in On-premise the same functionality is available in PBCS as direct page links. Let’s cover them in this blog

Straight from the documentation it says “Oracle Planning and Budgeting Cloud supports direct URL links that allow you to access Oracle Hyperion Planning forms and dashboards and to integrate with Oracle Sales Cloud. You can use direct page links to create a URL that points to a specific form or dashboard. If users have appropriate access permissions, they can use the URL to go directly to the form or dashboard to view or update it within Planning and Budgeting Cloud.”

To use this feature, first create a form or dashboard, and then assign access and manage users and roles. You can then set up the URL for a direct page link and communicate the URL to users.

Composite forms are not supported for direct page links.

Wednesday, March 22, 2017

Creating a large number of Period mapping using LCM–PBCS!!!

Well creating a large number of period mapping from 2013 to 2015 will take a while to create manually. Creating the same period mapping for multiple application is also a trouble if you create It manually.

Friday, March 17, 2017

Creating a large number of access to member’s in PBCS using Excel!!!

We all know what does the Access to members does and how to assign to a particular member in PBCS

The challenge here is how will do a mass/huge creation of access to members. Again a thanks to Johngoodwin who helped me here.

The process is as follows,

  1.  Create a couple of Assess to members to get start with manually

Tuesday, January 31, 2017

Oracle PBCS Feb 2017 (17.02) update!!

The Feb 2017 patch for the PBCS is bringing some eye catching updates

Friday, January 20, 2017

Oracle PBCS Access Logs-Patch applied!!!

This is continuation to the blog I wrote about Oracle PBCS Access Logs!! The changes that was described in the December 16 updates are applied on 6th Jan 2017 .

Friday, December 30, 2016

Loading data into PBCS ASO using Smart-view HsSetValue & HsGetValue!!!

Let me cover a simple one this time, how to load data to a ASO cube using smart view in PBCS using HsSetValue & HsGetValue

Just make sure the following statements are true before the load

The Level 0 members are selected for the data load for all the dimension’s part of the ASO cube

As we all know we can’t load the data to a dynamic calculated members and attribute members

As per the document


Data sources: Oracle Hyperion Financial Management, Oracle Essbase Cloud, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Enterprise Performance Reporting Cloud

HsGetValue retrieves data from the data source for selected members of a dimension. When HsGetValue retrieves no data, the value specified for the #NoData/Missing Label replacement option is used (see Table 1). When users select Refresh or Refresh All, only

HsGetValue is called. When users select Submit, HsSetValue is called first, HsGetValue is then called only if HsSetValue returns successfully.

Monday, November 28, 2016

Oracle PBCS Access Logs!!


The much awaited access logs is released in the latest patch update – Dec 2016

You can now download a daily access log, a Comma Separated Value (CSV) file, which provides detailed information on the resources that users accessed, duration of user activity, the IP addresses from which users connected to the service, and the action that users performed in the service. The access log is generated each day.

To download an Access Log:

Make sure you are login in to the Simplified Interface 

Click or tap Application, then Overview, and then Activity.