ramit Posted August 13, 2012 Report Share Posted August 13, 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 Link to comment Share on other sites More sharing options...
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.