Blog

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...

Link to DRM whitepaper The need for automating metadata updates is becoming more important as systems to facilitate financial consolidations and financial budgeting and forecasting are being implemented. Most companies prior to implementing a product to facilitate these activities used Microsoft Excel which inherently cannot synchronize metadata between worksheets and/or...

Custom calculations and allocations are created using mdx and can only target level 0 data. The scripts can be executed using Maxl or Calculation Manager. Prior to 11.1.2 this was accomplished with a BSO cube with partitions or member formulas in an ASO outline. Custom calculations workflow: Create calculation script Create run time...