دوره حضوری Create Repository and Analysis & Dashboard On OBIEE

دوره حضوری Create Repository and Analysis & Dashboard On OBIEE

هدف دوره Create Repository and Analysis & Dashboard On OBIEE

بعد از پایان این دوره دانشجویان موارد ذیل را خواهند آموخت
• با ابزار BI Admin Tool جهت ایجاد مخزن داده (Repository) آشنا خواهند شد
• با محیط OBIEE (Oracle Business Intelligence Enterprise Edition) جهت ایجاد تحلیل ها و گزارشات آشنا خواهند شد


مدت دوره:

40 ساعت

پيش نياز:

Oracle PL/SQL


سرفصل دوره:

 Repository Basics
o Objectives
o Oracle BI Server Architecture
o Oracle BI Presentation Services
o Oracle BI Server
o Data Sources
o Oracle BI Repository
o Oracle BI Administration Tool
o Physical Layer
o Objects in the Physical Layer
o Business Model and Mapping Layer
o Objects in the Business Model and Mapping Layer
o Business Model Mappings
o Measures
o Presentation Layer
o Presentation Layer Mappings
o Presentation Layer Defines the User Interface
o Repository Directory
o Repository Modes
o Publishing a Repository
o Using FMW Control to Manage OBI Components
o Reloading Server Metadata
o Sample Analysis Processing
o Summary
o Practice 1 Overview: Exploring an Oracle BI Repository
 Building the Physical Layer of a Repository
o Objectives
o Physical Layer
o Physical Layer Objects
o Database Object
o Database Object: General Properties
o Database Object: Features
o Connection Pool
o Schema Folder
o Physical Table
o Physical Table Properties
o Physical Column
o Key Column
o Physical Table: Alias
o Joins
o ABC Scenario
o Implementation Steps
o Create a New Repository File
o Provide Repository Information
o Select the Data Source
o Select Metadata Types for Import
o Select Metadata Objects for Import
o Verify and Edit Connection Pool Properties
o Verify Objects for Import
o Verify Import in the Physical Layer
o Verify Connectivity Create Alias Tables
o Define Keys and Joins
o Define Keys by Using the Table Properties Dialog Box
o Open the Physical Diagram
o Define Foreign Key Joins
o Use the Joins Manager
o Design Tips for the Physical Layer
o Summary
o Practice 1 Overview: ABC Business Scenario
o Practice 2 Overview: Gathering Information to Build an Initial Business Model
o Practice 3 Overview: Creating a Repository and Importing a Data Source
o Practice 4 Overview: Creating Alias Tables
o Practice 5 Overview: Defining Keys and Joins
 Building the Business Model and Mapping Layer of a Repository
o Objectives
o Business Model and Mapping (BMM) Layer
o Objects in the Business Model and Mapping Layer
o Business Model Mappings
o Objects in the Business Model and Mapping Layer
o Business Model Object
o Logical Tables
o Logical Table Sources
o Logical Table Source: Column Mappings
o Logical Columns
o Logical Primary Keys
o Logical Joins
o Measures
o ABC Example
o Implementation Steps
o Create the Logical Business Model
o Create the Logical Tables and Columns
o Define the Logical Joins
o Modify the Logical Tables and Columns
o Define the Measures
o Design Tips
o Summary
o Practice 1 Overview: Creating the Business Model
o Practice 2 Overview: Creating Simple Measures
 Building the Presentation Layer of a Repository
o Objectives
o Presentation Layer
o Subject Areas
o Presentation Tables
o Presentation Columns
o Presentation Layer Mappings
o Defining the User Interface in the Presentation Layer
o Nesting Presentation Tables
o Aliases
o ABC Example
o Implementation Steps
o Create a New Subject Area
o Rename Tables
o Reorder Tables
o Delete Columns
o Rename Columns
o Reorder Columns
o Considerations
o Design Tips
o Summary
o Practice 1 Overview: Creating the Presentation Layer
 Testing and Validating a Repository
