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