Obiee free tutorial

Tekslate OBIEE Free Tutorial

OBIEE Architecture Oracle Business Intelligence System Logical Architecture

New Features in OBIEE Administration tool The most significant difference between Oracle Business Intelligence 10g and 11g, is the deployment to Oracle WebLogic Server and the integration of Oracle Business Intelligence with Oracle Fusion Middleware.

The administration is done using: Oracle WebLogic Server Administration Console (Java Component) and Fusion Middleware Control (non-Java components) You no longer need to manually change configuration files for most administration tasks.

Security In Oracle Business Intelligence release 10g users and groups could be defined within a repository file using Oracle BI Administration Tool. In Oracle Business Intelligence release 11g users and groups can no longer be defined within a repository. Oracle Business Intelligence authenticates users and get groups using an Oracle WebLogic Server authentication provider against user information held in an identity store. In 11g any named user can be granted administrative permissions if desired. This compares to 10g where there was a single user with administrative permissions who was named Administrator.

Using Aggregates In this set of steps you set up and use aggregate tables to improve query performance. Aggregate tables store pre-computed results, which are measures that have been aggregated (typically summed) over a set of dimensional attributes. Using aggregate tables is a popular technique for speeding up query response times in decision support systems. This eliminates the need for runtime calculations and delivers faster results to users. The calculations are done ahead of time and the results are stored in the tables. Aggregate tables typically have many fewer rows than the nonaggregate tables and, therefore, processing is faster.

Developing Repository in OBIEE New Diagramming Capability: The Physical and Business Model Diagrams have enhanced capabilities in the 11.1.1.5 release, including an improved look-and-feel, the ability to display columns in table objects in the diagram, and new diagram options like auto-layout, marquee zoom, and zoom to fit. Additionally, joins in the Physical and Business Model Diagrams are now represented by a line with an arrow at the “one” end of the join, rather than the line with crow’s feet at the “many” end of the join that was used in previous releases. When creating joins in the Physical and Business Model Diagrams, you now select the “many” end of the join first, and then select the “one” end of the join. In previous releases, joins in the diagrams were created by selecting the “one” end of the join first.

Creating Level Based Measures in OBIEE In this set of steps you create level-based measures that calculate total dollars at various levels in the Product hierarchy, and then use a levelbased measure to create a share measure.

To create level-based measures and a share measure, you perform the following steps: • Open the Repository in Offline Mode • Create Level-Based Measures • Create a Share Measure • Test Your Work

Testing and Validating You have finished building an initial business model and now need to test and validate the repository before continuing. You begin by checking the repository for errors using the consistency checking option. Next you load the repository into Oracle BI Server memory.

You then test the repository by running an Oracle BI analysis and verifying the results.

Finally, you examine the query log file to observe the SQL generated by Oracle BI Server.

To test and validate a repository you perform the following steps: • Check Consistency • Disable Caching • Load the Repository • Set Up Query Logging • Create and Run and Analysis • Check the Query Log

And Also Issues Interview Questions How to’s For More OBIEE Free Tutorials Please Visit: http://bit.ly/1sF93Tf