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


New Language Narrative in Oracle Analytics Cloud

Sometimes a graphical visualization is just what is needed to help to bring clarity to a data set.  On other occasions, there's nothing like a narrative to help explain and a mix of the two can be even better.  In the 105.3 version of Oracle Analytics Cloud, the new Language Narrative visualization was introduced to apply narrative t...
Continue reading
  295 Hits
  0 Comments
295 Hits
0 Comments

Oracle Analytics Cloud 105.2 New Feature - Transform in Dataflows

Transform
Oracle Analytics Cloud 105.2 ( and also the just released DV Desktop variant 12.2.5.2.0 ) have a huge selection of incremental updates and i've already covered a couple in previous blogs where I've looked at some front end visualisations.  The back-end Data Flow has also had some nice enhancements and we'll look at one of those; the Trans...
Continue reading
  659 Hits
  0 Comments
659 Hits
0 Comments

Oracle Analytics Cloud - 105.2 new feature focus - Relative Time Filters

i2_20190410-133912_1 Relative Time Filters
​Relative Time Filtering is a new option in OAC to filter  Date or Date/Time columns to just retain data for a specific time period relative to the current date/time.  It should be noted that current date/time is the timezone of the OAC pod and not the client machine on which your browser ...
Continue reading
  756 Hits
  0 Comments
756 Hits
0 Comments

Oracle Analytics Cloud - 105.2 new feature focus - BIP sourcing from DV Data Flows

BI Publisher Consuming Data Visualization Data The new March 2019 release of Oracle Analytics Cloud (Version 105.2) has a wide range of new features, from administrative through to general enhancements. In this series of blogs I will look at some of the features and use a worked example to show it in action.  The first enhancement that I ...
Continue reading
  867 Hits
  0 Comments
867 Hits
0 Comments

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
  2062 Hits
  0 Comments
2062 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
  2115 Hits
  0 Comments
2115 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
  1446 Hits
  0 Comments
1446 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
  1681 Hits
  0 Comments
1681 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
  1274 Hits
  0 Comments
1274 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
  1346 Hits
  0 Comments
1346 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
  1513 Hits
  0 Comments
1513 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
  2410 Hits
  0 Comments
2410 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
  2162 Hits
  0 Comments
2162 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
  2511 Hits
  0 Comments
2511 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
  2116 Hits
  0 Comments
2116 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
  3459 Hits
  0 Comments
3459 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
  2282 Hits
  0 Comments
2282 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
  1477 Hits
  0 Comments
1477 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
  2278 Hits
  0 Comments
2278 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
  3890 Hits
  0 Comments
3890 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