ORACLE BUSINESS INTELLIGENCE 11G DEVELOPERS GUIDE PDF
Developer's Guide for Oracle Business Intelligence Enterprise. Edition. 11g Enterprise Edition 11g Release 1 () documentation set: □. The Oracle .. Follow the steps in the wizard to locate, download, and install the Oracle BI EE. Master Oracle Business Intelligence 11g Reports and DashboardsDeliver meaningful business information to users anytime, anywhere, on any device, with . Business Intelligence Enterprise Edition 11g and the basics of the repository. This chapter . contributing to a book, see our author guide on yazik.infoub. com/authors. .. BI developers should share these variables with the business users.
|Language:||English, Spanish, Hindi|
|Genre:||Health & Fitness|
|ePub File Size:||23.43 MB|
|PDF File Size:||17.33 MB|
|Distribution:||Free* [*Register to download]|
This books (Oracle Business Intelligence 11g Developers Guide [PDF]) Made by Mark Rittman About Books Title: Oracle Business Intelligence. Editorial Reviews. About the Author. Mark Rittman, Oracle ACE Director, is Technical Director book; Length: pages; Enhanced Typesetting: Enabled; Page Flip: Enabled; Due to its large file size, this book may take longer to download. Oracle Business Intelligence 11g Developers Guide: Computer Science Get your Kindle here, or download a FREE Kindle Reading App.
No other rights are granted to the U. This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation.
This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services.
Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services. Documentation Accessibility Related Documentation and Other Resources System Requirements and Certification Oracle Business Intelligence Enterprise Edition Oracle BI EE is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, and an enterprise reporting engine.
The components of Oracle BI EE share a common service-oriented architecture, data access services, analytic and calculation infrastructure, metadata management services, semantic business model, security model and user preferences, and administration tools.
Oracle BI EE provides scalability and performance with data-source specific optimized request generation, optimized data access, advanced calculation, intelligent caching services, and clustering.
Audience This document is intended for application developers, data service providers, and middle tier administrators who want to programatically access and use the Oracle BI EE components to create applications or integrations with other components.
Documentation Accessibility For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at Access to Oracle Support Oracle customers have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired. Go to the Product Information Center support note Article ID on My Oracle Support at System Requirements and Certification Refer to the system requirements and certification documentation for information about hardware and software requirements, platforms, databases, and other information.
The system requirements document covers information such as hardware and software requirements, minimum disk space and memory requirements, and required system libraries, packages, or patches: ents html The certification document covers supported installation types, platforms, operating systems, databases, JDKs, and third-party products: ation html Conventions The following text conventions are used in this document: Convention boldface italic monospace Meaning Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.
When you add an object to an ADF page, that page contains a reference to the object and does not contain a copy of the object. You can also set any filter or prompt parameters for the object.
Developer's Guide for Oracle Business Intelligence Enterprise Edition 12c ()
You can also set up security and change the Presentation Services connection after the application is deployed. You can include the following types of business intelligence objects in ADF applications: Analyses Note that you can expand and browse the folders to view an analysis' subcomponents. The following view types appear in the catalog: table, pivot table, chart, funnel chart, gauge, narrative, ticker and title.
Dashboards Note that you can browse inside the dashboard folder to find the pages that are associated with the dashboard. Dashboard Pages Note that you cannot browse within the dashboard pages to see components.
[PDF Download] Oracle Business Intelligence 11g Developers Guide by Mark Rittman (Sep 18 )
Such as, any analyses embedded in the dashboard. Scorecard components Note that you cannot include an entire Scorecard; only its components. These components are: strategy maps, strategy trees, KPI watchlists, cause and effect maps, and custom views. Supply chain managers want to view the analysis summarizing the status of orders in different sectors and availability of items in the warehouse along with other transactional data.
A marketing manager for an online shopping site wants to see downloaders' trend information, such as age group, geographic distribution, and personal interests, in a dashboard to analyze the user data and use it to determine future marketing strategies. A sales manager wants to see the sales analysis for different regions with conditional formatting and take an action if the sales is trending below a minimum threshold.
Before you can perform the following tasks, you must have created an ADF project to which you add business intelligence content. When you have completed the procedures in this topic, you can create an Oracle BI Enterprise Edition Presentation Services connection to access the catalog from which to select business intelligence objects to embed in your application.
In JDeveloper, click the Help menu and click About. The "About Oracle JDeveloper 11g" dialog displays where you can confirm the release number. Click the Extensions tab to view a list of the installed extensions. To sort the list, click either the Name or Identifier column heading. If no extensions begin with the "bi-" prefix, then you do not have the required extensions Installing the Required JDeveloper Extensions Use this procedure to install the required extensions.
Personalizations can be stored at the user level or the group level. Users can personalize the following items when they exist on a dashboard region on an ADF page: Values for dashboard prompts Values for presentation variables These variables are usually set by a prompt. MDS stores application metadata and also stores and retrieves customizations at various levels within the ADF application.
Select Libraries and Classpath. Technology scopes are ADF project attributes that are used to identify the different technologies used for the project. In JDeveloper, go to the Projects Pane and right-mouse click on the project to which you want to add the technology scopes and select Project Properties. Select Technology Scope. Click OK. Before you can perform the following tasks, you must have first created an ADF project and prepared it to accept business intelligence content.
To export and import the client certificate: 1. Identify the location of the server key store. Import the client certificate into JDeveloper. Run the following command to import the certificate.
Oracle Business Intelligence 11g Developers Guide
Open JDeveloper and locate the -Djavax. For example, -Djavax. Note that this parameter contains the client truststore location and stores the key and certificate that the client uses to verify the server's certificate. Depending upon where you created and saved the connection, the connection name displays either within the Resource Palette's IDE Connections panel or the Application Navigator's Application Resources panel.
When you expand the connection's name, JDeveloper shows the Oracle BI Presentation Catalog's folders and the objects stored in the folders. From the folders, you can drag and drop business intelligence objects from the resource palette to the ADF page. You must build this connection only one time per catalog; however, after the connection is built, its parameters can be edited at design time within JDeveloper.
To create a connection 1. In JDeveloper, choose where you want the connection to be used. Use the following substeps to create the connection to be available for any JDeveloper application. Navigate to the Resource Palette, click the New button. From the list, select BI Presentation Services. Note: JDeveloper allows you to drag and drop a saved connection from the Resource Palette to the Application Resources pane.
Use the following substeps to create the connection to be available for the current application, only: a.
Navigate to the Application Navigator tab and then to the Application Resources pane. Right click on the Connections folder and select New Connections. Select BI Presentation Services. Enter a unique, descriptive name that identifies the catalog connection.
Note that after you finish creating the connection, the name cannot be changed. Click Next.
Frequently bought together
Enter the Oracle Business Intelligence Presentation Services location and make selections for the following items. Modify this field only if the System Administrator has changed the default context from "analytics-ws" to something else. For example, mycompanyname-ws. The SOAP connection uses the context specified in this field.
Static Resources Mode Specify from where to retrieve static resources. Selecting Auto results in a significant increase in performance.
Select Manual to direct requests to another location. All of the application logic and the processing of the data is performed on the compute server, to which all the data must be sent.
With this approach, a computing platform can be used for a wide range of software applications, though it will not be optimized for any particular application. The goal of Exadata was to create a complete stack of software and hardware focused on the Oracle Database, that allowed processing to be moved to its optimal location. If Exadata is only processing Oracle Database requests it can take advantage of that in all the software layers. The hardware design can include elements that are most advantageous to Oracle Database applications, such as very fast InfiniBand networking and Flash memory.
Given the importance of data storage to databases, Oracle was particularly focused on optimizing that aspect of the Exadata platform. Oracle wanted a storage layer for Exadata that could easily scale out and parallelize Oracle Database requests.
It also recognized the opportunity for storage to cooperate in the processing of database requests beyond just storing and shipping data. For example, rather than send an entire database table across the network to the compute server to find a small number of records, such data filtering could be done in storage and only the resulting records sent across the network.
The addition of Flash memory to Exadata Storage Servers also opened up a range of possibilities for optimizing performance in the storage layer. Over time, as the performance and capacity of Flash storage increased at a rapid rate, the network became a performance bottleneck for traditional database platforms and Exadata's offloading of database processing into Exadata Storage Servers avoided that problem.
The foundation of Exadata is the Exadata Storage Server   , invented by Oracle to replace the traditional storage array. Also important is Oracle's ownership of all the main software and hardware components of Exadata, enabling changes to be deeply integrated and released in coordinated fashion.
A further benefit for customers is the ability to support the entire Exadata platform from one vendor. Exadata Software[ edit ] Software enhancements specific to Exadata achieved better performance in some areas due to the integration of hardware and software. For example, when an OLTP application commits a transaction to the database software, that request is viewed by Exadata as a critical operation and prioritized accordingly within the network and in the storage servers.
The commit request will move in front of less important messages on the network and in the IO queue . Another example is the use of Flash memory for caching data that is being accessed by Analytics applications.
Because a columnar data format is more effective for Analytics workloads, when Exadata moves the data row from disk to Flash, it automatically reformats the data into a columnar format . Both examples require the Oracle Database to understand the intent of the application and to cascade this understanding to the network and storage software, which behave accordingly.
Since Exadata's debut in , there have been at least two significant Exadata software releases per year, delivering dozens of "smart" software enhancements. Most of these enhancements are based on a smaller number of technical foundations, as explained below.
Technical Concepts[ edit ] Offloading to Storage - refers to the execution of data-intensive database operations within the Exadata Storage Servers, such as data scans, table joins and filtering of rows and columns. This reduces the amount of data that must ultimately be returned over the network to the compute servers, thus avoiding the network bottleneck.
Offloading is possible because Exadata storage is built on standard servers, capable of running database functions in coordination with the Oracle Database, simultaneous with storage IO.
Over time, more database functions and more data types have been offloaded. In addition, "reverse offloading" will push an operation back to the compute servers if Exadata storage is too busy. Storage Indexes - enable the avoidance of IO by tracking column values within small regions of storage. If the Storage Index confirms that an IO to a region will not find a match, that IO isn't performed, and a costly and unnecessary operation is avoided.
Storage indexes are automatically maintained and kept in memory on Exadata Storage Servers. Initially Storage Indexes tracked value ranges within a small number of columns. Over time, more columns and more sophisticated value tracking have been added, so that additional IO operations can be avoided.Views Total views. Government or anyone licensing it on behalf of the U. Before you can perform the following tasks, you must have first created an ADF project and prepared it to accept business intelligence content.
Conventional data compression algorithms yield between 2x and 4x compression, whereas HCC averages between 10x and 15x compression. Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
Storage Indexes - enable the avoidance of IO by tracking column values within small regions of storage. In the Permission Class list, select oracle.