training4u Posted December 4, 2012 Report Posted December 4, 2012 [color=#282828][font=helvetica, arial, sans-serif][center][color=#0000FF][b]Email: ravitejaobiee@gmail com[/b][/color][/center][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][center][color=#0000FF][b]Contact No:+91-88 61 20 1149[/b][/color][/center][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][center][b]OBIEE 10g/ 11g[/b][/center][/font][/color] [b]Build Repositories: [/b] [b]Course Objectives:[/b] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Use time series functions to support historical time comparison analyses[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Build the Physical, Business Model and Mapping, and Presentation layers of a repository[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Build simple and calculated measures for a fact table[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Create dimension hierarchies and level-based measures[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Model aggregate tables to speed query processing[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Use variables to streamline administrative tasks and modify metadata content dynamically[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Set up security to authenticate users and assign appropriate permissions and privileges[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Apply cache management techniques to maintain and enhance query performance[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Set up a multi-user development environment[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Course Topics: [/b] [b]Repository Basics [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Oracle BI architecture components[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Repository structure, features, and functions[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using the OracleBI Administration Tool[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating a repository[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Loading a repository into Oracle BI Server memory[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Building the Physical Layer of a Repository [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Importing data sources[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Setting up connection pool properties[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Defining keys and joins[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Examining physical layer object properties[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating alias and select tables[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif] [b]Building the Business Model and Mapping Layer of a Repository[/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Building a business model[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Building logical tables, columns, and sources[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Defining logical joins[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Building measures[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Examining business model object properties[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Building the Presentation Layer of a Repository [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Exploring Presentation layer objects[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating Presentation layer objects[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Modifying Presentation layer objects[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Examining Presentation layer object properties[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Adding Multiple Logical Table Sources [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Adding multiple logical table sources to a logical table[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Specifying logical content[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Adding Calculations to a Fact Table [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating new calculation measures based on existing logical columns[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating new calculation measures based on physical columns[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating new calculation measures using the Calculation Wizard[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Creating Dimension Hierarchies and Level-Based Measures [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating dimension hierarchies[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating level-based measures[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating share measures[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating rank measures[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Using Aggregates [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Purpose of aggregate tables in dimensional modelling[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Modelling aggregate tables to improve query performance[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Testing aggregate navigation[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using the Aggregate Persistence Wizard[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Modelling Time Series Data [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using time comparisons in business analysis[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using Oracle BI time series functions to model time series data[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Using Repository Variables [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Session variables[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Repository variables[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Initialization blocks[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using the Variable Manager[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using dynamic repository variables as filters[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]·Presentation Variable[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Security [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating users and groups[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Setting permissions for users and groups[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Authenticating using a external database[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Authenticating using database authentication[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Cache Management [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Restricting tables as non-cacheable[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using Cache Manager[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Inspecting cache reports[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Purging cache entries[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Modifying cache parameters and options[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Seeding the cache[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Multi-user Development [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Setting up a multi-user development environment[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Developing a repository using multiple developers[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Tracking development project history[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Create Reports and Dashboards [/b] [b]Course Objectives:[/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Create and modify Business Intelligence requests using Oracle Business Intelligence Answers[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Combine request criteria using set operations and execute direct database requests[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Work with views to display request information[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Create and modify Interactive Dashboards[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Create guided navigation links within Interactive Dashboards[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards using iBots[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Perform administrative tasks related to the development and configuration of Interactive Dashboards[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Customize the Oracle BI Presentation Services user interface[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Work with Oracle BI Presentation Services content in Microsoft Office applications[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Build Oracle BI Publisher reports based on Answers requests and BI metadata subject areas[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Integrate Oracle BI Publisher reports in Interactive Dashboards[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Employ recommended design principles and best practices[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1][b]. [/b]Set Operators[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Course Topics: [/b] [b]Working with Oracle Business Intelligence Answers [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Introduction to Oracle BI Answers[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Working with requests in Oracle BI Answers[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using advanced formatting[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Filtering Requests in Oracle Business Intelligence Answers [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Introduction to filters in Answers[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Adding filter prompts to requests[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using saved requests as filters[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Oracle Business Intelligence Answers: Advanced Features [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Combining request criteria using set operations[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Executing direct database requests[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Editing logical SQL generated by a request[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Showing Results with Pivot Tables [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Introduction to pivot tables[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Formatting pivot tables[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Setting aggregation rules and building formulas[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Building Views and Charts in Requests [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Introduction to Answers views and charts[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Creating and editing charts[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Performing common view tasks[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Showing Results with Gauge Views [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Introduction to Gauge views[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Working with Gauge views[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Creating Oracle Business Intelligence Interactive Dashboards [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Introduction to Interactive Dashboards and pages[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Dashboard Editor UI elements[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Composing dashboard elements[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Configuring Oracle Business Intelligence Interactive Dashboards [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Types of dashboard content[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Embedding content in Interactive Dashboards[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Using bookmark links to distribute and save Interactive Dashboards[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Configuring Guided Navigation Links [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Building guided navigation with static links[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Building guided navigation with conditional links and sections[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][b]Using Oracle Business Intelligence Publisher [/b] • Introduction to Oracle BI Publisher • Creating a BI Publisher report from the BI Server [b]Using Oracle Business Intelligence Delivers [/b][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Introduction to Oracle BI Delivers[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Configuring delivery devices[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Adding delivery profiles[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Building alerts[/font][/color][/indent] [color=#282828][font=helvetica, arial, sans-serif][indent=1]• Introduction to Oracle BI Scheduler[/font][/color][/indent] Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.