Coverpage
Copyright Information
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
Chapter 1. Installing Oracle Essbase
Installing the Essbase analytic server
Installing Essbase Administration Services
Starting the EAS
Installing the Essbase Add-in for Microsoft Excel
A typical network setup
Summary
Chapter 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
Chapter 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
Update your outline using a rules file
Attribute dimensions
User Defined Attributes (UDA)
Dynamic Time Series
Shared members
Summary
Chapter 4. Loading Data into Essbase
Make your data Essbase-friendly
Types of data sources
Data load methods
Building your first data load rules file
Loading data into your database
Data Load vs. Dimension Build
Summary
Chapter 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
Chapter 6. Using your Essbase Cube
Using your Essbase database
Ways to extract your Essbase data
The Essbase Report Script
Executing your report scripts
Previewing data in EAS
Summary
Chapter 7. Getting the most out of the Microsoft Excel Add-in
Reporting with the Microsoft Excel Add-in
Using the Essbase Query Designer
Summary
Chapter 8. Automating your Essbase Cube
Essbase command scripts (EssCmd)
Essbase MaxL scripts
Essbase Application Programming Interface (API)
Summary
Chapter 9. Advanced Techniques
Performance tuning your database
The shape of your database outline
Database configuration settings
Partitioning databases
Analytic server configuration file
Memory management
Summary
Chapter 10. Essbase Analytics Option
What is ASO
MDX query language
Pros and cons of ASO and BSO
Summary
Chapter 11. Essbase System 9 Components
Overview of System 9 components
Summary
Appendix A. A New Essbase Companion—Oracle Smart View
Reporting with Oracle Smart View
Index
更新时间：2021-04-01 14:19:11
完结共116章
倒序