Request a Consultation

CheckPoint Consulting Blog

At times a developer is asked to programmatically evaluate a date and based on that date utilize the correct dimensional member. For example, we have a data point with a value of 20170630 that represents a contract date that is an important component of a contract value calculation. In this example, a calculation result must land in the Period->Years intersection determined by the YYYYMMDD date provided in the data. How would the developer achieve this end in traditional Essbase?

read more

Let's discuss intra-application modular database metadata hierarchy alignment. What does that mean? When a company develops an out-of-the-box Oracle Hyperion EPBCS application such as Project, Workforce, and Capital Planning there are pre-defined dimensional members and hierarchies that probably do not align with the chart of accounts or other metadata structures specific to that organization. For example, in EPBCS Project the pre-defined account structure has separation of account types such as Revenue, Expense and then more detailed COA categories.

read more

Smart Lists have become a little smarter in EPBCS with Dimensional Smart Lists. Dimensional Smart Lists are enhanced only in EPBCS to make data mapping easier among cubes. Here are some succinct steps to walk you through the set up.

read more

Rolling forecasts are considered a good practice for several reasons...

read more

In EAS, the Essbase macro was an underused and yet a smart way to minimize code duplication within a Hyperion Business Rule. With macros, you could write a small script and fill it with parameters that pass variables or hard-coded members throughout the macro. Now with the emersion of EPMA and Calculation Manager, administrators may wonder just how to convert their old macro-riddled rules into a new product that has done away with macros...

read more