Blog

There are two ways in which Financial Reports can be run in Oracle EPM 11.1.2.4: Workspace and SmartView. Workspace only allows users to view the Financial Reports. SmartView also allows users to view the report. However, in SmartView, users can use Ad Hoc Anaylsis along with the report. This allows users...

Hyperion Planning Check out the new 11.1.2.4 Hyperion Planning New Features! ♦ Homepage & Interface Updates A new simplified interface creates an efficient way for users to create and manage an application, specifically by accessing common tasks through home page icons. Once application is launched: In addition, users can use...

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

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

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

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