EssBenchBrian Marshall

The goal of EssBench is to provide a standardized Essbase application for benchmarking between environments.  The initial release is a basic BSO cube with the following characteristics:

  • Dimensions
    • Account (1025 members, 838 stored)
    • Period (19 members, 14 stored)
    • Years (6 members)
    • Scenario (3 members)
    • Version (4 members)
    • Currency (3 members)
    • Entity (8767 members, 8709 stored)
    • Product (8639 members, 8639 stored)
  • Data
    • 8 Text files in native Essbase load format
    • 1 Text file in comma separated format

In addition to the cube and data, there is a process included for Windows users.  I am working on putting together a better way to execute the testing, but this is a good start and let’s us start collected data for comparison purposes.  Included in this release is a combination of a PowerShell script and a MaxL script with the following characteristcs:

  • PowerShell Scripts
    • Creates Log File
    • Executes MaxL Commands
  • MaxL Scripts
    • Resets the cube
    • Loads data (several rules)
    • Aggs the cube
    • Executes allocation
    • Aggs the allocated data
    • Executes currency conversion
    • Restructures the database
  • Executes the MaxL script three times

Where Do I Get EssBench?

I’ve set up a landing zone and domain for EssBench.  You can visit that here.  There are three main components to download:

Installation Guide

Essbase Artifacts

Automation and Data Files

What Next?

I’m working now on two items.  First, I want to start collecting information so that we can have an actual database of test results.  This provides everyone the ability to compare without needing more than their own environment.  Next, I’m working on putting together an application that will actually execute the test.  It will also eventually collect the results and upload them automatically to a database.  Finally, I would like it to also collect system configuration information (CPU, Memory, Storage, etc…).  But that will be for another day.  In the meantime, go benchmark your environment today!