 Utilities, Code Library, and Sample Applications
Oracle's Hyperion Products
Welcome to the Utilities, Code
Library, and Sample Applications page where you'll find useful material
that you can download, review, and customize to suite your
Oracle-Hyperion environment. Unless noted, all the content found
on this page applies to Oracle's Hyperion products release 9 and above.
Disclaimer:
You expressly understand and agree that your use of the utilities is at
your sole risk and that the utilities are provided on an "as is" and
"as available" basis. Oracle expressly disclaims all warranties of
any kind, whether express or implied, including, but not limited to,
the implied warranties of merchantability, fitness for a particular
purpose and non-infringement. Any material downloaded or otherwise
obtained through this Web site is done at your own discretion and risk
and you will be solely responsible for any damage to your computer
system or loss of data that results from the download of any such
material.
Utilities
| Description |
File(s) |
| EPM Architect File Generator—This
utility can create import and command files from a variety sources,
including existing Hyperion Financial Management files (such
as .per, sec., and .xml), Hyperion Planning, Microsoft Excel
files, metadata files, and more. |
download |
| Microsoft Analysis Services to Hyperion Essbase Porting Utilities—This
utility accesses and ports existing Microsoft Analysis Services (MSAS)
cubes to Hyperion Essbase ASO cubes release 9.3.x. The porting
addresses both metadata (dimension, members, and formulas) and data. |
download |
| Hyperion Essbase Log Reconciler—A compiled PERL script which reconciles or reformats Essbase logs for better readability. |
download |
| QuickToggles—An Excel Add-In that creates a user selectable toolbar with quick options settings. |
download |
| Casema Excel Add-in Utility—This Excel add-in builds upon the Essbase Spreadsheet Toolkit which is included in the Essbase spreadsheet add-in. |
download |
| Hyperion Interactive Reporting Lifesaver Utility—This
utility allows you to select and save one or more documents that are
currently open in a running instance of Hyperion Interactive Reporting. |
download |
| Hyperion Interactive Reporting Object Browser Utility—This
utility generates a list of programmable COM objects you have installed
on your system, in a format that can be used from within the Hyperion
Interactive Reporting scripting environment. |
download |
| Hyperion SetCache Utility—Utility
for monitoring and adjusting the index cache for any applications. It
is a series of scripts that checks the size of the index cache, then
dynamically create a MaxL script that assigns an appropriate amount of
Index cache based on 90% of the file size(s). |
download |
| Hyperion Essbase Data Plucker Utility—This
administration tool quickly plucks data out of Hyperion Essbase to use
for other purposes such as backups and data conversions. Data Plucker
extracts data from export files, audit files, and the like, without the
need to select each level 0 member. |
download |
| Hyperion Essbase Calc Status Utility—Use this utility to monitor the status of calculation scripts, and provide alerts when calcs are completed. |
download |
| Hyperion Essbase Application/Database Spreadsheet List Utility—This
utility provides a quick way to view the settings for all Hyperion
Essbase applications and databases for a particular Essbase Server. |
download |
| Hyperion Essbase Drill Through Utility—This utility provides a method for drilling through from Hyperion Essbase to an
external data source using standard Microsoft Office components. |
download |
| Hyperion Essbase Filter Mania Utility—Use
this utility to export, import, and change Hyperion Essbase security
filters at the click of a button. If you make changes to filters very
often, Filter Mania could save you hours of work. |
download |
| Hyperion Essbase ESSCFG Utility—A
graphical and informative way to edit the ESSBASE.CFG file. Simply
select a essbase.cfg file setting and the Technical Reference Help
reference appears for the selected setting. |
download |
| Hyperion Essbase Script Spooler Utility—This utility executes up to 100 ESSCMD scripts at a time, with no interaction required from the administrator. |
download |
| Hyperion Essbase Save My Server Utility—Use this utility to manage server operations such as shutdowns, log deletions, calc script execution, and data exports. |
download |
| Hyperion Essbase Substitution Variable Command Utility—Use
this batch utility to automatically set a substitution variable based
on your computer's current date. A quick way to quickly update your
substitution variables. |
download |
| Hyperion Essbase Unlock All Database Objects Utility/Source Code—If
you've ever wanted to unlock all of your database objects in one shot,
here's your utility. You can either run the utility, or incorporate the
API source code into your existing project. |
download:
|
| Hyperion Essbase Port Manager Utility—Monitor
your Hyperion Essbase port usage and store this information in useful
log files that contain information about the date, time, number of
connections, number of ports, and user id's of connections. |
download |
| Hyperion Essbase ESSCMDQ and ESSCMDG Utilities—Extensions
to the ESSCMD command set that include command equivalents to the
Outline and Grid APIs, and additional command equivalents to the
Functional API. |
download |
| Hyperion Essbase Dense/Sparse Configuration Utility—Determines
the optimal dense/sparse configuration for your database and includes a
utility to automatically set members to dynamic calc non-store. |
download |
Code Library
| Description |
File(s) |
| Creating a Time Balance Average for an Essbase ASO Cube—Find out how to create a Time Balance Average function for an Essbase Aggregate Storage Option cube. |
download |
| Hyperion Dashboard Development Services - Components—Use
these plug-and-play components to extend the functionality of Oracle's
Hyperion Interactive Reporting Dashboard Development Services
(Dashboard Studio). |
download |
| Hyperion Dashboard Development Services - Templates—Use these templates as a starting point for your Dashboard Development Services (Dashboard Studio) implementation. |
download |
| Oracle's Hyperion Interactive Reporting Tips and Tricks Cookbook and Query Samples—A useful combination of tips and tricks and downloadable .BQY query samples. |
download |
| Hyperion Essbase MaxL Python Module—The
MaxL Python Module, Essbase.py, provides access to Hyperion Essbase
multidimensional databases from Python programs through MaxL. |
download |
| Oracle Hyperion Web Analysis API files—The
Web Analysis API is implemented using a variety of technologies,
including HTML, Java Server Pages (JSPs), and Javascript. You use JSP
technology to communicate with the application server on which Web
Analysis is deployed. You use HTML to create web pages that contain the
Web Analysis applets. And you use Javascript for communication between
the browser and the Web Analysis applets. |
download |
| Hyperion Web Analysis Custom Java Client Code—Use
this open source model to create a custom look and feel for the
Hyperion Web Analysis Java Client, while getting familiar with the
Analyzer API. |
download |
| Hyperion Essbase Custom-Defined Functions Samples—Use
these samples to get started writing custom-defined functions
for Essbase, and tailor the Essbase calculator functionality to your
meet your exact calculation needs. Export data directly from an Essbase
database to various target formats. Create, format, and send alerts
directly from Essbase to an e-mail, pager, cell phone, PDA or other
device that supports text messaging. |
download:
Export CDF
email Alert CDF |
| Hyperion Essbase MaxL Perl Script Suite—Use
this suite of scripts for Hyperion Essbase administration, including
updating users and groups, updating substitution variables,disabling
database connections, and enforcing naming conventions in MaxL. |
download |
| Hyperion Essbase Log Search Suite—Use this suite of Perl scripts to search through your Hyperion Essbase log files. |
download |
Sample Applications
| Description |
File(s) |
Reporting Sample Images—This
collection of royalty-free sample images (Pin Dials,Gauges, Objects and
Map background images) is designed to help you get started customizing
your Oracle-Hyperion reports, including reports from Hyperion
Interactive Reporting, Hyperion Web Analysis, Hyperion Financial
Reporting, Hyperion Application Builder, and Hyperion SQR Production
Reporting.
The images can be used royalty-free by a licensed Oracle-Hyperion
Software user, solely in connection with the use of the Hyperion
Software. All of the images remain the property of Oracle Corporation.
Please read the Terms of Use for additional information. |
download |
| Essbase Sample Basic Application—Includes
files that you can use to create a Hyperion Essbase database that
tracks information from your Hyperion Essbase log files. This database
allows you to view your Hyperion Essbase application log files through
a spreadsheet or Essbase Integration Services tool by loading the file
back into Hyperion Essbase as a new database. |
download |
| Essbase Demo Basic Application—This sample application, called Demo, ships with Hyperion Essbase and contains one database, Basic. |
download |
| Essbase ASO Basic Application |
download |
|
Bookmark
