Skip to main content


Showing posts from February, 2016

OBI 12c Series: Connecting OBI with Hyperion Planning

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

GeoSpatial Analytics in Oracle Business Intelligence (4)

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, themes