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...
HollandParker
Blog
Loading...
11.1.2.4 Release: New Features
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...
Dynamic Time Series
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...
Quick BSO Tuning Tips
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....
Shared Members
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...
Understanding BSO Data Storage in Essbase
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...
New to 11.1.2 – Advanced Calculations in ASO Essbase Applications
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...
Post Holdings
Discover how our OneStream implementation services enable your organization to streamline the financial close, report with confidence, and deliver faster, more accurate insights to stakeholders.