Welcome to the Beyond Blog

A first look at Faceted Search in Oracle Apex 19.2 EA

a1_20190923-154723_1
We use Oracle APEX for product development as it's a great low-code cloud-based environment.  We keep an eye on early adopter releases as they provide early preview into upcoming features.  The new APEX 19.2 Early Adopter contains a bunch of new features, one that particularly appealed to us was the new Faceted Search.  Faceted Searc...
Continue reading
  1260 Hits
  0 Comments
1260 Hits
0 Comments

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
  1237 Hits
  0 Comments
1237 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
  1577 Hits
  0 Comments
1577 Hits
0 Comments

It's all in the hands. Thoughts on conference presenting.

I'm always delighted to be asked to give a presentation on the use of Oracle technology; whether that be for a customer or at a major conference.  Typically once i've written the material, got myself to the venue with all my gear and whatever requirements that customer/conference has, it's showtime.  However, passionate as ...
Continue reading
  1559 Hits
  0 Comments
1559 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 i...
Continue reading
  1750 Hits
  0 Comments
1750 Hits
0 Comments

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

BI Publisher Consuming Data Visualization DataThe 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 w...
Continue reading
  1907 Hits
  0 Comments
1907 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
  3280 Hits
  0 Comments
3280 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
  2527 Hits
  0 Comments
2527 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
  2784 Hits
  0 Comments
2784 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
  2070 Hits
  0 Comments
2070 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
  2403 Hits
  0 Comments
2403 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 datasetsFilter the columnsCreate some binsAdd a new calculated columnSave the results as a singe data source that we can then analyze.Our flow will eventually look like this .....We will start wi...
Continue reading
  3265 Hits
  0 Comments
3265 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 be...
Continue reading
  3763 Hits
  0 Comments
3763 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
  3215 Hits
  0 Comments
3215 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
  3489 Hits
  0 Comments
3489 Hits
0 Comments

BI with D3 Visualisations in APEX

Oracle's APEX ships with some great plugins such as D3 Collapsible Treemaps. The most immediate way to see these is to install the Sample Charts application and have a play with it.Now it is then fairly striaghtforward to utilise this plug-in in your own APEX applications. Here I simply exported the plugin from the Sample Chart applications and loa...
Continue reading
  3268 Hits
  0 Comments
Tags:
3268 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
  2328 Hits
  0 Comments
2328 Hits
0 Comments

Oracle DV Desktop V2 Plugins

DV Desktop v2 has been on general release now for a week or so and I highly recommend the following Oracle video to see some of the new functionalityhttps://www.youtube.com/user/OracleBITechDemos/videosThere's a lot to like about this release - the hugely enhanced connectivity and workflow for example, but some things I haven't seen many people tal...
Continue reading
  2111 Hits
  0 Comments
2111 Hits
0 Comments

Oracle Exadata Express 12.2 - Connecting SQL Developer

Oracle Exalytics Express is the first production release of the Oracle 12c release 2 database ( aka Oracle 12.2 ). It comes with some amazing features such as analytic views which we have alr4eady blogged and will be expanding on shortly.As soon as your instance has been spun up you'll want to connect SQL Developer to it, so here's a few hints and ...
Continue reading
  2104 Hits
  0 Comments
2104 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 Orac...
Continue reading
  2854 Hits
  0 Comments
2854 Hits
0 Comments

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Suite 1.01 Jactin House,

24 Hood Street, Manchester

M4 6WX United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk