marketslop.blogg.se - Free oracle business intelligence training

#Free oracle business intelligence training how to#
#Free oracle business intelligence training software#
#Free oracle business intelligence training free#

#Free oracle business intelligence training software#

We explain how implementing BI software can give companies of any size a competitive edge. Middle East, Nordics and Other Regions (opens in new tab)īusiness intelligence (BI) provides data that helps companies make timely and informed decisions.

United States/Canada (opens in new tab).

Advertising & Digital Marketing Agencies.

Advertising and Digital Marketing Agencies.

#Free oracle business intelligence training free#

If you have any questions or feedback about using Oracle Spatial, feel free to leave a comment below. Santa Monica) within the chosen county in the given report. We can continue further down the hierarchy by choosing the city (e.g.

Set the navigation drill path in the answer to point to the one with lower detail answer page.īy successfully completing the last step, you will have a final result which shows information from the reports on the map as you drill through the report.įor example, by clicking on the report selecting the county “Los Angeles”, OBI will take us to another report showing only data for Los Angeles county and the map will render and focus to the sales and branches only in this selected county.

Pass the value of the geographical region to the map and display features related to this area on the map.

Embed each map represented as HTML page with Javascript using Narrative view in the corresponding Answers you have created earlier.

Use class MVThemeBasedFOI in the javascript to load the themes defined. For example, if we load the map with theme “sales for the cities”, depending on the city that is passed as a parameter, all the shops in that city will be drawn on the map. Therefore when one of the maps is viewed, appropriate set of FOIs will be rendered on the map.

Use MapBuilder to define theme based FOI layer for each map, in our case for: city, county and region, and ensure that each theme is loaded in the corresponding map.

For each Answer created in step 1, assign one map that will accept the parameter from the Answer. This step requires certain understanding of JavaScript in order to use JavaScript APIs provided for MapViewer.

Create a map that will accept the parameter from the dashboard and display the appropriate shops and regions on the map.

In the example shown, we have selected geographical hierarchy State->County->City and the measure that we want to show are the sales for all shops in the chosen region.

First of all, create 2 or more Answers in OBI that contain different levels of hierarchy that you will use for navigated drill down.

#Free oracle business intelligence training how to#

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.