| Document Type
|
:
|
BL
|
| Record Number
|
:
|
1005501
|
| Doc. No
|
:
|
b759871
|
| Main Entry
|
:
|
Anantapantula, Sarma.
|
| Title & Author
|
:
|
Oracle Essbase 9 implementation guide : : develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase /\ Sarma Anantapantula, Joseph Sydney Gomez ; reviewers, Shekar Kadur, Venkatakrishnan J.
|
| Publication Statement
|
:
|
Birmingham, U.K. :: Packt Pub.,, 2009.
|
| Series Statement
|
:
|
From technologies to solutions
|
| Page. NO
|
:
|
1 online resource (ix, 422 pages) :: illustrations.
|
| ISBN
|
:
|
1282172352
|
|
|
:
|
: 184719687X
|
|
|
:
|
: 6612172355
|
|
|
:
|
: 9781282172357
|
|
|
:
|
: 9781847196873
|
|
|
:
|
: 9786612172359
|
|
|
:
|
1847196861
|
|
|
:
|
9781847196866
|
| Notes
|
:
|
Includes index.
|
|
|
:
|
Title from title screen.
|
| Contents
|
:
|
Cover; Table of Contents; Preface; 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; Aggregate Storage Option (ASO); Block Storage Option (BSO); Unicode and Non-Unicode applications; Creating your first Essbase application
|
|
|
:
|
Essbase Application PropertiesStartup section; Security; Minimum access level; Types of Essbase databases; The normal (non-currency) database; Essbase currency database; Database components; The database outline; Linked Reporting Objects; Partitions; Calculation scripts; Report scripts; Database load rules files; Allowing duplicate member names; Create your first Essbase database; General tab; Dimensions tab; Statistics tab; Caches tab; Transactions tab; Storage tab; Currency tab; Modifications tab; Types of Essbase users; Summary; Chapter 3: Building the Essbase Outline; Before we begin
|
|
|
:
|
Executing MaxL from command promptAttribute dimensions; User Defined Attributes (UDA); Dynamic Time Series; Shared members; Summary; Chapter 4: Loading Data into Essbase; Make your data Essbase-friendly; Essbase-friendly thoughts; Essbase-friendly example; Types of data sources; Type of data; Types of files used for data loads; Relational databases; Data load methods; Data file freeform (no load rule); Essbase export and import (no load rule); Structured data load (load rule used); Microsoft Excel Lock and Send (no load rule); Building your first data load rules file
|
|
|
:
|
Step 1: Start the Data Prep EditorStep 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; Generation reference; Level reference; Parent-child reference; 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; Update your outline using the EAS Outline Editor; Update using MaxL Shell; Executing MaxL from EAS editor
|
|
|
:
|
The Essbase outline-the foundationDimensions and members; Outline member descriptors; Generations and Levels; Generation; Level; Types of dimensions; Standard dimension; The Account dimension type; The Time dimension type; The Country dimension type; No dimension type or general dimension; The Currency Partition dimension type; The Attribute dimension; Dense and Sparse dimensions; Build your first outline; Member properties; Member consolidations; Valid consolidation operators; Member storage; Member formulas; Member alias; Alias table; Build your first data rules file
|
| Abstract
|
:
|
Develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase 9 with this book and eBook.
|
| Subject
|
:
|
Client/server computing.
|
| Subject
|
:
|
Database design.
|
| Subject
|
:
|
OLAP technology.
|
| Subject
|
:
|
System design.
|
| Subject
|
:
|
Client/server computing.
|
| Subject
|
:
|
Client/server computing.
|
| Subject
|
:
|
COMPUTERS-- Client-Server Computing.
|
| Subject
|
:
|
Database design.
|
| Subject
|
:
|
Database design.
|
| Subject
|
:
|
OLAP technology.
|
| Subject
|
:
|
OLAP technology.
|
| Subject
|
:
|
System design.
|
| Subject
|
:
|
System design.
|
| Subject
|
:
|
Essbase (Computer file)
|
|
|
:
|
Essbase (Computer file)
|
|
|
:
|
Essbase (Computer file)
|
| Dewey Classification
|
:
|
005.36
|
| LC Classification
|
:
|
QA76.9.C55A53 2009eb
|
| Added Entry
|
:
|
Gomez, Joseph Sydney.
|
|
|
:
|
J, Venkatakrishnan.
|
|
|
:
|
Kadur, Shekar.
|