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.
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”.
If you want to set up your own Oracle Business Intelligence environment you are going to need a database. The following YouTube videos are some instructions I put together for a course I taught at my local university.
For how to install the Linux Operating system on Virtual Box see my Create VM on Virtual Box post
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 virtualbox.org.