Management Accounts Application

Introduction
Downloading
Installation

Introduction

This is a simple Hyperion Enterprise management accounts application. Its purpose is to demonstrate how some Hyperion Enterprise features work it is not intended to be model application or illustrate best practice. It demonstrates the following features:

Consolidation Detail
Foreign currency translation
Formula in CHART, CHARTDSM, DYNVIEWACCTS and TRANS methods.
Hyperion Autopilot
Hyperion Reporting
Hyperion Retrieve
Intercompany eliminations
Multiple organisation structures

To keep things simple the application has no security. This application is free and is released under the GNU copyright. However, I would be very grateful if you could e-mail me if you find it useful or have any suggestions about how it could be improved.

Downloading

To download this application:

Select this link management.zip.
Select Save this file to disk and click OK.
Select an empty temporary folder to save the file to and click Save.

This WinZip contains:

Filename	Description
Autopilot\consolidate_all_orgs.hal	Hyperion Autopilot taskflow that consolidates all organisation.
Autopilot\extract_all_data.hal	Hyperion Autopilot taskflow that extracts all data.
Excel\
Inbox\application.asc	Extract of all application settings.
Inbox\formula.log	Extract of all formula.
Inbox\actuals_prior_1.dat	Extract of Actuals Prior Year 1 category data.
Inbox\actuals_current.dat	Extract of Actuals Current Year category data.
Inbox\budget_current.dat	Extract of Budget Current Year category data.
Reports\*	Simple managment accounts reports and reports showing examples of data and heading functions.

Installation

Create a new application

Extracting the archive and loading the add-in

To extract the archive you must have WinZip installed on your computer. If you do not have WinZip you can download it at http://www.winzip.com. To extract the managment.zip:

Create a new Hyperion Ent
In Explorer go to the temporary folder where you saved Utilities.zip.
Double click on Utilities.zip.
Click the Extract button on the toolbar.
Select the temporary folder to extract the archive to and click Extract.
Copy Utilities.xla to a folder say C:\Comshare\FDC\Utilities. The add-in can be stored anywhere but I think this is convenient place to keep it.