The Oracle BI Presentation Service Server:
The process is:
The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services.
When a user session begins, Oracle BI Presentation Service:
Logical SQL Generation: Oracle BI Presentation Service allows users to visually define queries within the Answers and Dashboard interfaces. It presents a graphical representation of the query as the user selects and manipulates columns and adds filters (constraints) to the query. The Answers interface also allows users to enter logical SQL directly – the results can still be formatted and displayed within Answers. Once the user submits the query, Oracle BI Presentation Service sends logical SQL to the Oracle BI Server.
User Interface Personalization: When Answers and Dashboard users personalize the structure of their user interface including defining views, layout specification, properties of individual charts, tables, and pivot tables, Oracle BI Presentation Service stores these personalization definitions in a metadata catalog called the Web Catalog as an XML Schema that includes metadata about the user interface and security information such as users, groups, and roles.
Performance and Scalability: Oracle BI Presentation Service allows web servers to be clustered for scalability. If web server processing capacity becomes a bottleneck to system performance, an administrator can configure multiple Oracle BI Presentation Service and HTTP servers. A variety of load balancing facilities are supported to distribute user sessions and maintain session affinity with the HTTP server it selected for that session.
In Oracle BI Presentation Services, customization of user interface elements and appearance is accomplished by modifying: