Welcome to the Beyond Blog

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
  152 Hits
  0 Comments
152 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
  175 Hits
  0 Comments
175 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
  442 Hits
  0 Comments
442 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
  525 Hits
  0 Comments
525 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
  718 Hits
  0 Comments
718 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
  860 Hits
  0 Comments
860 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
  665 Hits
  0 Comments
665 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
  785 Hits
  0 Comments
785 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
  733 Hits
  0 Comments
Tags:
733 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
  488 Hits
  0 Comments
488 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
  540 Hits
  0 Comments
540 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
  513 Hits
  0 Comments
513 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
  651 Hits
  0 Comments
651 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
  686 Hits
  0 Comments
686 Hits
0 Comments

Advanced Analytics with Oracle BI 12c

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right...
Continue reading
  516 Hits
  0 Comments
Tags:
516 Hits
0 Comments

If you're still using BI Enterprise 11.1.1.7 then watch out for 14th May 2016

Oracle BI Enterprise Edition 11g has been around for many years now and there are many people using 11.1.1.7 versions. This goes out of error correction support on the 14th May 2016, so something you want to be planning for if you're using that in production. You've got a couple of interesting options though: 1) Upgrade to BI EE 11.1.1.9 - yes ther...
Continue reading
  425 Hits
  0 Comments
425 Hits
0 Comments

BI Applications 11.1.1.10.1 now released

Good to see that BI Applications 11.1.1.10.1 is now available. Some quite interesting features with this release including Taleo support and an interesting looking Load Plan Diagnostics and Automatic Correction Facility . We already implement "email alerts" to users should there be any issues in the ETL, but it's great to see some proactive detecti...
Continue reading
  649 Hits
  0 Comments
649 Hits
0 Comments

Oracle BICS (BI Cloud Services) - Visual Analyzer

v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);} Normal 0 false false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-s...
Continue reading
  347 Hits
  0 Comments
347 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