SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK ORACLE BUSINESS INTELLIGENCE AND ESSBASE SOLUTIONS GUIDE
SUMMARY
-
Items Found: 160
- Chapter 1 Introduction 1
- In This Chapter 1
- 1.1 Introduction 1
- 1.2 A Basic Business Need 2
- 1.3 What Is Business Intelligence? 3
- 1.4 Why BI? 4
- 1.5 Enabling a Competitive Advantage 4
- 1.6 BI and Reporting Categories 6
- 1.6.1 Operational Reporting 7
- 1.6.2 Analytical BI 8
- 1.6.3 Operational BI 10
- 1.7 Summary 13
- Chapter 2 Why Oracle Essbase Now 15
- In This Chapter 15
- 2.1 Introduction 15
- 2.2 OBIEE and Essbase: History and Importance 16
- 2.3 Why Essbase Now: From History to Historical,
- Analytical, and Beyond 19
- 2.4 Summary 20
- Chapter 3 Oracle Essbase and Oracle BI: Successful
- Players and Products 21
- In This Chapter 21
- 3.1 Introduction 21
- 3.2 The Primary Vendors: Inventors and Presenters 22
- 3.3 The Primary Products and Tools Set: Inclusions
- and Exclusions 23
- 3.3.1 Oracle Exalytics 23
- 3.3.2 Oracle Essbase 24
- 3.3.3 Oracle BI Publisher 25
- 3.3.4 Oracle BI Foundation Suite 25
- 3.3.5 Oracle BI Enterprise Edition (OBIEE) 27
- 3.3.6 Oracle BI Mobile 29
- 3.3.7 Oracle BI Applications 30
- 3.3.8 Oracle BI for Big Data 31
- 3.4 The Primary Users: Evaluators, Investors,
- Implementers and Eventual Benefiters 32
- 3.5 Summary 36
- 3.6 References 36
- Chapter 4 Analysis, Evaluation, and Selection 37
- In This Chapter 37
- 4.1 Introduction 37
- 4.2 Essential Criteria for Requirements Analysis of
- Oracle Essbase and OBIEE as a Comprehensive
- BI Solution 38
- 4.2.1 Business Processes—Discovery and Definition 38
- 4.2.2 Information Integration 39
- 4.2.3 Information Dissemination, Transformation,
- and Visualization 40
- 4.2.4 User Interaction 41
- 4.2.5 Information Customization 41
- 4.2.6 Information in Action: BI, Advanced
- Analytics, and Beyond BI (Competitive,
- Social, and Cloud-Based Intelligence) 42
- 4.2.7 Information and Big Data 42
- 4.3 Key and Critical Deciding Factors in Selecting
- Such a Solution 43
- 4.4 The Final Pick is a Customer-Centric Solution:
- Key Indicator Checklist 44
- 4.5 Summary 46
- 4.6 References 46
- Chapter 5 Data Integration, Implementation, and
- Customization Using Essbase 47
- In This Chapter 47
- 5.1 Introduction 47
- 5.2 Building an Integrated Approach for Data 48
- 5.2.1 Recommendations 49
- 5.3 Implementation Specifics of Data, from Data
- Source to Data Analytics 51
- 5.4 Semantic Integration between OBIEE and
- Essbase, Using OBIEE as a Data Source for
- Oracle Essbase 52
- 5.4.1 Recommendations 53
- 5.4.2 Implementation Specifics 55
- 5.4.3 Using OBIEE 12c for Essbase 12c 56
- 5.5 Extending and Customizing Essbase 57
- 5.5.1 Extending Essbase Cubes 57
- 5.5.2 Analytics That Can Be Applied to
- Custom Implementations 59
- 5.5.3 Best Practices and Additional
- Customization Scenarios 60
- 5.6 Summary 62
- 5.7 References 63
- x Oracle Business Intelligence and Essbase Solutions Guide
- Chapter 6 Using Essbase for Analytical BI 65
- In This Chapter 65
- 6.1 Introduction 65
- 6.2 What Kind of Analytics Are Good for Essbase
- Cubes? 66
- 6.2.1 Recommendations 68
- 6.3 Implementation Specifics of Using Analytical BI
- Using Essbase 68
- 6.3.1 Using Essbase for Analytical BI 69
- 6.3.2 Using BSO Cubes for Analytical BI 71
- 6.3.3 Using ASO Cubes for Analytical BI 73
- 6.4 Summary 73
- 6.5 References 75
- Chapter 7 Using OBIEE for Operational BI 77
- In This Chapter 77
- 7.1 Introduction 77
- 7.2 Don’t Let Your Tool Wag Your Data 78
- 7.3 Categories for Business Intelligence and Reporting 80
- 7.4 What Is Operational Business Intelligence? 82
- 7.4.1 The Ultimate Goal: Insight to Interaction 83
- 7.5 Delivering Operational BI 84
- 7.5.1 Operational BI and OBIEE 85
- 7.5.2 Updating the Enterprise Data Warehouse
- for Operational BI 87
- 7.6 The Operational Data Store Option 91
- 7.7 Summary 94
- Chapter 8 Using OBIEE for Self-Service BI 97
- In This Chapter 97
- 8.1 Introduction 97
- 8.2 In Search of Self-Service BI 98
- 8.3 Enter OBIEE as a Solution 99
- 8.4 OBIEE for Self-Service BI 101
- 8.5 Big Data and Self-Service BI 103
- 8.5.1 OBIEE12c and Big Data 104
- 8.6 Summary 105
- Chapter 9 Best Practices for Solution Implementation
- and Customization 107
- In This Chapter 107
- 9.1 Introduction 107
- 9.2 Establishing a Data Foundation Based on a
- Logical Model 108
- 9.3 Extending the Logical Data Model for
- Implementation and Customization 110
- 9.3.1 Using the Logical Model To Extend
- Essbase Cubes 111
- 9.3.2 Building Analytics That Can Be Applied
- to Custom Implementations 112
- 9.3.3 Best Practices and Additional
- Customization Scenarios 114
- 9.4 The Logical Model as a Scalable Best Practice
- Solution 116
- 9.5 Summary 117
- Chapter 10 Use Case Scenarios 119
- In This Chapter 119
- 10.1 Introduction 119
- 10.2 The Challenge 120
- 10.3 The Resolution 123
- 10.4 Summary 124
- Chapter 11 The Prize for the Price: A Win–Win or Not 125
- In This Chapter 125
- 11.1 Introduction 125
- 11.2 The True Value of Expertise 126
- 11.3 Data-Driven Development 126
- 11.4 A 360-Degree View of a Holistic Solution 127
- 11.5 Summary 128
- Appendix A: Oracle Big Data and the Cloud for Analytics 131
- A.1 Using the Cloud To Unleash the Potential of
- Big Data 131
- A.2 Oracle’s Role in Cloud Services and Big Data 132
- A.3 Beyond BI 133
- References 133
- Appendix B: Slides from Data Warehouse Architectures 135
- B.1 Overview of the Corporate Information Factory
- and Dimensional Modeling 135
- B.2 Slides from OBIEE 12c Presentation 144
- Appendix C: Oracle® Data Sheets 155
- Index 167
