Sunday, September 13, 2020

EPM Cloud - How to transfer Data from Test to Prod ?

"Export Data" functionality will get you what you need here.  Below are some steps:

Go to Application -> Overview -> Actions -> Export Data. 

From here, you can export custom slices of data from the application (you specify each set of members for each dimension). 

This will export a zip file of the data, then you simply go to production, clear the target intersections, and then go to Application -> Overview -> Actions -> Import Data. 

You can import the zipped data you exported from test in here.  Note that depending on how many intersections you exported, the zip file may contain multiple .csv files, so you want to upload the zip file instead of the individual csv files.

Some links to check out:

Export data - https://docs.oracle.com/en/cloud/saas/planning-budgeting-cloud/pfusa/exporting_data.html

Import data - https://docs.oracle.com/en/cloud/saas/planning-budgeting-cloud/pfusa/importing_data_101.html

Thursday, September 10, 2020

EPM – New Dashboard Capabilities Are Coming to Cloud EPM!

Description:

Our 20.09 release of Cloud EPM released with a new set of dash-boarding capabilities that 

will revolutionize how your users interact with their applications.  These dashboards, based on 

Oracle’s latest web interface technologies, delivers a broad set of new chart types. You will now 

be able to create over 20 type of charts. Also included is a new Quick analysis capability within 

dashboards which offers a new way to create data grids on the fly and charts using search. 

All this comes together in a new user friendly dashboard creation canvas. Join us for an 

exciting session which will cover how you can benefit from, and leverage the new dashboard 

capabilities within Cloud EPM. This session will be useful for all users of Planning, 

Financial Consolidation and Close or Tax Reporting business processes within Cloud EPM.

Tuesday, September 8, 2020

Latest version of SmartView?

 Please download the latest version of the SmartView from the following link:


http://www.oracle.com/technetwork/middleware/smart-view-for-office/downloads/index.html 

There is now a single download, and single installer. 
It will install 32bit if your Office version is 32bit and 64bit if your Office version is 64bit. 
No more 2 versions of the installer. 

This is important for customers going to new M365 (AKA Office 365 in the past)

Thursday, September 3, 2020

EPM Cloud and How Do I Determine the Current Size of Data in an Environment?

 Use the Details page of the environment in My Services to monitor data size. The Details page displays the data size in an environment in these formats:

  • Usage trend as a graph
  • Usage trend as a table
  • Most recent data size in Gigabytes (GB)

To determine the data size:

  1. Access My Services.
  2. Click the name of an environment.
  3. Click Business Metrics.
  4. Select Size of Data (GB).

Oracle EPM Cloud for Administrators - Monitoring your service

Running your Oracle EPM cloud requires daily or weekly or monthly monitoring of your systems.

Below is a link to access certain information and logs for your EPM services and users:

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/cgsad/6_house_keeping_tasks_monitoring_service.html

Hyperion on-premise 11.1.2.4 and removal of Adobe Flash from servers

Good day,

For customers who plan to remove Adobe Flash from there Hyperion servers Dev or UAT or Prod...keep in mind that you will need to patch Planning and Calc Manager modules.

Below is some info on the patch level:

Hyperion Planning 11.1.2.4.010 patch 31365862 and Hyperion Calculation Manager 11.1.2.4.014 patch 28557058

Planning Patch 11.1.2.4.010

Defect Number 31283927

Defect Fixed Remove the dependency of Adobe Flash on Planning UI components.

Calc Manager Patch 11.1.2.4.014


Defect Fixed Calculation Manager no longer requires flash.  This change is in response to Adobe's decision to stop updating and distributing flash at the end of 2020.