File Library

How to Make FDMEE-Triggered Essbase Calculation and Partition Scripts Targeted to Current FDMEE Load
Topic: Webinars
Owner: Bernard Ash
Date: 2016-09-14
Subtopic: EPM

Bernard Ash, EPM Clarity


Part One of a Two-Part Series – Fix Your FDMEE Essbase Loads

Optimize FDMEE performance with Essbase by making all your operations more focused. When your customer’s requirements ask you to use FDMEE to load over 800,000 records per entity for one month, convert YTD to MTD, convert local currency to USD, and then push to an ASO reporting cube, it’s time to time to break out the big guns. Large data volumes or not, why not parameterize ALL your FDMEE-driven calc scripts based on the entities that are in a given load file? Why not do the same with a partition script that refreshes the data to a reporting cube after it has been loaded and calc’d in BSO? In this live, hands-on demo, we will use Jython to identify the distinct entities in a given data load (TDATASEG table) and pass these entities to a MaxL script to manage the focus of the calcs and partition scripts. This functionality is live at Cigna.

Download File   How to Make FDMEETriggered Essbase Calculation B Ash EPM.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database