raj111 Posted August 19, 2012 Report Posted August 19, 2012 [b]Email : [/b][email="[email protected]"][b][email protected][/b][/email] [b]Contact No : +91 8861201149[/b] [b]Course Content:[/b] [b]2.Concept of Dimensional Modelling[/b] [indent=1]§ Star Schema.[/indent] [indent=1]§ Snow Flake.[/indent] [indent=1]§ Fact Table.[/indent] [indent=1]§ Dimensional Table.[/indent] [b]3. OBIEE Architecture [/b] [b]I. Components of OBIEE[/b] [indent=1]§ Oracle BI Presenation Server[/indent] [indent=1]§ Oracle BI Server[/indent] [indent=1]§ Oracle BI Scheduler[/indent] [indent=1]§ Admin Tool[/indent] [b].Oracle BI User Interface[/b] [indent=1]§ Answers.[/indent] [indent=1]§ Dashboards.[/indent] [indent=1]§ Views.[/indent] [indent=1]§ Prompts.[/indent] [indent=1]§ Variables.[/indent] [indent=1]§ User and Groups.[/indent] [indent=1]§ Previllages.[/indent] [indent=1]§ GoNav.[/indent] [indent=1]§ Filters.[/indent] [b]6. Oracle BI Admin Tool[/b] [b]I. Physical Layer[/b] [indent=1]§ Importing Physical Tables .[/indent] [indent=1]§ Creation of Physical Joins .[/indent] [indent=1]§ Configuring Connection Pools.[/indent] [indent=1]§ Exploring Views.[/indent] [b]II. Logical Layer[/b] [indent=1]§ Creation of Business Model[/indent] [indent=1]§ Creation of Logical Facts[/indent] [indent=1]§ Creation of Dimensions.[/indent] [indent=1]§ Creation of Dimension Hierarchies/Levels[/indent] [indent=1]§ Creation of Measures[/indent] [indent=1]§ Aggregate Navigation[/indent] [indent=1]§ Creation of timeseries measures[/indent] [indent=1]§ Creation of level based metrics[/indent] [indent=1]§ Creation of MLTS (multiple logical table sources)[/indent] [b]III. Presentation Layer[/b] [indent=1]§ Creation of Presentation Catalog[/indent] [indent=1]§ Creation of Presentation tables[/indent] [indent=1]§ Creation of Presentation Columns[/indent] [b]IV. Groups, Users, Repository Variables, Session Variables, Initialization Blocks[/b] [b]7. Enabling Cache[/b] [indent=1]§ Creating iBots[/indent] [indent=1]§ Automated Cache Purging using Event Polling[/indent] [b]8. Security[/b] [b]I. Authentication[/b] [indent=1]§ LDAP[/indent] [indent=1]§ Database[/indent] [indent=1]§ Repository[/indent] [indent=1]§ External Table[/indent] [b]II. Authorization[/b] [indent=1]§ Filters,[/indent] [indent=1]§ Data Security – GROUP[/indent] [b]9. BI Analytics Time Series functions[/b] [indent=1]§ Year Ago, Quarter Ago, Month Ago[/indent] [indent=1]§ To_date[/indent] [b]10. OBIEE Repository Tricks[/b] [b]11. OBIEE 11g[/b] [b]12[/b][b]. Assignments.[/b] 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.