Posts Tagged ‘EPMAUTOMATE’

Claims Process

CopySnapshotFromInstance – EPMAutomate Command

There are a few things I would like to add to clarify the usage of the CopySnapshotFromInstance command.  As the documented definition goes, it mentions as a current snapshot in one place but an existing snapshot in another. I would like to confirm that it works on both current and existing snapshots.   CopySnapshotFromInstance is […]

hybrid cloud

Resolving Essbase Error 1005000 in PBCS Business Rules

Using substitution variables to store folder directories and then referencing the variables in calc scripts/business rules has long been a best practice in the world of on-prem applications. For example, using a variable to store the path to a shared folder for a dataexport command. DATAEXPORT “File” “|” “&ExportServer/Sample.TXT” “#mi”; But cloud applications do not […]

gears

EPM Automate’s Capabilities Are Expanding

Oracle continues to update EPM Automate on a regular basis. Today, we’re going to take a look at what some of recent updates have to offer Oracle Enterprise Performance Management Cloud customers.   What is EPM Automate? Before we touch on the latest enhancements, let’s explain EPM Automate’s purpose. EPM Automate is a command line […]

Gears of business

Oracle EPM Automate Tool – Installation Procedure

About EPM Automate EPM Automate Utility enables Service Administrators to automate many repeatable tasks,  including the following: Import and export metadata, data, artifact and application snapshots, templates, and Data Management mappings Upload files into environments, list files, and delete files from the service Download snapshots, reports, and metadata and data files from the service Run business rules on data, and […]

Setting up Daily Replication Script for PBCS applications

One of the things that organizations tend to want or need during and after an implementation are application refreshes. In this blog post, I have two environments, PROD (Source) and TEST (Target), which I have developed a script to facilitate end users to refresh TEST environment. This script should be run where EPMAUTOMATE was installed […]

How EPM Automate Can Help in Troubleshooting Issues

Introduction EPM Automate plays a vital role in automating many admin and user tasks in Oracle Hyperion Cloud. This blog post demonstrates how EPM Automate can help in troubleshooting the issues during support phase. Basically, this method is useful when we have more than one instance like Development and a SIT/UAT/Prod instance. The following explains […]

How to Encrypt the Admin Password When Used on a Batch Script

In one of my previous blog posts, the EPMAUTOMATE encrypt command was used to encrypt the administrator’s password on a batch script. Here, I describe the process for how to encrypt the password when used on a batch file. Before continuing, ensure the EPMAUTOMATE has been installed on the computer from which you are running […]

Archive PBCS Snapshots to Amazon S3 Cloud Storage

Amazon Web Services’ (AWS) low-cost S3 cloud storage provides a cost-efficient solution to archive snapshot files extracted from Oracle Planning and Budgeting Cloud Service (PBCS). In the following paragraphs, I will use the AWS Command Line interface (CLI) to upload to the Amazon S3 bucket to archive backup files pulled down from a PBCS instance. […]

How to Backup Planning Application Cloud Service (PBCS)

Oracle Backup Policy “Oracle Planning and Budgeting Cloud creates the snapshot by backing up artifacts of all service components and Essbase data present in your service instance during the maintenance window. Because Oracle stores only the snapshots created in the most recent maintenance window, the artifacts and data available for restoration depend on their state […]