Course Content

Admin:
1. Installation of the Database
2. Installation of RCU
3. Installation of the OBI.
4. OBI configuration.
Reporting:
1. Introduction to reporting UI
2. Creation of sample Analysis
3. How to change the formula of the columns.
4. Custom level changes of the columns in the report.
5. Binning in the formula.
6. Totals and Subtotals in the views.
7. Adding the filters as the sql queries.
8. Filtering the measure in the formula internally.
9. Creation of union reports
• union
• union all
• intersect
• minus operators.
10. Creation of different views and about the editing properties.
• Table
• Title
• Compound Layout View
• Pivot tables
• Graphs of the Pivot Table
• Different types of the graphs
1. Bar Graph
2. Line Graph
3. Area Graph
4. Pie Graph
5. Line Bar Graph
6. Bubble Graph
7. Radar Graph
• Gauge views
• Columns selector
• View selector
• Map Views
• Static Texts
• Ticker
• Narrative Views
• Legends
• Filter Views
11. Enabling the section sliders in the report.
12. Performing the master details functionality.
13. Creation of report level prompts
14. Creating the Saved Filters.
15. Creating the sample dashboard
16. Creating dashboards with multiple pages
17. Conditional display of the section in the dashboard page
18. Section level permission in the page
19. Dashboard prompts
20. How to get the query for the reports executed.
21. How to fire the query directly to the database.
22. How to use the isse sql option.
23. Presentation variables
24. Saved Filters
25. Creating KPIs
26. Creating Scorecards
27. Creating Watch lists
Actionable Intelligence:
1. About the Actions in the report.
2. About the Action links in the Dashboard.
3. About the Action link Menu in the Dashboard
4. Types of Actions
• to BI Content
• to a Web Page
5. Creating the Conditions.
6. Creating the Agents
7. How to configure the Agents in the EM.
Repository:
1. Creating the Repository
2. 3 Layer Architecture of the Reposirtory.
3. How to connect to Different Data Sources
• Relational Data Source
• Excel Data Source
• Access Data Source
4. Physical, BMM and Presentation Layer and Its components.
5. Importing Metadata.
6. To create aliases
7. To create the joins in the physical layer
8. To create the joins in the logical layer
9. To rename the objects in the Logical Objects manually and renaming wizard
10. Creating measures
11. To build the Presentation Layer (Subject Area)
12. To create the presentation table
13. To create the Presentation Columns
14. Renaming the Presentation Columns
15. Ordering the columns in the Presentation and Business Layer
16. To check the global consistency of the RPD
17. Setting the Log level in the RPD to get the Query and Log Information.
18. How to get the server log
19. How to get the Repository Documentation.
20. How to purge the cache and make the tables cacheable.
21. About the LTS in the BMM layer (Logical Table Source)
22. Creating the Logical Dimensions with
23. Setting the logical keys in the hierarchy
24. Setting the aggregation content for the LTS
25. Creating the level based measures
26. Using the aggregates
27. Using the initialization blocks and Variables
28. Creating the variables (Session, Repository, Presentation) and their usage.
29. Creating Time series functions
• AGO Function
• TODATE Functions
• Period Rolling Functions
30. Repository Functions
• Mathematical Functions
• String Functions
• Calendar/ Time Functions
• Conversion Functions
• Aggregation and Running Aggregate Functions
• System Functions
31. Lookup tables and Lookup function.
Types of Lookup Functions
1. Sparse Lookup
2. Dense Lookup
32. How to use calculation Wizard
Security
1. An overview of Oracle Business Intelligence Security 696
2. Data Level Security 714
Users, Groups and Roles
Creating the New User, Role and Groups and Managing them.
3. Object Level Security
Maintenance
1. Deploying the RPD to make the Online RPD.
2. Deploying the Catalog
3. Restarting the Complete BI Server
4. Checking the OPMNCTL services.
4. Location of the Config Files
5. Lcation of the Log Files.
6. Bulding and using the Usage Tracking in the BI Server.