Coverart for item
The Resource 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

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

Label
Oracle Essbase 9 implementation guide : develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase
Title
Oracle Essbase 9 implementation guide
Title remainder
develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase
Statement of responsibility
Sarma Anantapantula, Joseph Sydney Gomez ; reviewers, Shekar Kadur, Venkatakrishnan J
Creator
Contributor
Author
Reviewer
Subject
Genre
Language
eng
Summary
Develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase 9 with this book and eBook
Member of
Cataloging source
YUS
http://library.link/vocab/creatorName
Anantapantula, Sarma
Dewey number
005.36
Illustrations
illustrations
Index
index present
Language note
English
LC call number
QA76.9.C55
LC item number
A53 2009eb
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
  • Gomez, Joseph Sydney
  • Kadur, Shekar
  • J, Venkatakrishnan
Series statement
From technologies to solutions
http://library.link/vocab/subjectName
  • Client/server computing
  • OLAP technology
  • Database design
  • System design
  • COMPUTERS
  • Client/server computing
  • OLAP technology
  • Database design
  • System design
  • Client/server computing
  • Database design
  • OLAP technology
  • System design
Label
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
Instantiates
Publication
Note
  • Title from title screen
  • Includes index
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
other
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
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
  • 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
  • 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
  • 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
Control code
440648004
Dimensions
unknown
Extent
1 online resource (ix, 422 pages)
Form of item
online
Isbn
9781847196873
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000068
Specific material designation
remote
System control number
(OCoLC)440648004
Label
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
Note
  • Title from title screen
  • Includes index
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
other
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
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
  • 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
  • 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
  • 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
Control code
440648004
Dimensions
unknown
Extent
1 online resource (ix, 422 pages)
Form of item
online
Isbn
9781847196873
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000068
Specific material designation
remote
System control number
(OCoLC)440648004

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...