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. Usage Tracking

55. Rpd and catalog migration from OBIEE 10g to OBIEE 11g