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
  343 Hits
  0 Comments
343 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
  641 Hits
  0 Comments
641 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
  999 Hits
  0 Comments
999 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
  950 Hits
  0 Comments
950 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
  1070 Hits
  0 Comments
1070 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
  1239 Hits
  0 Comments
1239 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
  2496 Hits
  0 Comments
2496 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
  1762 Hits
  0 Comments
1762 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
  2005 Hits
  0 Comments
2005 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
  1572 Hits
  0 Comments
1572 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
  1780 Hits
  0 Comments
1780 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
  2552 Hits
  0 Comments
2552 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
  2926 Hits
  0 Comments
2926 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
  2502 Hits
  0 Comments
2502 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
  2677 Hits
  0 Comments
2677 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 lo...
Continue reading
  2474 Hits
  0 Comments
Tags:
2474 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
  1765 Hits
  0 Comments
1765 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 functionality https://www.youtube.com/user/OracleBITechDemos/videos There'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 t...
Continue reading
  1681 Hits
  0 Comments
1681 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
  1642 Hits
  0 Comments
1642 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
  2248 Hits
  0 Comments
2248 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