o Objectives
o Validating a Repository
o ABC Example
o Consistency Check
o Checking Consistency
o Consistency Check Manager
o Using the validated Utility to Check Repository Consistency
o Marking a Business Model Available for Queries
o Confirming a Consistent Repository
o Publishing a Repository
o Using FMW Control to Start OBI Components
o Query Logging
o Setting a Logging Level
o Logging Levels
o Validating by Using the Analysis Editor
o Inspecting the Query Log
o Viewing Log Messages
o Oracle BI SELECT Statement: Syntax
o Oracle BI SELECT Statement Compared with Standard SQL
o Summary
o Practice 1 Overview: Testing a Repository
 Working with Logical Dimensions
o Objectives
o Logical Dimensions
o Logical Dimensions: Types
o Level-Based Measures
o Share Measures
o Logical Dimension: Example
o ABC Example
o Creating a Level-Based Logical Dimension
o Create a Logical Dimension Object
o Add a Parent-Level Object
o Add Child Level Objects
o Specify Level Columns
o Create Level Keys
o Set the Preferred Drill Path
o Create Level-Based Measures
o Create Additional Level-Based Measures
o Create Share Measures
o Add Measures to the Presentation Layer
o Create Presentation Hierarchies
o Test Measures and Hierarchies
o Parent-Child Logical Dimensions
o Parent-Child Hierarchy: Example
o Parent-Child Logical Table
o Parent-Child Relationship Table
o Creating a Parent-Child Logical Dimension
o Create a Logical Dimension Object
o Set the Member Key
o Set the Parent Column
o Open the Parent-Child Relationship Table Settings Dialog Box
o Enter Parent-Child Relationship Table Script Information
o Enter Parent-Child Relationship Table Details
o Preview Scripts
o Confirm Parent-Child Relationship Table Settings
o Confirm Changes to the BMM Layer
o Confirm Changes to the Physical Layer
o Modify the Physical Layer
o Modify the BMM Layer
o Create the Presentation Hierarchy
o Verify Your Work
o Calculated Members
o Summary
o Practice 1 Overview: Creating Logical Dimension Hierarchies
o Practice 2 Overview: Creating Level-Based Measures
o Practice 3 Overview: Creating Share Measures
o Practice 4 Overview: Creating Dimension-Specific Aggregation Rules
o Practice 5 Overview: Creating Presentation Hierarchies
o Practice 6 Overview: Creating Parent-Child Hierarchies
o Practice 7 Overview: Using Calculated Members
 Working with Oracle Business Intelligence Analyses
o Objectives
o Oracle Business Intelligence Analysis Editor
o Key Terms
o Subject Areas
o Columns
o Hierarchies
o Oracle Business Intelligence Analysis
o Creating and Editing Analyses
o Analysis Editor
o Subject Areas and Catalog Panes
o Analysis Editor Tabs
o Working with Analyses in Oracle Business Intelligence
o Construct an Analysis
o Construct an Analysis (Multiple Subject Areas)
o Modify Analysis Criteria
o Modify Analysis Criteria (Sorting Columns)
o Modify Analysis Criteria (Formulas)
o Modify Analysis Criteria (Style)
o Modify Analysis Criteria (Column Format)
o Modify Analysis Criteria (Data Format)
o Modify Analysis Criteria (Conditional Format)
o Modify Analysis Criteria (Interaction)
o Change Column Order
o Display Analysis Results
o Save an Analysis
o Advanced Formatting
o Saving Column Settings as Systemwide Defaults
o Copying and Pasting Formatting Attributes
o Using a Saved Analysis as a Style Template
o Customized Date and Time Format Strings
o Applying a Customized Format String to a Column
o Write Back
o Essbase Data Sources
o Summary
 Filtering Data for Analyses
o Objectives
o Using Filters to Limit Data in Analyses
o Creating and Editing Filters
o Grouping Filters
o Dynamic Filtering
o Using a Saved Analysis as a Filter
o Editing SQL for a Column Filter
o Drilling and Filters
o Applying Named Filters
o Analysis Prompts
o Adding an Inline Prompt to an Analysis
o Defining Prompt Properties
o Multiple Column Filter Prompts
o Summary
 Selecting and Grouping Data for Analyses
o Objectives
o Using Selections to Limit Data in Analyses
o Creating Selection Steps
o Create a New Step
o Select the Step Type
o Step Types: Selecting Members
o Step Types: Adding Groups and Calculated Items
o Step Types: Applying Conditions
o Step Types: Selecting Members Based on Hierarchy
o Step Types: Selecting Members Based on Family Relationship
o Saving Selection Steps as a Group
o How Do Filters and Selection Steps Differ?
o Groups
o Creating Groups
o Create a New Member Group
o Define the Group Properties
o Apply Formatting
o Verify the Results
o Calculated Items
o Creating Calculated Items
o Create a New Calculated Item
o Define the Calculated Item Properties
o Verify the Results
o Summary
 Working with Views in Analyses
o Objectives
o Performing Common Tasks in Views
o Previewing How Views Appear in Dashboards
o Specifying Totals
o Managing Aggregation
o Combining Values into Bins
o Creating Bins: Add Bins
o Creating Bins: Name and Configure Bins
o Specifying Table View Properties
o Linking Master-Detail Views
o Defining the Master View
o Defining the Detail View
o Creating and Modifying Additional View Types
o Narrative View
o Ticker View
o View Selector View
o Column Selector View
o Selection Steps View
o Trellis View
o Renaming a View or Compound Layout
o Summary
 Showing Results with Pivot Tables
o Objectives
o Pivot Table Views
o Analyzing and Displaying Data in Table and Pivot Table Views
o Pivot Table
o Creating a Pivot Table
o Select Columns on the Criteria Tab
o Click the Results Tab and Select Pivot Table View
o Rearrange Elements as Necessary
o Showing Results in Pivot Tables
o Sorting
o Member Sorting
o Row Sorting with Innermost Column
o Measure Sorting
o Measure Sorting on the Column Edge
o Using Hierarchical Columns
o Hierarchical Columns
o Overriding Default Aggregation Rules
o Using Totals
o Adding Formatting: Overall Appearance
o Adding Formatting: Pivot Table Positions
o Adding Formatting: Section Options
o Adding Formatting: Showing a Section Once
o Showing an Item’s Relative Value
o Showing the Relative Value of an Item
o Duplicate the Measure
o Rename the Duplicate Measure
o Select the Show Data As Option
o View the Results
o Using Calculations in Pivot Tables
o Building Calculations by Using Functions
o Building Calculations by Using Formulas
o Displaying Running Sums in Pivot Tables
o Summary
 Measuring Results with Key Performance Indicators
o Objectives
o Key Performance Indicators
o KPIs and Oracle Business Intelligence
o Using KPIs
o KPI Concepts and Terminology
o KPI Characteristics
o Evaluating KPIs
o Creating KPIs
o Create a New KPI
o Define the General Properties
o Set the Data Format and Enable Trending
o Define the Dimensionality
o Define the Statuses and Thresholds
o Define the Related Documents
o Define the Custom Attributes
o Target Settings in KPI
o Prerequisites for Target Settings
o Setting Up Target Settings in KPIs
o KPI Watch lists
o Creating a Stand-Alone KPI Watch list
o Using the KPI Watch list Performance Tab
o Using the KPI Watch list Details Tab
o Changing Dimensionality for a KPI Watch list Event
o Summary
 Administering the Presentation Catalog
