Posts Tagged ‘FDMEE’

data tables on computer

Multi-Year Multi-Period Data Load

Sometimes we need to load multiple years and periods of data planning or Essbase, like a business plan or forecast data. Data Management/FDMEE provides the different options for loading multiple years and periods data from the file, depending on the different file formats. If data is in a single column and both Year and Period […]

Andes Blog 600x400

Use FDM to FDMEE Migration Utility

There are basically 2 options when upgrading FDM classic to FDMEE: rebuild all artifacts, or use FDM to FDMEE migration utility to migrate some, then build the rest.  FDM to FDMEE migration utility is a helpful tool but it has its limitation, for example, the utility can not translate script from VB script to Jython. […]

Late Afternoon Toned Photo Of California Farm With Irrigation

How to Create a FDMEE Report in 11 Steps

FDMEE reports provide a solution that incorporates the source and target data, templates, and user-defined SQL queries. Templates, created in Oracle Business Intelligence Publisher, consume data in XML format and generate reports dynamically. SQL queries can be created to extract data from FDMEE internal tables and coupled with report parameters to extend the definition of […]

Customizing Oracle EPM Workspace Logon Page for 11.1.2.4 Part I

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

FDMEE – Use Scenario as a Generic Dimension Class

In Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE), when you setup a target application, a target dimension class needs to be specified for each dimension. Target dimension class is a property that is defined by dimension type. For example, if you have Period dimension, the dimension class is “Period”; for Account dimension, dimension […]

Automation of FDMEE Jobs using EPM Automate in EPBCS

  Introduction: Oracle EPM cloud has set of EPM Automate commands which are used to automate administration process for EPBCS. Admins can write batch scripts on MS-Dos, PowerShell or other batch scripting program to call the EPM Automate commands. Batch scripts can also be scheduled using Task Scheduler in Windows. This blog is for the […]

How to Download FDMEE Report Using runDMreport in EPM Automate

Introduction PBCS/EPBCS has some built-in FDMEE Reports that can be executed by the user. One of the most common reports are the Process Monitor Reports, which can be executed on-demand from Data Management > Other > Report Execution. The FDMEE report output can be a PDF, XLSX, HTML, or Excel, and the same can be […]

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

How to Recycle PBCS Backups on AWS S3 Bucket After 61 Days

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

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 Restore PBCS Application Artifacts and Data from Snapshot

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

HFM Entity Moves from One Parent to Another

We had a client where, by nature of their business, base entities may move from one parent to another. However, all historical data must stay with their previous parent. Only prospective data will belong to the new parent. There may be several ways of complying with this client requirement, but for me, the simplest way […]

Load More