Welcome to the Beyond Blog

Beyond Blog

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


Extracting Data from Oracle Fusion SaaS using Data Replicator in Oracle Analytic Cloud Service

 If you were keeping up to date with the goings on at Oracle OpenWorld last week, then you may have caught Larry Ellison announcing the ' Fusion Analytics Data Warehouse '. Whilst the specific features that were showcased are unlikely to be available in the very near future, we have been exploring some of the functionality made available in th...
Continue reading
  332 Hits
  0 Comments
332 Hits
0 Comments

BI Publisher in OAC 5 sourcing data from DV Data Set

15---create-report
In the September 2018 release of Oracle Analytics Cloud ( aka OAC5 or 18.3.3 ) BI Publisher receives a substantial number of enhancements including read receipts, digital signatures, etc.  One interesting enhancement is the ability of BI Publisher (BIP) to be able to create 'pixel perfect' reporting using from a Data Visual...
Continue reading
  566 Hits
  0 Comments
566 Hits
0 Comments

Data Enrichment and Obfuscation in OAC 18.3.3

Enrichment OAC Enrichment
The new (September 2018) version of Oracle Analytics Cloud (OAC) now includes data enrichment functionality.  To show a snippet of this in action, we have a small excel file with made up credit card details, a name and an address.  We can use both obfuscation and enrichment to enhance and secure this data and then perform some visualisati...
Continue reading
  417 Hits
  0 Comments
417 Hits
0 Comments

New Visualizations in OAC 18.3.3 and DV Desktop v5 ( 12.2.5 )

picto
The latest release of Oracle Analytics Cloud 18.3.3 and Data Visualization Desktop release 12.2.5 bring a wealth of enhancements, from data enrichment to new visualization types.  The OAC release has some particularly interesting features, such as the replication capability, which is something we shall look at in a future blog post.  In t...
Continue reading
  480 Hits
  0 Comments
480 Hits
0 Comments

Monitoring ODI Load Plan Executions (II)

Just over three years ago I wrote a blog post on Monitoring Oracle Data Integrator (ODI ) Load Plan Executions with BI Apps where I demonstrated a little APEX application I had developed to bypass some of the pain and clunkiness of doing the same in the ODI console. I had a few people ask me if they could have a copy of the app, however at the time...
Continue reading
  452 Hits
  0 Comments
452 Hits
0 Comments

Oracle Data Visualization with Oracle Cloud ERP data sourced from OTBI

I was at a conference recently when I asked the audience who's connected DV to OTBI.  Not many had, so as it is relatively straightforward then I thought I show you how to do that.  Firstly we need to create a connection, so click on create a new connection and select Oracle Applications Next, fill in the appropriate connection details.&n...
Continue reading
  619 Hits
  0 Comments
619 Hits
0 Comments

Creating new calculated items with Oracle Data Visualization

I’m often asked ‘How do I/Can I create my own calculations in DV?’, so I thought that I’d put up a short blog on how to achieve this. I’m going to quickly create some sample data that show some simple sales figures for 99 offices. I’m then going to create 10 buckets ( or ‘bins’ ) and get DV to show wh...
Continue reading
  689 Hits
  0 Comments
689 Hits
0 Comments

Timing Repository Variable Refreshes in BI Applications

This issue arose at a customer today, and I've seen it happen in the past, so I thought it worthwhile making a quick note. A situation had arisen which had caused the overnight ETL execution to be delayed. Once this had completed the users complained that the dashboard was missing some data. This was tracked down to a shared filter which contained ...
Continue reading
  1392 Hits
  0 Comments
1392 Hits
0 Comments

Oracle Data Visualization V4 - Data Flows

Data Flows in v4 of Oracle Data Visualization (in the new OAC as well as Desktop) is much improved, so let's look at creating a flow to : Join together two datasets Filter the columns Create some bins Add a new calculated column Save the results as a singe data source that we can then analyze. Our flow will eventually look like this ..... We will s...
Continue reading
  963 Hits
  0 Comments
963 Hits
0 Comments

Oracle Data Visualization v4 - Sentiment Analysis

Oracle Data Visualizer has been out for a couple of years now and is already on version 4. I'm a big fan and have been digging deep into the latest release which has brought in a substantial amount of changes. They are all available here , but I think that the most exciting inclusions are around the Explain capability and new algorithms that have b...
Continue reading
  1165 Hits
  0 Comments
1165 Hits
0 Comments

Data Visualization Version 3

Data Visualization 12.2.3 ( aka v3 ) is now downloadable from here What a great upgrade it is, absolutely packed with new enhancements to increase the functionality and make data discovery even quicker. The trendlines (as shown above) now allow for additional functionality such as a %age confidence. There's new data sources too - we can even connec...
Continue reading
  946 Hits
  0 Comments
946 Hits
0 Comments

Organization or Position Hierarchies in Oracle OBIEE

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 ...
Continue reading
  2558 Hits
  0 Comments
2558 Hits
0 Comments

Oracle Day by Day App

Oracle have released the new Day by Day app for both iOS and Android and it's rather good. There's a great 6min video here https://www.youtube.com/watch?v=8q4foZyYQJc which I highly recommend watching, but I thought I'd share my first experiment with it. I connected to my demo Oracle Analytic Cloud instance to use the good old Sample App test data....
Continue reading
  1100 Hits
  0 Comments
1100 Hits
0 Comments

Known Issues for Oracle Business Intelligence Cloud Service - February 2017

Whilst BICS comes with complete Schema as a Service, some customers choose to use database as a service (DBaaS) for many reasons (such as the ability to use the on-premise modelling tool and "lift and shift" the model). DBaaS has recently been upgraded to offer 12.2 as an option for the database which is what we were trialling as part of internal R...
Continue reading
  660 Hits
  0 Comments
660 Hits
0 Comments

Oracle Synopsis for iOS Released

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 ...
Continue reading
  1391 Hits
  0 Comments
1391 Hits
0 Comments

Combining Facts/Subject Areas in Oracle OBIEE - Part 2

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...
Continue reading
  2397 Hits
  0 Comments
2397 Hits
0 Comments

Data Visualization Desktop

Oracle have recently released Data Visualization Desktop (http://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html) which “gives decision-makers their own personal desktop application to access, explore, blend, and share data visualizations” . If you already know Ora...
Continue reading
  889 Hits
  0 Comments
889 Hits
0 Comments

Creating Popup charts in Oracle BI 12c

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 Please have look here https://www.youtube.com/watch?v=bZHzcMmL...
Continue reading
  949 Hits
  0 Comments
949 Hits
0 Comments

Combining Facts/Subject Areas in Oracle OBIEE

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 ...
Continue reading
  4774 Hits
  0 Comments
4774 Hits
0 Comments

*)nqgtu(* - Working Around an Odd Bug in OBIEE

Note: This post relates to an issue which has been produced in Version  11.1.1.7.150120  for the purposes of this blog. It  may not be present in previous versions and may be fixed in future releases. You write an analytic and it runs fine. You stick it on a dashboard with prompts and it runs fine. So you now decide to extend that da...
Continue reading
  4440 Hits
  0 Comments
4440 Hits
0 Comments

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

76 King Street, Manchester

M2 4NH United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk