Browse Prior Art Database

Modify Essbase structure from a web page without using API

IP.com Disclosure Number: IPCOM000015442D
Original Publication Date: 2002-Jan-20
Included in the Prior Art Database: 2003-Jun-20
Document File: 3 page(s) / 69K

Publishing Venue

IBM

Abstract

The disclosed architecture allows a user to perform operations on Hyperion(*) Essbase from web pages. With this solution, an user can build dimensions, load data, change security and so on. All available actions are listed in the ESSCMD commands. The user launches these commands from web pages developed with Active Server Pages (ASP) technology. The implementation of this solution is faster and simpler than a developement using Java and Essbase's API. This solution uses the following components: Web Server The web server is based on Microsoft(*) IIS 4.0. The web server store the ASP pages which access the SQL tables and the stored procedures.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 56% of the total text.

Page 1 of 3

Modify Essbase structure from a web page without using API

The disclosed architecture allows a user to perform operations on Hyperion(*) Essbase from web pages. With this solution, an user can build dimensions, load data, change security and so on. All available actions are listed in the ESSCMD commands. The user launches these commands from web pages developed with Active Server Pages (ASP) technology. The implementation of this solution is faster and simpler than a developement using Java and Essbase's API.

This solution uses the following components:

Web Server

The web server is based on Microsoft(*) IIS 4.0. The web server store the ASP pages which access the SQL tables and the stored procedures.

Relational Database

The database is stored on Microsoft(*) SQL 7.0. It includes table, stored procedure and Data Transformation Service (DTS). ESSCMD must be installed on the same server (Essbase client).

OLAP Database

Hyperion® Essbase 6.0.

The relationship between components is shown in figure 1.

C om ponents and R elationship diagram

  W eb S erver M icrosoft® IIS 4.0

   W eb S erver M icrosoft® IIS 4.0

 ASP Pages

erverT 4.0 Ss NindowW W indow s N T 4.0 S erver

L 7.0Q SSM M S S Q L 7.0

Tables

S tored proc / D TS

Hyperion® ESSCM D

O utpu t file (T X T )

    Front-End (H yperion® A nalyzer, E xce l A dd -in , ... )

H yperion® E ssbase 6.0

F igure 1

1

[This page contains 8 pictures or other non-text objects]

Page 2 of 3

There are seven main steps in the process which is described below (see also fig. 2). In this example, the user adds a new member in a dimension of the Essbase's cube. All members of the updated dimension must be stored in a SQL table.

Sequence diagram

 ASP SPTablesPages

ESSCMDDTS

Output file

Essbase

Front-End

1

2

3

3

4

5

7

5

6

1 Read the table and display the values in the page

The first ASP page retrieves the actual members of the updated dimension. We used combo boxes filled up dynamically...