![]() First of all, create 2 or more Answers in OBI that contain different levels of hierarchy that you will use for navigated drill down.Next you need to know how to create a simple drill down report with navigation path and integrate it with an embedded map in Oracle Business Intelligence dashboard.Īssuming that you already have Oracle Spatial available in your Oracle database and MapViewer properly installed and configured, you need to perform the following steps to integrate and visualize your geographical information with OBI reports: MapViewer also includes MapBuilder tool that is used to define the way different map layers and features on the map will appear. MapViewer basically contains a rendering engine that “reads” data from Oracle Spatial schema and draws them on the screen as defined in the database. Oracle Spatial provides an SQL schema MDSYS and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in an Oracle database. So what do you need in order to view geographical data in OBIEE?Īpart from Oracle database and Oracle Business Intelligence installation, there are 2 additional components required for rendering maps in your BI tool: Let’s start with a simple overview of the architecture and continue with a demo drill down report that automatically focuses the map and draws the selected items from the report. Oracle provides a powerful engine that can analyze and display the data from your data warehouse on the map or even integrate it with Google maps. Viewing individual branches and their performance, presented on the geographical map, can give companies further insights into their business. With today’s globalization of business, many organizations have their branch offices located in various countries or even across different continents. Oracle BI EE not only helps you to visualize information using charts and graphs, but it also gives you the opportunity to add geographical dimension to your reports.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |