HOME | My Site

Find out about new features, tricks I have discovered, or useful best practice advice for Oracle EPM Applications.

Consultant Tips;

EPM Planning
Business Rules
Data Exchange

BLOG PREVIEWS

Reference rows and columns in Oracle EPM Report formulas

Sarah Ansell

Dec 5, 2023
2 min

Reports

Reference rows and columns in Oracle EPM Report formulas

In EPM Reports, formulas can be used to perform simple calculations, such as a variance calculation. Formulas require references to rows...

7 Day Rolling Artifact Snapshot Backups in the Cloud (Groovy Script)

Sarah Ansell

Jul 25, 2023
4 min

Rules

7 Day Rolling Artifact Snapshot Backups in the Cloud (Groovy Script)

Each Oracle Planning Cloud environment has a Daily Maintenance window in which Oracle perform routine maintenance. During this automated...

Automating Data Integrations via Business Rules using REST API Commands

Sarah Ansell

Apr 5, 2023
3 min

Groovy

Automating Data Integrations via Business Rules using REST API Commands

Automate EPM Data Load Rules without the need to install any automation software on a server. Entirely within the cloud. Make life...

Oracle EPM Data Management Multi Currency Load

Sarah Ansell

Oct 28, 2022
2 min

Integrations

Oracle EPM Data Management Multi Currency Load

By default, Data Management assumes that the currencies will be associated with the Entity or Location when loading any data into Oracle...

Clear target data in Oracle EPM - ERP integrations using a Data Exchange Clear Region

Sarah Ansell

Oct 1, 2021
4 min

Integrations

Clear target data in Oracle EPM - ERP integrations using a Data Exchange Clear Region

------------------------------------------------------------------------------------------------------------------------ *** Update...

FAQs answered for the new Clone Environment Planning Cloud feature!

Sarah Ansell

Apr 13, 2021
2 min

FAQs answered for the new Clone Environment Planning Cloud feature!

This is a very quick, no frills, 'what you need to know' blog about the latest new Planning Cloud feature: Clone Environment. This...

Connecting to multiple Oracle Cloud Environments via Smart View

Sarah Ansell

Jul 29, 2019
2 min

Smart View

Connecting to multiple Oracle Cloud Environments via Smart View

Connect to multiple EPBCS environments via Smart View Shared Connections XML Switching environments, changing domains, logging in,...

Transfer of Smart List values to members in Calculation Manager

Sarah Ansell

May 31, 2018
3 min

Rules

Transfer of Smart List values to members in Calculation Manager

This blog features instructions for retrieving and transforming a Smart List entry into a member name to be used within a calculation...

Sarah Ansell

Dec 1, 2017
5 min

Introduction to Predictive Planning

What is Predictive Planning? Predictive Planning is an extension to Oracle Hyperion Smart View for Office. It links with Oracle Planning...

Be in Touch

Ask questions & share your thoughts below. Alternatively, comment directly on my blog posts!

EPM

Consultant Tips;

EPM Planning

Business Rules

Data Exchange

Be in Touch

More EPM Content

Subscribe to new content