Oracle EPM Planning Mapping Smart Lists to Attributes

Attribute dimensions are excellent tools for establishing descriptive capability of a dimension member and to then enable slice and dice capability by this attribute. For example, a project may have an attribute of a project manager as you would typically only have one project manager per project. The challenge results in the administration of this, as tends to be a manual task using the dimension editor and power is taken from the user to change/update this themselves and becomes an admin based task. • Why? Gives the control to users to easily view & update • How? Our approach relies on automation using EPM Automate (extract and import)

PBCS Enable Summary Drill

In this post we look at Summary Level Drill from PBCS!!!!! Yes, it is finally here. Now despite my excitement, I promise to remain unbiased in this blog post and tell you what I like and what I don’t like about the recently enabled feature. This blog post will cover how to activate the feature with a drill to Fusion Cloud.

Triggering On-Demand Source Data Loads from within PBCS

In this post we look at on-demand data loads from source to PBCS. In on-premise Hyperion, if the requirement is to trigger on-demand data loads from within Hyperion they are a few options like Calc Manager command line triggers or Workspace Generic Jobs both of which can trigger batch scripts on the underlying servers to trigger the load from source systems to Hyperion. In PBCS this is a lot more difficult due to limitations of PBCS being a cloud solution that is not able to directly integrate with all source systems due to both technology and locations of these systems.

FDMEE Drill Through – Myth Buster Edition – What is really possible?

FDMEE Drill Through - Myth Buster Edition-What is really possible? #OracleEPM #PBCS #Hyperion

Clearing Essbase ASO Cubes in PBCS

For those that do not know what an Essbase ASO Cubes is keep reading this paragraph, the rest please collect your boarding pass and proceed to next paragraph. I suppose if you are still reading this paragraph then your Hyperion knowledge is limited, so let me see what justice I can do in explaining Essbase...

Loading Non-Numerical Data / All Data Types Data Loads Via FDMEE or Data Management

Some time back I wrote that Oracle Hyperion Financial Data Quality Manager (FDMEE) aka Oracle Planning and Budgeting Cloud Service (PBCS) Planning Data Management is not able to load non-numerical data and that to me was a major flaw in an integration tool. Understandably so, I was upset at the time because after spending a...

Hyperion Metadata & Data Integration 101 – What You Need To Know

Everything you need to know for Hyperion Metadata & Data Integration

Hyperion Planning – Why, What, How

So you or your organisation are considering to implement a planning a budgeting tool? You are tasked with spearheading this revolution and for change the way your organisation does planning and budgeting. So before you start writing your victory speech and planning your next solid vacation with the bonus earned for an awesome implementation; let’s...

Who Am I

Hello Friend, My name is Ahmed Hafez and Welcome to My Blog On My World Of Enterprise Performance Management (EPM) and Business Intelligence(BI). Please think of this page as an intro as to what qualifies me to blog in this space. I am Oracle EPM & BI Specialist. I have been working in this space since 2007 with a Professional...