- Paperback: 1027 pages
- Publisher: McGraw-Hill Osborne (1 May 2006)
- Language English
- ISBN-10: 0749448512
- ISBN-13: 978-0072262148
- ASIN: 0072262141
- Product Dimensions: 23.2 x 19.6 x 5.2 cm
-
Amazon Bestsellers Rank:
342,451 in Books (See Top 100 in Books)
- #80 in Books > Computers & Internet > Computer Science > Databases > Applications > Oracle
- See Complete Table of Contents
 Trade In this Item for up to £6.35
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Oracle Discoverer 10g Handbook: Create, Maintain, and Administer Effective Ad Hoc Queries (Oracle (McGraw-Hill)) for an Amazon.co.uk gift card of up to £6.35, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Product details |
More About the Author
Product Description
Product Description
Generate detailed reports that will give your company the competitive edge
Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10g and the comprehensive information contained in this Oracle Press guide. You’ll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10g.
- Set up, configure, and manage Oracle Business Intelligence Discoverer 10g
- Perform ad hoc and fixed queries using the Workbook Wizard
- Integrate sorts, calculations, percentages, and parameters using Discoverer Plus
- Create reports with graphs, tables, titles, headers, footers, and margins
- Use Discoverer Viewer to review, format, export, email, and print reports
- Refine queries using interactive pivoting, drilling, and Hyper Drilling
- Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager
- Establish access and sharing rights, and scheduling privileges with Discoverer Administrator
- Set up and use Portal using Discoverer Portlet Provider and Portlets
- Implement query shortcuts, cascading parameters and advanced analytic calculations using templates
Book Description
Generate detailed reports that will give your company the competitive edge
Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10g and the comprehensive information contained in this Oracle Press guide. You’ll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10g.
- Set up, configure, and manage Oracle Business Intelligence Discoverer 10g
- Perform ad hoc and fixed queries using the Workbook Wizard
- Integrate sorts, calculations, percentages, and parameters using Discoverer Plus
- Create reports with graphs, tables, titles, headers, footers, and margins
- Use Discoverer Viewer to review, format, export, email, and print reports
- Refine queries using interactive pivoting, drilling, and Hyper Drilling
- Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager
- Establish access and sharing rights, and scheduling privileges with Discoverer Administrator
- Set up and use Portal using Discoverer Portlet Provider and Portlets
- Implement query shortcuts, cascading parameters and advanced analytic calculations using templates
Inside This Book
(Learn More)
Front Cover | Copyright | Table of Contents | Excerpt | Index
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
10 reviews
11 of 11 people found the following review helpful
Keep this one within arms reach
17 Mar 2006
Format:Paperback
I have been reading this book since I got it a few days ago non-stop. Both at home (with glares from the Mrs.), and at the office (office door shut, of course) I am gleefully plowing thru this read. Now that I have just completed the book, I keep it within arms reach, as I will undoubtedly refer to it often, as Discoverer Administrator at my job.
I have been using Discoverer now for about 5 years, but I have learned so much in the last few days with this book. "Chapter 20 - Configuring Discoverer" was, for me, the most insightful. It's Discoverer from a DBA's point of view (using OEM, setting the preferences, etc.) and knowing the settings and options that I don't get to see on a daily basis helps me better understand what is in the realm of possibility that I might not have known to ask.
Also key for me was the simple and conversational tone of the book. I, like many Discoverer users I would surmise, do not have an IT background, as Discoverer itself is so simple to use that it hides that complexity and lets you focus on the desired end result. This book is consistent with that spirit of Discoverer in that it's not a lot of technical jargon, and it's got lots of screen shots, so a person with little or no Discoverer experience can pick this up and use it immediately.
"Chapter 16 - Introducing Discoverer OLAP" was a great chapter as well, as it explains in detail the advantages of using the OLAP (as opposed to relational) feature of 10g. Even though I don't presently have plans for implementing it, it's so informative, I know what to expect if and when the need ever arises.
Finally, as an experienced Discoverer user, my favorite chapters were the appendices, specifically Appendix A and B. Appendix A are dozens of questions regarding the use of Discoverer, as well as scripts you can implement to make life easier (my favorite is the detail of the calculations to count business days between 2 dates). Appendix B is a comprehensive listing of Functions with examples, and I'm expecting that will be the part of the book I'll revisit most.
I highly recommend this book; it covers all aspects of Discoverer from report writing to administration, to portlet publication. Well-written and well worth the price.
I have been using Discoverer now for about 5 years, but I have learned so much in the last few days with this book. "Chapter 20 - Configuring Discoverer" was, for me, the most insightful. It's Discoverer from a DBA's point of view (using OEM, setting the preferences, etc.) and knowing the settings and options that I don't get to see on a daily basis helps me better understand what is in the realm of possibility that I might not have known to ask.
Also key for me was the simple and conversational tone of the book. I, like many Discoverer users I would surmise, do not have an IT background, as Discoverer itself is so simple to use that it hides that complexity and lets you focus on the desired end result. This book is consistent with that spirit of Discoverer in that it's not a lot of technical jargon, and it's got lots of screen shots, so a person with little or no Discoverer experience can pick this up and use it immediately.
"Chapter 16 - Introducing Discoverer OLAP" was a great chapter as well, as it explains in detail the advantages of using the OLAP (as opposed to relational) feature of 10g. Even though I don't presently have plans for implementing it, it's so informative, I know what to expect if and when the need ever arises.
Finally, as an experienced Discoverer user, my favorite chapters were the appendices, specifically Appendix A and B. Appendix A are dozens of questions regarding the use of Discoverer, as well as scripts you can implement to make life easier (my favorite is the detail of the calculations to count business days between 2 dates). Appendix B is a comprehensive listing of Functions with examples, and I'm expecting that will be the part of the book I'll revisit most.
I highly recommend this book; it covers all aspects of Discoverer from report writing to administration, to portlet publication. Well-written and well worth the price.
7 of 7 people found the following review helpful
Outstanding Resource!
5 May 2006
Format:Paperback|Amazon Verified Purchase
I am a neophyte to Discoverer, having just accepted a position where the primary assignment is to learn discoverer and develop a library.
I think the true measure of this type of book is how well it takes someone who has little knowledge and walks them through the process of learning. Often times, this type of book slides into language or discourse that seems aimed at higher-end users or impressing people with the depth of knowledge, jargon and acronymns.
In particular, because Discoverer is a tool aimed at the end-user, who may or may not have a great deal of background with Oracle databases themselves (mine is limited), this book faces the challenge of addressing the needs of both the end-user without high-end technical savvy as well as the administrator who knows Oracle backward and forward.
I'm happy to say that I am rapidly gaining knowledge working through this book, as if I were sitting in a training class.
The progression of this book is as follows:
A. Getting Started with Discoverer
1. An Overview of Discoverer.
2. Users and Databases.
3. Getting Started in Discoverer.
4. The Workbook Wizard: The Essential Steps
5. The Workbook Wizard: The Optional Steps
B. Editing the Query
6. Formatting the Output in Discoverer Desktop and Plus
7. Using Graphs to Present Data
8. Turning a Discoverer Query into a Report
9. Using Discoverer to Analyze Data
10. Business Intelligence Discoverer Viewer 10g Release 2 (10.1.2)
C. Advanced Discoverer Techniques
11. Refining Items, Drilling, and Hyper-Drilling
12. Building Effective Conditions
13. Refining Parameters, Calculations, Sorting, and Percentages
14. Query Management
15. User Preferences, the Toolbar, and the Discoverer Administrator
16. Introducing Discoverer OLAP
D. Using the Discoverer Administration Edition
17. Getting Started in the Administration Edition
18. Editing the Business Area
19. Interacting with the End User
20. Configuring Discoverer
21. Setting Up Portal for Use with Discoverer
22. Summary Management
The appendicies are targeted and helpful.
All in all, I can't say enough good about this book. It filled the need exactly and efficiently.
I think the true measure of this type of book is how well it takes someone who has little knowledge and walks them through the process of learning. Often times, this type of book slides into language or discourse that seems aimed at higher-end users or impressing people with the depth of knowledge, jargon and acronymns.
In particular, because Discoverer is a tool aimed at the end-user, who may or may not have a great deal of background with Oracle databases themselves (mine is limited), this book faces the challenge of addressing the needs of both the end-user without high-end technical savvy as well as the administrator who knows Oracle backward and forward.
I'm happy to say that I am rapidly gaining knowledge working through this book, as if I were sitting in a training class.
The progression of this book is as follows:
A. Getting Started with Discoverer
1. An Overview of Discoverer.
2. Users and Databases.
3. Getting Started in Discoverer.
4. The Workbook Wizard: The Essential Steps
5. The Workbook Wizard: The Optional Steps
B. Editing the Query
6. Formatting the Output in Discoverer Desktop and Plus
7. Using Graphs to Present Data
8. Turning a Discoverer Query into a Report
9. Using Discoverer to Analyze Data
10. Business Intelligence Discoverer Viewer 10g Release 2 (10.1.2)
C. Advanced Discoverer Techniques
11. Refining Items, Drilling, and Hyper-Drilling
12. Building Effective Conditions
13. Refining Parameters, Calculations, Sorting, and Percentages
14. Query Management
15. User Preferences, the Toolbar, and the Discoverer Administrator
16. Introducing Discoverer OLAP
D. Using the Discoverer Administration Edition
17. Getting Started in the Administration Edition
18. Editing the Business Area
19. Interacting with the End User
20. Configuring Discoverer
21. Setting Up Portal for Use with Discoverer
22. Summary Management
The appendicies are targeted and helpful.
All in all, I can't say enough good about this book. It filled the need exactly and efficiently.
4 of 4 people found the following review helpful
Well written and thorough book
4 May 2006
Format:Paperback
The Oracle Discoverer 10g handbook is the only book I have seen that covers all aspects of Discoverer so thoroughly in one place. It now covers both the User and Administration Editions, and most importantly, the installation and set up of the product set (an area which is usually forgotten, but which can have a large impact on performance.) This book can be regarded as the bible of Discoverer 10g.
The book is thoughtfully organized, and written in a conversational style that makes it both readable and understable -- not using the acronyms and mysterious marketing words that some people seem to want to use to hide their lack of knowledge.
I am especially impressed with the section on "Configuring Discoverer". This covers some of the less obvious, manual, file changes that may be needed after installation. I am very pleased to see that it also includes registry settings that the Discoverer development team set up. (When the various Discoverer releases were near to production the user interface would be frozen for documentation. If the development team wanted to add some new functionality after this point, they did it by adding registry settings. The intent would be to expose these in the user interface in the next release, but not all of them made it!).
Michael's obvious experience and deep-seated knowledge of Discoverer comes through in Appendix A ("Michael's Gold Mine of Answers to FAQ's").
There are things you can find in this book that can't be found in one place anywhere else. If you are using Discoverer 10g it should be sitting on your desk.
Phillip Slater.
Ex-Director of Product Management, Oracle Discoverer from its instigation until December 2003.
The book is thoughtfully organized, and written in a conversational style that makes it both readable and understable -- not using the acronyms and mysterious marketing words that some people seem to want to use to hide their lack of knowledge.
I am especially impressed with the section on "Configuring Discoverer". This covers some of the less obvious, manual, file changes that may be needed after installation. I am very pleased to see that it also includes registry settings that the Discoverer development team set up. (When the various Discoverer releases were near to production the user interface would be frozen for documentation. If the development team wanted to add some new functionality after this point, they did it by adding registry settings. The intent would be to expose these in the user interface in the next release, but not all of them made it!).
Michael's obvious experience and deep-seated knowledge of Discoverer comes through in Appendix A ("Michael's Gold Mine of Answers to FAQ's").
There are things you can find in this book that can't be found in one place anywhere else. If you are using Discoverer 10g it should be sitting on your desk.
Phillip Slater.
Ex-Director of Product Management, Oracle Discoverer from its instigation until December 2003.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