o Objectives
o Security Goal: Access and Actions
o Oracle BI Security and Catalog Security
o Default BI Roles
o Presentation Catalog Folder and Object Permissions
o Permission Inheritance
o Default Application Role Hierarchy: Example
o Setting Object Permissions
o Click Permissions
o Add Roles
o Set Permissions
o Recommendations for Setting Permissions
o Viewing and Setting Properties
o Setting System Privileges
o Click Administration and Manage Privileges Links
o Pick Users and Roles
o Catalog Groups
o Archiving Catalog Items
o Working with Favorites
o Adding Objects to Favorites
o Accessing Favorite Objects
o Organizing Favorites
o Removing Favorites
o Full-Text Catalog Search
o Using the Fully Integrated Full-Text Search
o Using the Partially Integrated Full-Text Search
o What Results Are Returned from a Full-Text Catalog Search?
o Summary
 Creating Oracle Business Intelligence Dashboards
o Objectives
o Dashboards
o Dashboard Pages
o Creating and Editing a Dashboard
o Creating a New Dashboard from Global Header
o Global Header: Setting Preferences for Your Default Dashboard View
o Using Dashboard Builder
o Using the Dashboard Builder Toolbar
o What Can I Add to a Dashboard?
o Adding Objects to a Dashboard Page
o Dashboard Builder Tools Toolbar Layout
o Tools Toolbar: Dashboard Properties
o Dashboard Properties: Dashboard Report Links
o Dashboard Properties: Dashboard Page Controls
o Tools Toolbar: PDF and Print Properties
o Tools Toolbar: Page Report Links
o Tools Toolbar: Prompts Buttons on Current Page
o Tools Toolbar: Allow Saving Personal Customizations
o Tools Toolbar: Publishing Dashboard Pages
o Exploring Dashboard Object Properties
o Exploring Column Properties
o Exploring Section Properties
o Exploring Section Properties: Arranging Sections Horizontally
o Exploring Section Properties: Controlling the Drilldown Display
o Section Properties: Conditions
o Section Properties: Adding an Inline Condition for an Analysis
o Section Properties: Adding an Inline Condition for a KPI
o Section Properties: Adding a Named Condition
o Section Properties: Formatting and Renaming
o Miscellaneous Dashboard Page Functionality
o Page Options Toolbar: Creating Personal Customizations
o Page Options Toolbar: Creating Shared Customizations
o Page Options Toolbar: Creating Links to Dashboard Pages
o Page Options Toolbar: Adding Content to a Briefing Book
o Summary
 Creating Dashboard Prompts and Variables
o Objectives
o Variables
o Session Variables
o Repository Variables
o Presentation Variables
o Request Variables
o Referencing Variables
o Syntax for Referencing Variables
o Dashboard Prompts
o Dashboard Prompts: Column Prompts
o Dashboard Prompts: Other Prompts
o Adding a Named Column Prompt to a Dashboard
o Create a New Named Column Prompt
o Select the Prompt Type
o Select the Subject Area and Column
o Select the Operator and Other Options
o Save the Prompt
o Preview the Prompt
o Add the Prompt to the Dashboard
o Set the Scope for the Dashboard
o Test the Results
o Adding a Hidden Named Prompt to a Dashboard
o Edit Dashboard Properties
o Navigate the Catalog to Locate the Named Prompt
o Test the Results
o Creating a Second Prompt Page
o Add a New Prompt to an Existing Prompt Page
o Insert a Page Break
o Edit the Dashboard and Add the Prompt
o Test the Results
o Setting Preferences for a Prompt Page
o Presentation Variables and Prompts
o Request Variables and Prompts
o Adding a Variable Prompt to a Dashboard
o Add a Variable to an Existing Analysis
o Create a New Variable Prompt
o Select the Prompt Type
o Define the Prompt Properties
o Save the Prompt
o Select the Dashboard
o Add the Prompt to the Dashboard
o Navigate the Catalog to Locate the Named Prompt
o Test the Results
o Applying Prompts with Default Values
o Wiring Dashboard Prompts
o Auto-Complete for Prompts
o Enabling Auto-Complete for Prompts
o Optional Apply and Reset Buttons for Prompts
o Summary


جزئیات سرفصل دوره Create Repository and Analysis & Dashboard On OBIEE را از طریق لینک زیر دریافت کنید:


سرفصل دوره سماتک