Hyperion User Group Michigan Hyperion Essbase and Application Builder HQ G&A Application Spotlight

groundcombInternet and Web Development

Oct 31, 2013 (3 years and 7 months ago)

70 views

Hyperion User Group


Michigan

Hyperion Essbase and Application Builder

HQ G&A Application Spotlight



Edward Suttor
-

ITB/F Global Finance Systems,
DaimlerChrysler


September 19, 2002

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

2

Agenda


Background


Business Need


Selection Process


Solution Overview


Results


Follow Up

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

3

Background



Company


Automotive Manufacturer


HQ in Auburn Hills and Stuttgart


5
th

Largest automotive OEM in world


Chrysler Group


Hyperion Essbase User since 1994 / Hyperion Enterprise
since 1991


Hyperion Essbase Usage at Chrysler Group


Finance Area


More than 25 applications / Hundreds of databases


Approximately 1,000 users


User
-
interface through Excel add
-
in (historically)


Sun Solaris environment


6 Production / 2 Development Servers


IT Business Systems

Finance

September 17, 2002

HUG
-
MI

4

Business Need
-

Purpose



General & Administrative Headquarters


Forecasting, Planning and Reporting


Headquarters expenses incurred at Auburn Hills


U.S. GAAP definitions


Need to fit with Auburn Hills business processes and systems


Ledger: Global SAP


Management Reporting: integrated system of Essbase databases


Must align with reporting requirements for Headquarters



Customer


Corporate Controlling Locations
-

Auburn Hills


System users located at Auburn Hills


IT Business Systems

Finance

September 17, 2002

HUG
-
MI

5

Business Need
-

Requirements


Project approved September 2001


Launch date identified as January 2002


Scope initially determined as 11 effort
-
months:


Changes to existing applications


Creation of new application


Creation of a Web
-
reporting interface (
involved selection of a Web delivery
tool
)


Integration and regression testing


DCX available resources identified as 50% short of capacity
required to complete project on
-
time


Management Technologies, Inc. (MT) selected to augment DCX resources

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

6

Selection Process
-

Essbase Data via the Web

TCP/IP

HTTP

Custom

Application

Web Server

Application Server

API

*

*

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

7

Selection Process
-

Web Tool



Alphablox



Alphablox


Analyzer



Hyperion


Applied OLAP


Applied OLAP


Dynasight/Insight


Arcplan



Executive Viewer


Temtec


Hyperion Appl Builder

Hyperion


JUNA Arch (Custom)

DCX


Mocha Suite


Painted Word



PowerPlay



Cognos



R/W Spiderman


Hyperion



. . . others

Selection Criteria:

Decision
:



Essbase Feature Support



Full read/write/analyze



Platform fit with DCX



Open stds., true thin client



Development ease/tools



Formatting & navigation



Global support



Flexibility


Products Considered:

Hyperion

Application Builder

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

8

Selection Process
-

HAB Summary



Provides full functionality to access Essbase data over the web


Flexible


Can incorporate any business logic with Java code


Objects can be imbedded in other (non
-
Essbase) applications


Can use multiple data sources, including relational


Fit with DCX technical environment


Non
-
proprietary: Runs on DCX
-
standard web architecture


Netscape Webserver


IBM Websphere


J2EE compliant Java code


True thin client possible


Open source


All source code provided, can be modified


Successfully piloted in DCX (Auburn Hills)

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

9

Solution Overview


Hyperion Essbase application with Hyperion Application Builder user
-
interface for reporting


Application Implementation Highlights


MT developed a new Hyperion Essbase application based on design template provided
by DCX


MT developed a Hyperion Application Builder interface/report based upon user
requirements and MT implementation methodology


DCX completed changes to existing applications


DCX performed integration testing


Application Functionality Highlights


G&A expense tracking for the headquarters expenses incurred at Auburn Hills


Highly interactive reporting, dynamically based on Essbase dimension structures


Simple, user
-
friendly environment tailored to non
-
Essbase
-
trained users


IT Business Systems

Finance

September 17, 2002

HUG
-
MI

10

Solution Overview
-

G&A HQ Reporting Data Flow

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

11

Relational Data Source:

IBM Universal Data Base

(UDB) 7.2

Web Server:

Netscape

Enterprise Server 3.6

Application Server:

IBM

Websphere

3.5.3

Application Language:

Java (JSP)

OLAP Data Services:

Hyperion


Application

Builder ADM 2.0

Relational Data

Services

: JDBC 2.0

Operating System:

Sun

Solaris 2.6/2.8

Hardware

: Fujitsu Prime

Power 400, 4x500Mhz

CPU, 8 GB RAM

OLAP Data Source:

Hyperion Essbase

OLAP

Server 5.0 / 6.1

Interface

: Internet

Explorer 5.5, standard

Auburn Hills desktop,

no client applets, true

thin client

HAB provides full read and

write access to


Essbase

OLAP data from the web.

JDBC

EJB’s

Serv lets

JSP’s

ADM

RDBMS

Essbase

J2EE App Serv er

Repository

Web

Serv er

Browsers

Solution Overview
-

G&A HQ Application Architecture

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

12

Application Demonstration

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

13

Results



Accomplishments:


Delivered application on
-
time, within budget


All expected functionality delivered


HAB performed as expected / desired



Challenges


New version of HAB


product installation issues


Licensing / Legal issues


Performance was initially an issue


addressed with upgraded hardware (i.e.


more memory)

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

14

Results
-

Benefits of using HAB for HQ G&A



Simplified business process


Less manual handling of data


Simplified technical architecture


Direct, real time access to Essbase database


No longer moving data to mainframe for reporting


Lower maintenance requirements


Reduced support staff cost due to flexibility, simpler architecture


Web based solution, uses standard DCX architecture


Low risk of obsolescence


No software downloaded to client


Any standard browser can access


No delays for download, desktop configuration, software load

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

15

Follow Up


HQ G&A was global pilot project for HAB at DCX


Result of pilot: HAB has been approved as an IT Global Standard at DCX


Knowledge sharing with other DCX organizations


Reviewing HAB v2.5 as possible tool for creation of a generic
web
-
interface for all DCX


Global Finance Essbase applications


Write
-
back capability developed


pending customer approval
for deployment

IT Business Systems

Finance

September 17, 2002

HUG
-
MI

16

Questions & Answers