舉報 
會員
Oracle Essbase 9 Implementation Guide
最新章節(jié)：
Index
Thisbookusesapracticalstep-by-stepapproachwiththenextchapteralwaysbuildingontheknowledgefoundationcreatedbythepreviouschapter.Understandingandreallygraspingthemultidimensionalconceptisdifficultenoughwithoutalotofconfusingjargonthrownin.ThisbookspeakstothereaderinplainEnglishwithplentyofeasy-to-followexamples.Youwillcreate,build,andmaintaindataforafictionalautomobilecompany.ThisbookisprimarilyfortheITprofessionalwhohasagoodunderstandingofITprinciplesandprocessesbutisamultidimensionalOLAPnovice.ExperiencedOLAPprofessionalswillalsogaininsightfromthisbook.Simplyput,ifyouareintheITfieldandwishtogainafunctionallevelofknowledgeintheworldofOracleEssbase,whetheritbeforadeveloperroleoraPMorBArole,thisisthebookyouneed.
目錄(116章)
倒序
- 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
推薦閱讀
- Photoshop CC 網(wǎng)店視覺設(shè)計
- 改變思維：菜鳥也能做出震撼PPT（全彩版）
- Liferay User Interface Development
- 中文版AutoCAD 2022基礎(chǔ)教程
- 從零開始：Illustrator CC中文版基礎(chǔ)培訓(xùn)教程
- Linux Shell Scripting Cookbook
- Photoshop CC完全自學(xué)教程：從入門到實踐（全新版）
- 攝影師的后期必修課（調(diào)色篇）
- 魔法詞典：AI繪畫關(guān)鍵詞圖鑒（Midjourney版）
- 電腦寫作與定制五筆（第2版）
- 中文版Flash CC實例教程
- Creo 4.0中文版基礎(chǔ)教程
- Panda3d 1.7 Game Developer's Cookbook
- AutoCAD 2021中文版從入門到精通
- 新編中文版Photoshop平面設(shè)計入門與提高（第2版）
- 高手之路：Lightroom系統(tǒng)教程
- Stata統(tǒng)計分析從入門到精通
- Python圖像處理實戰(zhàn)
- 中文版Premiere Pro CC入門教程（全彩版）
- Premiere視頻編輯案例教程：Premiere Pro 2020（全彩微課版·第2版）
- Building Online Stores with osCommerce: Professional Edition
- Adobe Dreamweaver CS5 網(wǎng)頁設(shè)計與制作技能基礎(chǔ)教程
- VR虛擬現(xiàn)實：技術(shù)革命+商業(yè)應(yīng)用+經(jīng)典案例
- Axure RP案例教程
- 中文版Photoshop 2022從入門到實戰(zhàn)視頻教程（全彩版）
- AJAX and PHP: Building Responsive Web Applications
- Drupal 6 Performance Tips
- ZBrush雕刻大師火星課堂
- Asterisk Gateway Interface 1.4 and 1.6 Programming
- Eviews實戰(zhàn)與數(shù)據(jù)分析
