Book description
Develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase 9 with this book and eBook
About This Book
Build multidimensional Essbase database cubes and develop analytical Essbase applications
Step-by-step instructions with expert tips from installation to implementation
Can be used to learn any version of Essbase starting from 4.x to 11.x
For beginners as well as experienced professionals; no Essbase experience required
Who This Book Is For
This book is primarily for the IT professional who has a good understanding of IT principles and processes but is a multidimensional OLAP novice. Experienced OLAP professionals will also gain insight from this book.
Simply put, if you are in the IT field and wish to gain a functional level of knowledge in the world of Oracle Essbase, whether it be for a developer role or a PM or BA role, this is the book you need.
What You Will Learn
Dig into the concept of multidimensional database cubes and explore the similarities to and differences from traditional relational databases
Build effective database outlines including dimensions and members
Extract data from source systems like SQL Sources or Input Data Files and load them into Essbase cubes
Create fast and efficient database calculation scripts for your Essbase applications
Extract data into reports or downstream systems by writing professional database report scripts
Make your work easier by automating Essbase processes like cube building or running calc and report scripts
Generate quality dynamic ad hoc spreadsheets and reports by using Microsoft's Excel Add-In effectively
Perform required and optional maintenance and performance-tuning tasks just like an experienced Essbase administrator
In Detail
The hot new data analysis trends involve business intelligence and analytics. The technology that supports business intelligence and analytics better than anything else is today's multidimensional OLAP technology ? and there is none better than Oracle Essbase! Although storing data in a cube and developing analytical applications leaves many people grasping for understanding, especially if their experience is with relational databases, embracing OLAP technology will pay big dividends in the long run.
It's easy to develop multidimensional analytic OLAP solutions when you have got this Oracle Essbase book to hand. It is a step-by-step guide to timeless Essbase fundamentals, which takes you from a basic software installation through to launching a fully functioning Essbase database cube.
This book will guide you through every stage of installing Oracle's Essbase software on your analytic server, the Essbase Administration Services client, and the client software itself. You will learn, in easy-to-understand language, the concepts of multidimensional database technology as you are taken step by step through building an actual Essbase application complete with database, database calculation scripts, and database report scripts.
Once you have your system built and functional, the next course of instruction covers the available automation features included in your Essbase software package and how to use them. These chapters alone are worth the price of admission! As an IT professional you quite rightly have a desire to understand multidimensional OLAP ? this book gives you that understanding. Should you wish to embark on an exciting career as an Essbase developer/administrator, this book provides a fantastic foundation from which to grow.
Best of all, this book is filled with the tips and tricks that you can only get from many years and countless hours spent playing with Essbase. You get them all in just the time it takes you to complete this book.
Style and approach
This book uses a practical step-by-step approach with the next chapter always building on the knowledge foundation created by the previous chapter.
Understanding and really grasping the multidimensional concept is difficult enough without a lot of confusing jargon thrown in. This book speaks to the reader in plain English with plenty of easy-to-follow examples. You will create, build, and maintain data for a fictional automobile company.
Table of contents
-
Oracle Essbase 9 Implementation Guide
- Table of Contents
- Oracle Essbase 9 Implementation Guide
- Credits
- About the Authors
- About the Reviewer
- Acknowledgements
-
Preface
- A brief history on Essbase
- Why Essbase
- What this book covers
- Who this book is for
- Versions covered in this book
- Data warehousing concepts
- The fathers of the data warehouse
- Different types of data warehouses
- Data warehouse data modeling
- The Third Normal Form (3NF)
- The Dimensional Data Model
- Where does Essbase fit in this
- Conventions
- Let's get started
- Reader feedback
- Customer support
- Errata
- Piracy
- Questions
- 1. Installing Oracle Essbase
-
2. Essbase Data and Design Considerations
- Introduction to OLAP
- Determining the data requirements
- Determine data storage options
- Types of Essbase applications
- Creating your first Essbase application
- Types of Essbase databases
- Database components
- Allowing duplicate member names
- Create your first Essbase database
- Types of Essbase users
- Summary
-
3. Building the Essbase Outline
- Before we begin
- The Essbase outline—the foundation
- Dimensions and members
- Types of dimensions
- Build your first outline
- Member properties
-
Build your first data rules file
- Step 1: Start the Data Prep Editor
- Step 2: Associate the Dimension Build Rules file
- Step 3: Open data load file or the SQL data source file
- Step 4: Set the Data Source Properties
- Step 5: Set the View to Dimension build fields
- Step 6: Select Dimension build method
- Step 7: Format file
- Step 8: Associate fields with dimensions
- Step 9: Validate the Dimension Build rules file
- Update your outline using a rules file
- Attribute dimensions
- User Defined Attributes (UDA)
- Dynamic Time Series
- Shared members
- Summary
-
4. Loading Data into Essbase
- Make your data Essbase-friendly
- Types of data sources
- Data load methods
-
Building your first data load rules file
- Step 1: Starting the Data Prep Editor
- Step 2: Associating the data load rules file
- Step 3: Opening data load file or the SQL data source file
- Step 4: Setting the View to Data Load Fields
- Step 5: Setting the Data Source Properties
- Step 6: Updating the Data Load Settings
- Step 7: Setting the Data Load Values
- Step 8: Associating fields with Data Load Properties
- Step 9: Validating the data load rules file
- Step 10: Saving the data load rules file
- Loading data into your database
- Data Load vs. Dimension Build
- Summary
-
5. Calculating your Essbase Cube
- Calculating your database
- Calculation types explained
- Essbase calculation terminology
- Default database calculation script
- Calc All
- Calculate/Aggregate dimension
- Essbase Calc commands and functions
- Order of calculation
- Two-Pass Calc
- Using Substitution Variables
- Building your first Calculation Script
- Executing your Calculation Scripts
- Summary
- 6. Using your Essbase Cube
-
7. Getting the most out of the Microsoft Excel Add-in
-
Reporting with the Microsoft Excel Add-in
- Connecting to Essbase
- Disconnecting from Essbase
- Launching the Essbase Query Designer
- Retrieving data from Essbase
- Setting the add-in spreadsheet options
- Selecting Essbase members for your query
- Using the Keep Only function
- Using the Remove Only function
- Zooming in on your data
- Zooming out on your data
- Pivot Essbase members on your spreadsheet
- Flashback: The Essbase Add-in Undo
- Locking the data and retrieving
- Locking the data
- Unlocking the locked data
- Sending your data to the database
- Running a database calculation
- Retrieving your sheet without data
- Zooming in on sample data
- Linking objects to your data
- Creating graphical data representations
- Using the currency conversion tool
- Custom Microsoft Excel workbook reporting
- A final word on the Essbase add-in
- Using the Essbase Query Designer
- Summary
-
Reporting with the Microsoft Excel Add-in
-
8. Automating your Essbase Cube
- Essbase command scripts (EssCmd)
-
Essbase MaxL scripts
- Logging on to the Essbase server
- Working with an Essbase application in MaxL
- Working with an Essbase database from MaxL
- Working with data in MaxL
- Working with database calculations in MaxL
- Working with user privileges in MaxL
- Working at the System level with MaxL
- Substitution variables
- Executing a MaxL statement
- Executing MaxL from Command Prompt
- Executing MaxL from EAS
- Essbase Application Programming Interface (API)
- Summary
- 9. Advanced Techniques
- 10. Essbase Analytics Option
-
11. Essbase System 9 Components
-
Overview of System 9 components
- Essbase Analytic Services (Essbase agent)
- Essbase Planning
- Essbase analytics
- Hyperion Application Link/Oracle Application Link
- Oracle Business Rules
- Oracle Reports
- Essbase Shared Services
- Oracle Essbase Provider Services
- Essbase Smart Office
- Oracle Essbase Financial Reporting
- Smart View for Microsoft Office
- Summary
-
Overview of System 9 components
- A. A New Essbase Companion—Oracle Smart View
- Index
Product information
- Title: Oracle Essbase 9 Implementation Guide
- Author(s):
- Release date: June 2009
- Publisher(s): Packt Publishing
- ISBN: 9781847196866
You might also like
book
The CIO's Guide to Oracle Products and Solutions
This book is the go-to guide for all things Oracle. It provides management-level guidance for successfully …
book
Oracle Essbase & Oracle OLAP
The only book to cover and compare Oracle's online analytic processing products With the acquisition of …
book
MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition
Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, …
book
Oracle Data Integrator 11g Cookbook
This book is all you need to take your understanding of Oracle Data Integrator to the …