Eddie Cisneros – Lead Technical Consultant

It is very important for users to identify to which environments are they logging in. For this reason, I am sharing the following insights into how to customize the Oracle EPM workspace logo, which will help users determine if they are logging into a Production, Development, or QA environment. Out of the box Workspace log […]

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 […]

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 […]

With the shift to the cloud, on-premises Essbase applications may be migrated to Oracle Analytics Cloud (OAC) using a simple method provided by Oracle. Essbase Life Cycle Management process is cost effective and easy to use utility for EPM Professional or Technical lead to migrate the applications to the cloud without the need of recreating […]

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 […]

In this blog post, I will cover the necessary steps to create the S3 bucket storage that will transition to standard – IA (Infrequent Access) for 30 days to finally move to Glacier where the files will be archived for 61 days. Amazon Web Services’ (AWS) low-cost S3 cloud storage provides a cost-efficient solution to […]

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. […]

I recently wrote a blog post describing the process to create and download Oracle PBCS application SnapShots to local disks. Now I’m sharing a step-by-step look at the process of importing an application onto PBCS. In this article, I will describe how to remotely execute predefined commands to upload files and migrated Artifacts SnapShot. To […]

After reviewing Oracle Planning and Budgeting Cloud Service (PBCS) documentation, I found a EPMAUTOMATE command that I consider to be useful for all developers and administrators. The “resetservice” command will restart PBCS instance clearing memory and it will help improve application performance. Oracle PBCS documentation: “Restarts the service instance. Use this command only when you observe […]

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 […]