Scenario #1: Pretend your client would like to calculate inventory for the current quarter and month. For instance, if the current month is August, the quarter total includes values for July and August. How is this calculated in Essbase? Essbase allows users to calculate period to date values dynamically, using dynamic...

An easy way to distribute reports to various users outside of running individual reports or books and then emailing it out to users is by creating a batch and burst to a shared directory. A batch can run various reports on multiple members in a dimension, adding the bursting capability...

Locations In FDMEE, a Location is a level where a data load is executed.  In other words, users define locations to specify where to load the data and each location is assigned an Import Format, Data Load Rules and Data Load Mappings.  As discussed below, users must create Import Formats...

    Here are some quick tips to check when tuning your BSO application: 1. Dimension Order ♦ Use the hourglass model: Largest dense to smallest dense, smallest sparse to largest sparse ♦ Attribute dimensions are always last. 2. Dense/Sparse Settings ♦ Typically, your accounts and period dimensions are classified as dense. 3....

In this post, I will discuss Security and the role it has within HFM applications. I will show how to change user access for different Security Classes, and also how to create a new user in an application. Both of these topics are very significant for assigning accessibility to your...

In this blog, I will be discussing how to create a task list and also what purpose they serve in HFM. They can be a resourceful tool within the application to help manage your workload and I will explain how in the following paragraph. A Task List in HFM serves...

Creating an Application Blog When creating a new HFM application, there are specific steps that must be taken to get the application up and running. It starts with creating and naming the application. To create an HFM application, once you are logged in to Workspace: Go to File > New...

What are shared members? Shared members “share values between members.” In other words, data associated with the member comes from another member with the same name.  For example, lets say under the Product dimension, I would like to add the member “Coke” under Caffeine and share it under Diet. Look...

Not only is Essbase a leading calculation engine, but as a multidimensional database, it is also efficient at storing data. Essbase creates data blocks and an index system in order to access and store data into a cube. The cube above contains three dimensions: Scenario Accounts Period Data values are...

Happy New Year! It has been a while since I have had to use the validatedata.js script to edit data on a Hyperion Planning web form. You would think with the new custom form validation in 11.1.2 you would not have a use for the validatedata.js file. When using custom...