Dedication |
|
v | |
Contents |
|
vii | |
Foreword |
|
xiii | |
|
Preface |
|
xvii | |
Acknowledgments |
|
xxiii | |
About the Authors |
|
xxv | |
|
|
1 | (14) |
|
|
1 | (1) |
|
|
1 | (1) |
|
1.2 A Basic Business Need |
|
|
2 | (1) |
|
1.3 What Is Business Intelligence? |
|
|
3 | (1) |
|
|
4 | (1) |
|
1.5 Enabling a Competitive Advantage |
|
|
4 | (2) |
|
1.6 BI and Reporting Categories |
|
|
6 | (7) |
|
1.6.1 Operational Reporting |
|
|
7 | (1) |
|
|
8 | (2) |
|
|
10 | (3) |
|
|
13 | (2) |
|
Chapter 2 Why Oracle Essbase Now |
|
|
15 | (6) |
|
|
15 | (1) |
|
|
15 | (1) |
|
2.2 OBIEE and Essbase: History and Importance |
|
|
16 | (3) |
|
2.3 Why Essbase Now: From History to Historical, Analytical, and Beyond |
|
|
19 | (1) |
|
|
20 | (1) |
|
Chapter 3 Oracle Essbase and Oracle BI: Successful Players and Products |
|
|
21 | (16) |
|
|
21 | (1) |
|
|
21 | (1) |
|
3.2 The Primary Vendors: Inventors and Presenters |
|
|
22 | (1) |
|
3.3 The Primary Products and Tools Set: Inclusions and Exclusions |
|
|
23 | (9) |
|
|
23 | (1) |
|
|
24 | (1) |
|
3.3.3 Oracle BI Publisher |
|
|
25 | (1) |
|
3.3.4 Oracle BI Foundation Suite |
|
|
25 | (2) |
|
3.3.5 Oracle BI Enterprise Edition (OBIEE) |
|
|
27 | (2) |
|
|
29 | (1) |
|
3.3.7 Oracle BI Applications |
|
|
30 | (1) |
|
3.3.8 Oracle BI for Big Data |
|
|
31 | (1) |
|
3.4 The Primary Users: Evaluators, Investors, Implementers and Eventual Benefiters |
|
|
32 | (4) |
|
|
36 | (1) |
|
|
36 | (1) |
|
Chapter 4 Analysis, Evaluation, and Selection |
|
|
37 | (10) |
|
|
37 | (1) |
|
|
37 | (1) |
|
4.2 Essential Criteria for Requirements Analysis of Oracle Essbase and OBIEE as a Comprehensive BI Solution |
|
|
38 | (5) |
|
4.2.1 Business Processes--Discovery and Definition |
|
|
38 | (1) |
|
4.2.2 Information Integration |
|
|
39 | (1) |
|
4.2.3 Information Dissemination, Transformation, and Visualization |
|
|
40 | (1) |
|
|
41 | (1) |
|
4.2.5 Information Customization |
|
|
41 | (1) |
|
4.2.6 Information in Action: BI, Advanced Analytics, and Beyond BI (Competitive, Social, and Cloud-Based Intelligence) |
|
|
42 | (1) |
|
4.2.7 Information and Big Data |
|
|
42 | (1) |
|
4.3 Key and Critical Deciding Factors in Selecting Such a Solution |
|
|
43 | (1) |
|
4.4 The Final Pick is a Customer-Centric Solution: Key Indicator Checklist |
|
|
44 | (2) |
|
|
46 | (1) |
|
|
46 | (1) |
|
Chapter 5 Data Integration, Implementation, and Customization Using Essbase |
|
|
47 | (18) |
|
|
47 | (1) |
|
|
47 | (1) |
|
5.2 Building an Integrated Approach for Data |
|
|
48 | (3) |
|
|
49 | (2) |
|
5.3 Implementation Specifics of Data, from Data Source to Data Analytics |
|
|
51 | (1) |
|
5.4 Semantic Integration between OBIEE and Essbase, Using OBIEE as a Data Source for Oracle Essbase |
|
|
52 | (5) |
|
|
53 | (2) |
|
5.4.2 Implementation Specifics |
|
|
55 | (1) |
|
5.4.3 Using OBIEE 12c for Essbase 12c |
|
|
56 | (1) |
|
5.5 Extending and Customizing Essbase |
|
|
57 | (5) |
|
5.5.1 Extending Essbase Cubes |
|
|
57 | (2) |
|
5.5.2 Analytics That Can Be Applied to Custom Implementations |
|
|
59 | (1) |
|
5.5.3 Best Practices and Additional Customization Scenarios |
|
|
60 | (2) |
|
|
62 | (1) |
|
|
63 | (2) |
|
Chapter 6 Using Essbase for Analytical BI |
|
|
65 | (12) |
|
|
65 | (1) |
|
|
65 | (1) |
|
6.2 What Kind of Analytics Are Good for Essbase Cubes? |
|
|
66 | (2) |
|
|
68 | (1) |
|
6.3 Implementation Specifics of Using Analytical BI Using Essbase |
|
|
68 | (5) |
|
6.3.1 Using Essbase for Analytical BI |
|
|
69 | (2) |
|
6.3.2 Using BSO Cubes for Analytical BI |
|
|
71 | (2) |
|
6.3.3 Using ASO Cubes for Analytical BI |
|
|
73 | (1) |
|
|
73 | (2) |
|
|
75 | (2) |
|
Chapter 7 Using OBIEE for Operational BI |
|
|
77 | (20) |
|
|
77 | (1) |
|
|
77 | (1) |
|
7.2 Don't Let Your Tool Wag Your Data |
|
|
78 | (2) |
|
7.3 Categories for Business Intelligence and Reporting |
|
|
80 | (2) |
|
7.4 What Is Operational Business Intelligence? |
|
|
82 | (2) |
|
7.4.1 The Ultimate Goal: Insight to Interaction |
|
|
83 | (1) |
|
7.5 Delivering Operational BI |
|
|
84 | (7) |
|
7.5.1 Operational BI and OBIEE |
|
|
85 | (2) |
|
7.5.2 Updating the Enterprise Data Warehouse for Operational BI |
|
|
87 | (4) |
|
7.6 The Operational Data Store Option |
|
|
91 | (3) |
|
|
94 | (3) |
|
Chapter 8 Using OBIEE for Self-Service BI |
|
|
97 | (10) |
|
|
97 | (1) |
|
|
97 | (1) |
|
8.2 In Search of Self-Service BI |
|
|
98 | (1) |
|
8.3 Enter OBIEE as a Solution |
|
|
99 | (2) |
|
8.4 OBIEE for Self-Service BI |
|
|
101 | (2) |
|
8.5 Big Data and Self-Service BI |
|
|
103 | (2) |
|
8.5.1 OBIEE12c and Big Data |
|
|
104 | (1) |
|
|
105 | (2) |
|
Chapter 9 Best Practices for Solution Implementation and Customization |
|
|
107 | (12) |
|
|
107 | (1) |
|
|
107 | (1) |
|
9.2 Establishing a Data Foundation Based on a Logical Model |
|
|
108 | (2) |
|
9.3 Extending the Logical Data Model for Implementation and Customization |
|
|
110 | (6) |
|
9.3.1 Using the Logical Model To Extend Essbase Cubes |
|
|
111 | (1) |
|
9.3.2 Building Analytics That Can Be Applied to Custom Implementations |
|
|
112 | (2) |
|
9.3.3 Best Practices and Additional Customization Scenarios |
|
|
114 | (2) |
|
9.4 The Logical Model as a Scalable Best Practice Solution |
|
|
116 | (1) |
|
|
117 | (2) |
|
Chapter 10 Use Case Scenarios |
|
|
119 | (6) |
|
|
119 | (1) |
|
|
119 | (1) |
|
|
120 | (3) |
|
|
123 | (1) |
|
|
124 | (1) |
|
Chapter 11 The Prize for the Price: A Win--Win or Not |
|
|
125 | (6) |
|
|
125 | (1) |
|
|
125 | (1) |
|
11.2 The True Value of Expertise |
|
|
126 | (1) |
|
11.3 Data-Driven Development |
|
|
126 | (1) |
|
11.4 A 360-Degree View of a Holistic Solution |
|
|
127 | (1) |
|
|
128 | (3) |
|
Appendix A Oracle Big Data and the Cloud for Analytics |
|
|
131 | (4) |
|
A.1 Using the Cloud To Unleash the Potential of Big Data |
|
|
131 | (1) |
|
A.2 Oracle's Role in Cloud Services and Big Data |
|
|
132 | (1) |
|
|
133 | (2) |
|
|
133 | (2) |
|
Appendix B Slides from Data Warehouse Architectures |
|
|
135 | (20) |
|
B.1 Overview of the Corporate Information Factory and Dimensional Modeling |
|
|
135 | (9) |
|
B.2 Slides from OBIEE 12c Presentation |
|
|
144 | (11) |
|
Appendix C Oracle® Data Sheets |
|
|
155 | (12) |
Index |
|
167 | |