Archive.bat Archive.bat is a simple, self-contained command script to manage essbase archives.  It is easily customized for any windows environment and creates a restore command script for simple data recovery. Click here to download Archive.doc Right-Click here and select "Save Target As" to download Archive.bat
Hyperion Essbase Auto-Processor (HEAP) Hyperion Essbase Auto-Processor (HEAP) is a client side automation tool for performing sequences of highly repetitive calculation tasks.  It's also a fairly good example of using VBA with the Essbase API. Click here to download Heap.xls
Security Audit Workbook This workbook is a security extraction tool that tracks new and deleted users, provides a visual cross table for users and groups, and generates an easy to read security summary.  Some elements can be updated and uploaded back to the server.  NOTE: this version supports Essbase version 7 (BSO) only. Click here to download security_audit.xls
Security Dumper (add-in) Security Dumper is an excel addin that creates a workbook with a tab for each application and a complete list of users, groups, and filters.  This version does not provide an upload (that version is available on a negotiated basis).  Note: this version supports Essbase version 7 (BSO) only. Click here to download securitydumper.xla
Essbase Security Dumper (ESD) ESD is a disaster recovery utility that accepts command line (or User Interface) options and creates (or reads) a human readable text file which can also be used to update security on a server (either intact or after being edited to extract the desired elements).  Note: this version supports Essbase version 7 (BSO) only.  An updated version has been uploaded which properly reports a filter with Meta Read access rights as "Meta", instead of "Filtered".  The old version reported it incorrectly and would ignore the line when restoring security.  To use dumps made with the older version, replace "Filtered:" with "Meta:" in the output file (be sure to include the colon). Click here to download ESD_V7.exe
Outline Comparison (OtlComp.exe) OtlComp is a stand alone outline comparison tool that creates a workbook with tabs for each dimension, showing detailed differences between two outlines (either from databases on the server or local files).  Recently added were command line parameters to support scripted comparisons, although this is not documented besides right here (user docs are still on my update list).  The command line switches are:      /1 Original database name (can be filepath.otl or server:appname.dbname)     /2 Modified database name (can be filepath.otl or server:appname.dbname)     /u Essbase User ID (only required if server outline is being used)     /p Essbase Password (only required if server outline is being used)     /o Output filename (i.e. C:\Hyperion\Essbase\Client\Differences.xls) Click here to download OtlComp.exe