Oracle BI and DWThis is a featured page

Welcome to the Oracle BI and DW Wiki. Here we will try to bring out anything and everything related to Oracle Business Intelligence and Data Warehouse. The purpose is to provide information and a help to all users working on solutions for data access (i.e.: OLAP, Essbase) as well as data integration (i.e.: OWB, ODI).

If you need any general BI technical information please use the BI OTN Home page:
http://www.oracle.com/technology/products/bi/index.html

Link to the BI and DW product management web site:
http://bidw.oraclecorp.com/

The Roadmap to Business Intelligence:
click here

(Only for Oracle internal employee) Visit the Oracle Business Intelligence and Data Warehousing blog:
http://blog.us.oracle.com/obidw/


emocat
emocat
Latest page update: made by emocat , Sep 3 2008, 2:54 PM EDT (about this update About This Update emocat Moved from: The Official Oracle Wiki - emocat

No content added or deleted.

- complete history)
Keyword tags: None
More Info: links to this page
Started By Thread Subject Replies Last Post
hehayeung BQY cannot access after Hyperion Migration from BRIO to Hyperion 0 Oct 14 2009, 4:50 AM EDT by hehayeung
Thread started: Oct 14 2009, 4:50 AM EDT  Watch
I would like to seek advise with following issue.
We are using Hyperion BI+ 9.2.0 and there has a problem to access the old bqy in BRIO.
After perform the Hyperion Migration Tools, all the bqy, oce and user/group migrated successfully from BRIO to Hyperion 9.2.0.
But there has some saved local BQY which cannot access to the Hyperion. It prompt the mesasge from Interactive Reporting Studio as below
"Unmatched DataTypeException exception encountered"
With refer to Hyperion Server Log, error message recorded in the log of
server_messages_PublisherServer.log - uuidparamter is null
server_messages_DataAccessServlet.log - Error in retrieving document from disk
Anyone would provide solution or experience on above.
Do you find this valuable?    
Keyword tags: None
nmrezzini Using OBIEE with the OLAP Option to Oracle Database 11g 0 Mar 2 2009, 11:22 AM EST by nmrezzini
Thread started: Mar 2 2009, 11:22 AM EST  Watch
For whom would like to see some details about using Oracle Business Intelligence Enterprise Edition with the OLAP Option to Oracle Database 11g, then please login on Oracle Technology Network (http://www.oracle.com/technology/index.html) site and download the White Paper (http://www.oracle.com/technology/products/bi/olap/Oracle_OLAP_11g_BIEE_TWP.pdf) on that.
Do you find this valuable?    
Keyword tags: None
nmrezzini Cube Organized Materialized Views 0 Mar 2 2009, 9:26 AM EST by nmrezzini
Thread started: Mar 2 2009, 9:26 AM EST  Watch
Using cube organized with materialized view, we have got a query performance and fast for incremental updates.

Summary sql queries that are directed at relational fact tables are automayically rewritten on the olap cube
to deliver faster query performance.

Cube MVs is existing since 11g, they are integrated with the Oracle Database SQL Optimizer.
The 11g SQL Query Optimizer treats OLAP cubes as MVs and rewrites queries to access cubes transparently.
A single cube provides the equivalent of tens, hundrends, or thousands of summary combinations.
The cube MV is refreshed using standard MV procedures.

There are four general tasks required to implement cube MVs. The first three tasks are specific to OLAP cube MVs,
while the last task is important for any type of MV.

Tasks for implementing cube MVs include:
• Design dimensions and cubes – AWM
• Enable cube MVs – AWM
• Build and maintain dimensions and cubes – AWM
• Prepare relational schema for query rewrite – SQL
Do you find this valuable?    
Keyword tags: None
Showing 3 of 15 threads for this page - view all