Žiga Vaupot's Blog

Recently I was working with Oracle Business Intelligence 12c on a project where Hyperion Planning was used as a data source. In previous OBI releases, the usual way to connect to Hyperion Planning was to connect to its Essbase cube. In general this worked fine, but as some of readers might know, Essbase cube usually doesn't contain certain information that is a property of Hyperion Planning application. For example, comments are very important for users of Hyperion Planning, but when you report on Hyperion Planning's Essbase cube, how would you display comments that users enter into planning form? This was theoretically possible, but required a major workaround. To be honest, I haven't done that. But with OBI 12c this is very straight forward. Comments are seen as attributes in OBI's subject area, so it can be included in reports as any other attribute. This particular customer had specific requirement to show commentaries along side with numbers. Since we were t...

I explained steps necessary to setup spatial data to be available for analyses in OBIEE in my previous steps: Setup the scene ,  Prepare database spatial tables   and Setup connections required by maps and create type layer (basemap) in Map Viewer . In this post I'm stepping one more step further, so let's investigate what tasks one has to perform in Map Builder. Oracle Map Builder is a standalone application that lets you create and manage the mapping metadata (about styles, themes, and base maps) that is stored in the database. For example, use this tool to create a style or to modify the definition of a style. Besides handling the metadata, the tool provides interfaces to preview the metadata (for example, to see how a line style will appear on a map) and also spatial information. Whenever possible, you should use Oracle Map Builder instead of directly modifying Oracle MapViewer metadata views to create, modify, and delete information about styles, theme...

In my two previous posts I have set the scene for spatial analysis in OBI and prepared database tables . I'm going to continue this example by preparing Tyle Layers in Map Viewer. Oracle Fusion Middleware MapViewer enables developers to incorporate highly interactive maps and spatial analysis into business applications. A component of Oracle Fusion Middleware, it lets you combine application content with maps and data from a variety of web services and data formats. It is also fully integrated with Oracle Spatial and Graph. In addition, it is included in Oracle products such as Oracle Business Intelligence and Oracle applications such as Utilities, Transportation, and Communications. Key MapViewer features are: Rich user experience and faster performance through HTML5-based JavaScript APIs Combine content stored in an databases, JSON and XML files with content from online web services Mobile support for popular iOS and late-version Android devices Web-based map data ed...

I ran into a rather general question today: "how to delete cache on my remote linux BI server?". Quite straight forward, I thought. But, and there is always a but somewhere, I didn't have BI Admin tool installed on my laptop (as you need Windows installed for that ...). And since this is not what I do most of the time I just had to do, what I do as a last resort, RTFM (read the f... manual) to get the answer that is in most cases taken as granted. To shorten my learning curve for the next time, here are some notes, what you have to do in order to purge cache on BI Server. First, let me show what can be done "manually". 1. Login into your server and open a terminal window. 2. Go to the following folder: [FMW_HOME]/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup For example, in my case: /app/oracle/biee/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup 3. Create a new text file called purgecache.tx...

In the first post of this series I set the scene for  our spatial visualisation. I will now describe how to prepare spatial tables for usage in geo-spatial analysis in this post. If you recall, I mentioned that there is a hierarchy of regions that has to be implemented and visualised using maps. That hierarchy has Sales regions, Chiho regions and Prefectures (Chiho and Prefecture are administrative regions in Japan). The idea is to show a map on the sales region level and than drill down to Chiho and finally to Prefectures level. I have also explained that the starting point for this is database table MAP_PREFECTURES which I found and downloaded from internet so the precision on the map might not be the best. As you saw, table MAP_PREFECTURE has already an attribute called GEOMETRY, which is of SDO_GEOMETRY type. This means that spatial information is already present. So to be able to start using in my spatial analyses I just have to perform two tasks: register MAP_PREFEC...