Record Detail Back
Oracle Business Intelligence 11g R1 Cookbook
- Share to:
Chapter 1, Exploring and Building the Repository, discusses the major components of Oracle Business Intelligence Enterprise Edition 11g and the basics of the repository. This chapter covers how to create a blank repository and set up the three layers of the repository from the beginning. At the end of this chapter, we're going to upload the new repository and make tests by running sample analyses.
Chapter 2, Working with Logical Dimensions, covers the different types of dimension hierarchies in depth. Both the level-based and the parent-child hierarchies will be discussed and you're going to learn how to create them. We will also create the level-based measures and presentation hierarchies.
Chapter 3, Using Aggregates and the Time Series Functions, covers the creation and usage
of aggregate tables in order to improve query performance. There are two methods of implementing the aggregate tables and both of them will be covered. Also, we will discuss the advantages of the time series functions in this chapter. You're going to learn how to create the measure columns that include these functions in their formula.
Chapter 4, Working with Multidimensional Data Sources, offers an overview of the multidimensional sources, which are definitely important in business intelligence projects. We will discuss the implementation of the cubes in the repository. Essbase cubes are going to be used in our sample scenario.
Chapter 5, Security in Oracle BI, discusses security concepts. Authentication and authorization methods are also covered. Setting up the permissions on the repository objects, configuring the query limits, and creating the data filters are the other subjects that you'll find in this chapter.
Chapter 6, Managing Usage Tracking and Enabling the Cache, covers how to enable usage tracking, as monitoring the users' behaviors is very important in BI projects. Also, we will discuss the advantages of the cache mechanism in the BI server and you will learn how to maintain the cache.
Chapter 7, Creating Simple Oracle Business Intelligence Analyses, tells you about the basics of analyses. We're going to construct a simple analysis and discuss the properties of the views that are used in the analyses. You will learn how to change the formatting options of table views and discover the usage of filter types. Also, we will use selections in this chapter.
Chapter 8, Adding Views to Analyses and Advanced Features, offers the usage of additional views other than the table view. Pivot table views, gauge views, graph views, column selector views, and the other view types are going to be covered. You will also learn how to configure the master-detail setting in this chapter.
Chapter 9, Measuring Performance with Key Performance Indicators, discusses the need for Key Performance Indicators. You will learn how to create KPIs and how to publish them in the dashboards. KPIs are the building blocks of Enterprise Performance Management so scorecards are also going to be covered in this chapter.
Chapter 10, Creating and Configuring Dashboards, covers the creation and the configuration of the dashboards in Presentation Services. You will explore the object types that you can publish in the dashboards. You will also discover the dashboard prompts and learn how to create them with all the details.
Chapter 11, Oracle BI Best Practices, offers the best practices of the implementation steps in Oracle BI projects. You will find recommendations about the repository including all three layers. Then we will discuss the design of the analyses and the dashboards. Also you will find important tips about performance and security.
Appendix, The Major Components of OBIEE 11g, explores the major components of OBIEE 11g and discusses the role of each component. Also, processing steps of an analysis will be covered.
Cuneyt Yilmaz - Personal Name
978-1-84968-600-6
NONE
Business Policy and Strategy
English
LOADING LIST...
LOADING LIST...