Data Type Features in Oracle PBCS & EPBCS

Paul Hoch

By
February 1st, 2017


With the big push to the cloud it’s important to know what you can find there that you enjoy in your on-premise application. If you’re working with Hyperion Planning, the good news is that the cloud versions—PBCS and EPBCS—offer the same data type features. The key thing to know is that the configuration is slightly different. This post will show you how to enhance your Planning cloud application with non-financial data such as Text or Dates. Data types also make forms more impactful with nice percentages and SmartLists.

The cloud versions of Hyperion Planning—PBCS and EPBCS—offer the same data type features as in the On-Premise versions.

Basics: the different data types available in PBCS and EPBCS

Planning Cloud offers the following data types:

Currency: Stores and displays in the default currency

Non-currency: Stores and displays as a numeric value

Percentage: Stores a numeric value and displays as a percent

Date: Displays as a date (stores a reference number in Essbase)

Text: Displays as text (stores a reference number in Essbase)

Selecting a data type

Data types can be assigned to any member of any dimension. The main dimension where you want to use different data types is Account but you can also have applications for the Period dimension if you want to add a Period to store Comments (use the data type Text) or if you want to use a Datatype dimension to store different stages of allocations or if you need to store Adjustment. In the case of a Datatype dimension, use the Percentage data type for the member you want to use to store variations in percentages.

In my example, I am going to show you how to use the Percentage data type in a dimension to store all variations in percentages.

Our target member is the BS_Override_%:

In the Member Properties, Select data type / Percentage:

But that is not enough, we need to play with the Evaluation order:

In our case, we need to have the Datatype dimension evaluated first in order to have the member BS_Override_% data type to override the data type of the other dimensions such as Account.

Now, as you can see, the line for BS_Override_% is shown as a percentage, no matter what account Is selected:

 


Paul Hoch

About Paul Hoch

Paul Hoch has over 18 years of EPM and Hyperion experience, specializing in Essbase and Planning. He has successfully completed large-scale EPM implementations for clients in industries ranging from retail to government and financial services to health care. Paul has served as solution architect and team lead for implementations and he has developed and delivered advanced team training. He also blogs and presents regularly on EPM topics, including Essbase, Planning, Hybrid Cloud implementations, PBCS, EPBCS, Smart View, Calc Manager, migrating to the cloud, and more.

Leave a Reply

Your email address will not be published. Required fields are marked *