OBIEE 11g Training Course Content
1. History of OBIEE
2. What is a Dimension table and Fact table.
3. Understanding Primary key and Foreign keys.
4. Basic RPD creation using Scott( oracle DB)
5. Basic RPD creation using Microsoft Excel
6. Creating Views using Administation tool
7. Deploying and undeploying Views
8. Testing and validating Repository
9. Differences between Online, Offline and Read only mode RPD
10. How to bring RPD to online mode for Reporting
11. Introduction to servers
12. Architecture of OBIEE
13. Setting Log Levels
14. Building physical layer, BMM layer and Presentation layer
15. Creating Logical Tables, Columns and Joins
16. Working with Column properties, filters, sorting, edit formula and deleting columns
17. What is Web Catalog & Instanceconfig.xml
18. Creating Presentation catalog and shared folders
19. Building analytics requests
20. Sorting Presentation tables and columns
21. Adding Calculations to fact
22. Calculation measures on basis of physical and logical columns
23. Using Rename, Calculation Wizard
24. Working with Enterprise Manager
25. Creating dimensional hierarchy
26. Creating Level based measures
27. Modeling Time Series Data & Time based Measures (Ago, Todate & Periodrollup)
28. Working with Multiple LTS
29. Static , Dynamic Repository Variables
30. Creating Initializations blocks
31. Working with Weblogic Administration Console
32. Using Admin Console to create Users and Groups
33. Assigning of permissions to users and user group
34. Restricting the Objects (Tables, Columns, Subject Area) to Users
35. System and Non System Session Variables
36. Security at data levels
37. Enabling and disabling the Cache using Enterprise Manager
38. Making the table cacheable
39. Purging cache using different techniques
40. Creating Saved Filters
41. Creating different types of Views ( table, title, pivot table,
42. pie chart, column selector, view selector, legend, etc)
43. Creating Shared Dashborad.
44. Creating Dashboard Prompts
45. Setting Scope for a Prompt
46. Creating and working with Agents
47. Using Direct Database Requests
48. Creating report using multiple subject area’s
49. Parent-child hierarchies
50. Fragmentation
51. Using Catalog Manager
52. MUDE( Multi User Development Environment)
53. Creating KPI’s ,Scorecards and Action links
54. Rpd and catalog migration from OBIEE 10g to OBIEE 11g