Learn Hyperion/OBIEE by Amit Sharma. Mail to aloo_a2@yahoo.com for all Hyperion/OBIEE trainings and support
Hyperion Essbase
Working with Spread sheet Add-in
Amit Sharma
Hyperion/OBIEE Trainer/Consultant
BISP
Learnhyperion.wordpress.com
Aloo_a2@yahoo.com
Download Hyperion/OBIEE tutorials from learnhyperion.wordpress.com
Learn Hyperion/OBIEE by Amit Sharma. Mail to aloo_a2@yahoo.com for all Hyperion/OBIEE trainings and support
The beauty of Essbase exists in great multidimensional data analytical features for business
users. The users can play around with data features remaining in excel offer by using Essbase
Spread Sheet Client. Business users can play around with data remaining in excel. Indeed excel
being the favorite tools for data analyst. In fact Essbase itself is Extended Spread Sheet Database.
In today’s topic we’ll explore some good features of Essbase client.
Essbase Spreadsheet Add-in is a software program that merges seamlessly with Microsoft Excel.
After Essbase is installed, a special menu is added to the spreadsheet application. The menu
provides enhanced commands such as Connect, Pivot, Drill-down, and Calculate. Users can
access and analyze data on Essbase Server by using simple mouse clicks and drag-and-drop
operations. Spreadsheet Add-in enables multiple users to access and to update data on Essbase
Server simultaneously.
Once you install Essbase Client, you find the Essbase menu appears in Excel with other menus.
The first step is to connect to the Essbase server.
Once you connect to the Essbase server, the next step is to retrieve the data from the cube. Select
Essbase->Retrieve
Download Hyperion/OBIEE tutorials from learnhyperion.wordpress.com
Learn Hyperion/OBIEE by Amit Sharma. Mail to aloo_a2@yahoo.com for all Hyperion/OBIEE trainings and support
Users can now retrieve the account details of the specific account and entity without learning a
new user interface. Essbase client provides many options to analyze the data.
For example i