How to Deploy Metadata Dictionary in OBIEE


One of the frustrating things for users who build reports in Oracle Business Intelligence (OBI) is not knowing the data that could be available to them or where it comes from.

One way to help with this frustration is to deploy the metadata dictionary in OBI which allows you to drill down on any presentation layer field or table to the objects in the RPD that are related to that object even if they aren’t visible in the front end.

In the YouTube video below I show how to deploy and use the metadata dictionary in OBI 11g.

Sources of free map data


When implementing maps in Oracle Business Intelligence a lot of people may have the mistaken impression that they must purchase map data or use external map providers to create background maps or create themes for use with their business data.  In truth there are numerous free sources of shape files that can be used under open source licenses for your business.  These files are easily imported into your Oracle database using Oracle Map Builder.

Following is a list of free map data I have compiled and will continue to add to over time.

One fantastic source of United States shape files is the United States Census Bureau Tiger/Line Shapefiles.  They make available files from the state level down to the zip code as well as many features such as Landmarks and Roads.

Canada also has a Census Program and provides many files that can accessed via the Statistics Canada Geography page.

Another immense source of freely available and usable shape files is Natural Earth which is a “collaboration involving many volunteer NACIS members and cartographers around the globe”.

Create VM on Virtual Box


If you are going to effectively try new out and experiment with Oracle technologies one of the most powerful tools available to you is virtualization technology.  Virtualization software such as VMware and Virtual Box allow you to create virtual machines that can be snapshot-ed at various points in time and shared with other people.

If you aren’t familiar with virtualization check out this Wikipedia post.

If you haven’t learned how to use virtualization software check out these YouTube videos I prepared for a course I taught at my local university showing how to create a Linux Virtual Machine using Virtual Box software freely available at