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