us-analytics.png
Ask an Expert

PBCS and EPBCS Updates (July 2017): New Predictive Planning Client, New Workforce Dashboard, and More

This month, Oracle will release its July updates for Planning & Budgeting Cloud Service (PBCS) and Enterprise Planning and Budgeting Cloud Service (EPBCS). This blog post outlines several new features, removal of support, and fixed defects for PBCS and EPBCS.

The monthly update for PBCS and EPBCS will occur on Friday, July 21 during your normal daily maintenance window.

The Complete Guide to Hyperion Planning in the Cloud


New EPM Automate Utility Version

A new version of the EPM Automate Utility is available in this update. This version includes the clearcube command, which uses the settings specified in a Planning job of type clear cube to delete specific data from input and reporting cubes. You must install this version of the utility to use the updated command.


New Rest API: CLEAR_CUBE

You can now use a REST API to clear specific data within input and reporting cubes. (This does not delete the application definition in the application's relational tables.) See CLEAR_CUBE in the Oracle Cloud REST API for Oracle EPM Cloud guide.

Planning Clear Cube Job Now Clears Relational Data and Essbase Data

The Clear Cube job options have been updated to allow you to clear both Essbase and relational data. Previously, you could only clear Essbase data. To view the updated Clear Cube job options, click Application, then Overview. From the Actions menu, select Clear Cube. On the Clear Cube page, click Create, complete the job name, select the cube, then select from the clear options displayed.

Oracle has also provided two modes for clearing partial data for aggregate storage cubes. Selecting Partial Data (Basic Mode) enables you to use the member selector to specify the regions to be cleared. Selecting Partial Data (Advanced Mode) enables you to clear Essbase data by using an MDX expression in the text box provided.

Updated Provisioning Report 

The Provisioning Report has been redesigned to include the number of unique users provisioned with Oracle EPM Services roles. The report now identifies the total number of provisioned users.

Ability to Add Existing Cards, Clusters, Tabs, and Sub Tabs to Navigation Flows

While creating or editing your navigation flows, you can add existing cards, clusters, tabs, and sub tabs. To search for and add existing cards, clusters, tabs, and sub tabs, launch the Navigation Flow Designer (click Tools, and then click Navigation Flow). Create a new navigation flow or open an existing navigation flow to edit it. Click Add Existing Card/Cluster, and navigate to the card or cluster you want to add. Existing tabs and sub tabs can be selected for tabular cards by clicking the Add Existing Tab or Add Existing Sub Tabs option.

New Predictive Planning Client

The Predictive Planning for Smart View client has been updated to be compatible with the latest release of Oracle Smart View for Office.

Predictive Planning Chart Interaction and Other Enhancements

Predictive Planning has been updated to include new features:

  • Adjust future values: After running a prediction, you can modify the values for any future data series. Select a data series, and then move the entire line, with the first data point either locked or unlocked, or move a single data point. Changes you make in the chart are reflected in the grid. You can also adjust values by updating them in the grid. Changes you make in the grid are reflected in the chart.
  • Zoom: Use Zoom to zoom in to the prediction area to see more detail at one time.
  • Maximize: Maximize the prediction area to increase the size of the chart
  • Growth curve: You can now add a growth curve to the prediction chart and specify the rate of growth.
  • Chart settings: A new Chart Settings dialog box lets you change the appearance of the chart in the prediction area.

Member Name May Contain Comma

In this update, Data Management now supports member names with commas when loading data to EPBCS or PBCS.


Export a Grid Design Financial Reporting Web Studio to Excel

Starting in Release 17.07, you can export a report's grid design information as it appears while viewing the grid in Financial Reporting Web Studio to Excel.

EPBCS Only

Weekly Planning in Financial Business Process

In the Financials business process of EPBCS, weekly planning enables you to plan and forecast at the weekly level. Forms are designed so you can view weekly level plan and forecast data. You can also leverage the rolling forecast range at a weekly granularity and plan continuously at a weekly level for 13, 26, or 52 weeks. When you update the current time period, forms are updated to add or drop time periods to reflect the updated plan, forecast, or rolling forecast range.

New Workforce Dashboard

If you enable the Projects and Workforce business processes, a new analysis dashboard in Workforce called Review Employee Assignments shows you how employees are assigned across projects. On this dashboard, you can also review employee’s utilization on various projects and reassign employees to projects as needed. This feature is available only for the Projects and Workforce business processes enabled after the July monthly update.

Data Import Templates Available from Financial Business Process

For the Financials business process in EPBCS, data import templates are now available for download from within the application. The templates are generated based on the features you’ve enabled. From the Configure page for Financials, go to the Actions menu, select Download Data Load Templates.

Removal of Support

Standard Interface (Planning and Budgeting Cloud Workspace Interface)

This change affects PBCS customers who activated their subscriptions on or before July 31, 2016 only. The Simplified Interface, an option available in the service since November 2014, will be established as the standard across the service. As a result, the current Standard Interface, which is also known as the EPBCS Workspace, will not be supported starting with the December 2017 update to the service (December 1, 2017 for test instances and December 15, 2017 for production instances). After the deployment of the November update to production instances on November 17, 2017, bugs or enhancements for the Standard Interface will not be addressed.

Financial Reporting Studio Desktop Client

Financial Reporting Web Studio, available since March 2016, will become the only environment for designing and building reports.

Oracle is providing additional time for users to transition from Financial Reporting Desktop Studio to Financial Reporting Web Studio. Tentative plans call for functional parity between Financial Reporting Web Studio and Financial Reporting Desktop Studio in late 2017, at which time, support for the desktop Studio will transition to the Web Studio and distribution of the Desktop Studio will cease.

Oracle recommends that you transition to using Financial Reporting Web Studio at the earliest opportunity. 

File-based Integration of Data Management with Oracle Fusions Financials Cloud

Oracle Fusion Financial Cloud Budgetary Control and Encumbrance Accounting is now fully integrated with Data Management.

This enhancement brings the integration of Oracle Fusion Financials Cloud with Oracle EPM Cloud on par with the current, out-of-the-box, file-based integration. As a result, the file-based integration will be phased out starting the September update to the service.

If you are using file-based integration between Oracle Fusion Financials Cloud and Oracle EPM Cloud, Oracle recommends that you adopt this new integration as soon as possible.

Ability to Add Members to the Property Dimension in Workforce Business Process

To ensure performance and best practice design for Workforce, Oracle will disable the ability to add members to the Property dimension starting in the August 2017 update to the service. The ability to add members to the Property dimension was an inadvertent feature, which can seriously impact performance. To prepare for this change, you should remove all custom members added to the Property dimension and re-accommodate data and artifacts that leverage these custom members. As of the August 2017 update, custom members in the Property dimension will not be allowed and content upgrades will not be successful. Oracle recommends that you update your Workforce models as soon as possible.

Fixed Defects

Defect Number

Description

26269170

 

In the Workforce business process of Enterprise Planning and budgeting Cloud, the tiered tax types are correctly calculated when an employee’s status (and therefore their salary) is changed.

 

26288057

 

Financial Reporting Web Studio now allows negative indentation.

26260775

 

You no longer receive an error on clicking the Statistics tab to check detailed information of plan type.

 

26222333

 

You no longer receive an error in Financial Reporting Web Studio when adding a second prompt using the same dimension but a different member.

 

26176975

 

When exporting an Essbase aggregate storage application to Planning, you no longer receive an error.

 

26171295

 

In the Planning Admin Extension, when working with single-currency applications, the base currency is now displayed for the Entity dimension.

 

26150043

 

When you use the batch scheduler to schedule a reporting batch to run and export to an external folder, you no longer get an error.

 

26120854

 

When you delete an application and then load another application, Financial Reporting reports are now displayed correctly in the Reports section of the application.

 

26102309

 

If the Prompt for POV check box is enabled, when you change the POV member in a report by typing the member name in the POV pop-up (instead of selecting it), the newly-selected member and the report now display correctly.

 

26087065

 

In Supporting Detail, you are now correctly prevented from adding a child row to a Total row.

 

26086369

 

In a Chrome browser with the User POV set to "on", PDF and HTML preview now work correctly.

 

26001249

 

An error no longer occurs when a non-administrator user invokes Member Selection from a worksheet containing shared members, whether invoked from shared members or base members in the grid.

 

25999536

 

Users are now prompted to select from low-level members in the POV that they have access to.

 

25994343

 

In rare cases, database refresh produced the error Unexpected EOF encountered during parallel restructuring. This fix prevents such rare database refresh failure errors.

 

25985836

 

You can now copy and paste an entire report containing a formula from Financial Reporting Web Studio into Excel.

 

25968126

 

When there is a large number(> 1000) of members in the selector, relaunching member selection for runtime prompts works as expected and an error is no longer displayed.

 

25962540

 

Secondary hierarchy alias member names are retrieved as expected when the alias member names are the same as the primary hierarchy member names.

 

25925436/ 26026155

 

Performance improvements were made so that calculations run against Aggregate Storage Cubes now finish as expected.

 

25877036

 

In a form with a custom attribute assigned to members on the row, attributes that are set to not display on the form now correctly do not display.

 

25786671

 

After changing the alias table, if an Excel formula references a member name that does not appear in the new alias table, then a user-friendly message is now displayed.

 

25766054

 

In Workforce, a departed employee’s FTE is now correctly reflected in the Quarterly and YearTotal summary in the Analysis FTE and Headcount form as the last period’s value.

 

25716465

 

When the Time Zone is set to Japanese (JT), weekly-recurring jobs that are scheduled in the Job Console to run on a different date/time than the server date/time are now correctly launched.

 

25691601

 

You no longer receive an exception when you apply amount mapping to every row from ASO to BSO applications.

 

25568788

 

After using Migration to import an application in which Predictive Planning options are set in System Settings, you no longer receive the following error: The historical data source for predictions has not been configured, please contact your administrator.

 

25408121

 

You are now able to copy members from one cell to another in Financial Reporting Web Studio.

 

25124701

 

When the Time Zone is set to Japanese (JT), the Job Console now correctly displays job information in the Japanese time zone instead of the UTC time zone (Coordinated Universal Time).

 

21486298/ 21501674

 

Aggregate storage cubes are no longer listed in the Smart View Panel when either one dimension or no dimensions are enabled in the cube

 

 

Considerations - Gauge Chart Displays Zero Instead of Threshold Values

If you delete any of the Maximum Values, the chart subsequently displays zero for all thresholds. Workaround: When updating the threshold values on a gauge chart type, do not delete the Maximum Value for any of the thresholds.


The Complete Guide to Hyperion Planning in the Cloud

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

  • Evaluating EPM or BI technologies
  • Comparing on-prem vs. cloud
  • Planning upgrades and migrations
  • Estimating project costs and timeframes
  • And much more — ask us anything!

Let our experts tackle your toughest questions for you.

Let's Talk