As you'd expect from the winners of the Specialized Partner of the Year: Business Analytics at the Oracle UKI Specialized Partner Awards 2014, Beyond work with leading edge BI Applications primarily within the UK Public Sector. We intend to share some of our ideas and discoveries via our blog and hopefully enrich the wider discussion surrounding Oracle Business Intelligence and driving improved insight for customers
A while back I created a post describing how to produce an organization chart in Oracle APEX using Google visualizations. If you didn't catch that then go and take a look here first before reading on as it will provide the background reading to this post.
So in this post I am going to demo how we can do this in OBIEE - and it's actually quite easy because OBIEE has already done a lot of the work for us.
First we need a level based hierarchy (or even just a representation of a hierarchy as levels across columns). This is how all BI Applications hierarchies are implemented, for example the organization and position hierarchies. I am going to use SampleApp with the "Sample Sales"."Offices" hierarchy.
Then we simply select all the columns in our hierarchy into a simple analytic. As we have multiple top level nodes I have applied a filter to restrict to just one company, however this isn't necessary - if you have multiple top level nodes then you simply get multiple trees.
If we use the default Table view then we see something like this. Note I have changed the column order in this view simply to make the hierarchy structure clearer.
Oracle Synopsis was first announced at Openworld 2016; a mobile platform to allow data analysis on the go on a mobile device. Think of it a bit like Oracle Data Visualizer Desktop for your phone or tablet. Up until now though it's only been available for Android devices, however over the weekend the iOS version was released on the Apple Store. So your first question might be Ok, so how much is it to licence?. Well - the answer to that would be £0; it's FREE! Yes Free! You don't need any back end OBIEE software or anything to run it either - it runs completely on your device. With that in mind I thought I should take a look.
The idea behind Synopsis is that you can take a spreadsheet from any existing App (email etc) and easily import that. So I took a spreadsheet of spend data from my local authority (.csv format), emailed it to myself and used the new option Import with Synopsis to load up the dataset.
Synopsis then proceeds to import the data file. My file was about 7MB which is a reasonable size for a .csv, however it only took a minute or two to import.
A while back I wrote a post about how to combine measures from different facts in an OBIEE analysis. If you missed that then you can find it here. One of the key issues I highlighted was that generally it is only possible to join up facts where the dimensions you are using are common across both facts. I.e.
There is however a technique that can be used to achieve this. Let's assume we want to report on the number of sickness absence days by department in a BI Apps model. A simplified view of these two facts and the mandatory dimensions would be
We've been working with a number of customers who want to see context specific charts/graphs displayed when the mouse rolls over values in a table, rather than having to drill. In order to show an example of this rather slick approach we have created a 30 second video as a demonstration
I wanted to write this as an introduction to combining data from multiple facts/subject areas into a single analytic. The post is aimed primarily at end-users as there are developer techniques we can use to circumvent some of the restrictions described below. Let us first refresh ourselves with a subject area actually is. In its most basic form it is simply a fact with associated dimensions. Consider the following simplified example for a financial fact.
So we can easily report on financial transactions by any of the four dimensions listed. Now let's suppose we have a completely separate subject area based on some HR Salary information.
Again, we can use that star in isolation however we wish. However... what if our user decides that they would like to report on the monthly spend alongside the monthly salary cost? Without considering any dimensions this works fine - we can simply include the measure from each fact. The difficulty comes when we want to include dimensions - the key rule being this... You can only report on measures from multiple facts where all dimensions that are used in the analytic are shared. So let's look at those two facts together.