Oracle Business Intelligence Tutorials And Trainings

Ask Tom Oracle Questions and Answers
Ask Tom Oracle Questions and AnswersAskTom is a rich knowledge base for working with Oracle databases. People ask questions related to Oracle or describe problems they are facing. Tom answers those questions which then can be reviewed by the users which results in building a knowledge base for...
http://asktom.oracle.com
Getting Started with Discoverer
Getting Started with DiscovererThe getting started with Oracle Discoverer tutorial is a great site to start learning Oracle Business Intelligence. The tutorial uses a small database that contains information about a fictitious business which puts it into a real-life context. It is rich in...
http://35.8.180.84/discwb4/doc/tutorial/GetStart.html
Hyperion reporting and analysis Documentation
Hyperion reporting and analysis DocumentationReporting and Analysis section of the online Hyperion Enterprise Performance Management System Documentation. There are many documents in HTML and PDF format on various Hyperion products, such as: Dashboard Development Services, Hyperion Financial Reporting,...
http://download.oracle.com/docs/cd/E10530_01/doc/nav/portal_4.htm
Materialized View Concepts and Architecture
Materialized View Concepts and ArchitectureOracle Materialized View concepts and architecture in Oracle9i Database Online Documentation. The chapter describes the use of materialized views, types, mechanism and ways of refreshing oracle materialized...
http://download.oracle.com/docs/cd/B10501_01/server.920/a96567/repmview.h
Oracle Analytic functions
Oracle Analytic functionsAnalytic functions in Oracle 8i and 9i are designed to resolve such data processing problems as calculation of moving average, running totals, finding percentages within a group. Analytic functions compute an aggregate value based on a group of rows. ...
http://psoug.org/reference/analytic_functions.html

Analytic functions by example
Analytic functions by exampleThe tutorial provides a clear, thorough concept of analytic functions and its various options by a series of simple, concept building examples. The article is addressed to SQL coders (with knowledge of basic Oracle SQL with sub-querying, joins and grouping)...
http://www.orafaq.com/node/55
Oracle Discoverer blog
Oracle Discoverer blogDiscoverer blog with tutorials which help learning Oracle Discoverer. The articles cover installation and setup guide, Discoverer integration with BI Publisher, Discoverer OLAP and Excel AddIn, overview of Oracle Data Warehousing solutions and a best...
http://oraclebi.blogspot.com/search/label/Discoverer
Oracle PL/SQL, MySQL, SQL Server tutorials
Oracle PL/SQL, MySQL, SQL Server tutorialsPL/SQL Tips and programming examples. The examples include tasks like sending email in PLSQL, creating random numbers, Oracle Internet Directory, long deletes, integration with operating system. The examples are clear and easy to understand and implement....
http://www.idevelopment.info/
How to create an Oracle Analytic Workspace
How to create an Oracle Analytic WorkspaceThe tutorial shows how to populate a samle OLAP Analytic Workspace with dimensions and cube objects using Analytic Workspace Manager - Oracle AWM. The tutorial is based on a fictional business scenario (a computing company) with a model compound of 21 oracle...
http://www.oracle.com/technetwork/tutorials/index.html
Oracle SQL Hints
Oracle SQL HintsA good guide on SQL query optimization by using SQL Hints in an Oracle database. The tutorial shows why the hints are useful and when Oracle hints should be used instead of the default Oracle optimizer. The oracle hints are categorized into groups such as...
http://www.adp-gmbh.ch/ora/sql/hints/index.html
Oracle articles and FAQ
Oracle articles and FAQOracle data warehousing articles and FAQ's with broad information and comments. We recommend reading the following articles: Indexing an Oracle Data Warehouse to improve performance Partitioning in Oracle 11g - use of partitioning to improve query performance...
http://www.orafaq.com/articles/warehouse

Tag and category drill-down