Obiee 10G & 11G Online Training

[rmreddyjinugu]

[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][color=#500050][b][size=5]Email : [email protected][/size][/b][/color]

[color=#500050][b][size=5]Contact No : +91 8861201149[/size][/b][/color]


[color=#500050][b]Course Content:[/b][/color]


[color=#500050][b]2.Concept of Dimensional Modelling[/b][/color][/background][/size][/font][/color]

[list]
[*][color=#500050]Star Schema.[/color]
[*][color=#500050]Snow Flake.[/color]
[*][color=#500050]Fact Table.[/color]
[*][color=#500050]Dimensional Table.[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b]3. OBIEE Architecture [/b]


[color=#222222][font=Arial, Helvetica, sans-serif][b]I. Components of OBIEE[/b][/font][/color][/background][/size][/font][/color][list]
[*][color=#500050]Oracle BI Presenation Server[/color]
[*][color=#500050]Oracle BI Server[/color]
[*][color=#500050]Oracle BI Scheduler[/color]
[*][color=#500050]Admin Tool[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b].Oracle BI User Interface[/b][/background][/size][/font][/color][list]
[*][color=#500050]Answers.[/color]
[*][color=#500050]Dashboards.[/color]
[*][color=#500050]Views.[/color]
[*][color=#500050]Prompts.[/color]
[*][color=#500050]Variables.[/color]
[*][color=#500050]User and Groups.[/color]
[*][color=#500050]Previllages.[/color]
[*][color=#500050]GoNav.[/color]
[*][color=#500050]Filters.[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b]6. Oracle BI Admin Tool

I. Physical Layer[/b][/background][/size][/font][/color]
[list]
[*][color=#500050]Importing Physical Tables .[/color]
[*][color=#500050]Creation of Physical Joins .[/color]
[*][color=#500050]Configuring Connection Pools.[/color]
[*][color=#500050]Exploring Views.[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b]II. Logical Layer[/b][/background][/size][/font][/color]
[list]
[*][color=#500050]Creation of Business Model[/color]
[*][color=#500050]Creation of Logical Facts[/color]
[*][color=#500050]Creation of Dimensions.[/color]
[*][color=#500050]Creation of Dimension Hierarchies/Levels[/color]
[*][color=#500050]Creation of Measures[/color]
[*][color=#500050]Aggregate Navigation[/color]
[*][color=#500050]Creation of timeseries measures[/color]
[*][color=#500050]Creation of level based metrics[/color]
[*][color=#500050]Creation of MLTS (multiple logical table sources)[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b]III. Presentation Layer[/b][/background][/size][/font][/color]
[list]
[*][color=#500050]Creation of Presentation Catalog[/color]
[*][color=#500050]Creation of Presentation tables[/color]
[*][color=#500050]Creation of Presentation Columns[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b]IV. Groups, Users, Repository Variables, Session Variables, Initialization Blocks[/b]

[b]7. Enabling Cache[/b][/background][/size][/font][/color]
[list]
[*][color=#500050]Creating iBots[/color]
[*][color=#500050]Automated Cache Purging using Event Polling[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b]8. Security

I. Authentication[/b][/background][/size][/font][/color]
[list]
[*][color=#500050]LDAP[/color]
[*][color=#500050]Database[/color]
[*][color=#500050]Repository[/color]
[*][color=#500050]External Table[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b]II. Authorization[/b][/background][/size][/font][/color]
[list]
[*][color=#500050]Filters,[/color]
[*][color=#500050]Data Security – GROUP[/color]
[/list]
[color=#500050][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][b]9. BI Analytics Time Series functions[/b][/background][/size][/font][/color]
[list]
[*][color=#500050]Year Ago, Quarter Ago, Month Ago[/color]
[*][color=#500050]To_date[/color]
[/list]
[b]10. OBIEE Repository Tricks

11. OBIEE 11g[/b]

[b]12[/b][color=#282828][font=Arial, Helvetica, sans-serif][size=3][background=rgb(247, 247, 247)][b]. Assignments.[/b][/background][/size][/font][/color]