Generating OBIEE Catalog Report

OBIEE allows to query the webcatalog via a webservice:

http://gerardnico.com/wiki/dat/obiee/web_service

http://tipsonobiee.blogspot.com/2009/07/obiee-web-services-using-net-and-c.html

http://oraclebizint.wordpress.com/2007/07/31/customizing-obi-ee-soap-api/

Generating OBIEE RPD Report

This is pretty useful for a knowledge transfer. Click on tools -> utilities and then select "Repository Report"

Hadoop getting started

Time Dimension Build up in OBIEE

http://www.oraclenerd.com/2010/03/obiee-report-drilldown.html

Datawarehouse Interview Quesitons

• http://www.geekinterview.com/Interview-Questions/Data-Warehouse
• http://www.phlonx.com/resources/nf3/  --> Normalization process
• Top N query in Oracle:  http://www.oracle-base.com/articles/misc/RankDenseRankFirstLastAnalyticFunctions.php

OBIEE 11g and Essbase short documents

Good site with short documents on how to use ODI and Essbase - which are now part for OBIEE suite.
http://learnhyperion.wordpress.com/

Also check out the video tutorials: http://learnhyperion.wordpress.com/category/obiee-video-tutorials/

TOGAF key links

• Session 1
• Session 2
• Session 3
• Session 4
• Session 5
• Scenario Questions - sample
•