O SpecGold OracleBusIntApps7 clr



   Call us now 

  Manchester Office

  +44 (0) 8450 940 998




Welcome to the 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

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
    Login Login form
Subscribe to this list via RSS Blog posts tagged in Database 12.2

If you haven't already started using Oracle Cloud services, then what better way than to sign up for $300 free credits for a pay-as-you-go subscription (valid for one month)? Simply visit and click Sign Up. I did it earlier - it's really easy and was set up within an hour. To try it out, I provisioned myself a Standard Edition Database service - again, pretty easy. You can choose either a predefined set of options, or customise it to suit your needs (in terms of CPU's, memory, database version etc). You'll see the service in your console with a status of "Creating service...".

Creating Service

After about half an hour the service provisioning is complete. You may notice that provisioning a Database service actually gives you a couple of supporting others too - you can of course provision these standalone if required.


Starting/Stopping a particular service is as easy as this:

Starting and Stopping Services

Next was to get access via SSH. To do that you will need to generate a key pair on your client machine using ssh-keygen. Then simply copy your public key up to the client.

Last modified on Continue reading
Tagged in: Cloud Database 12.2
in Technical 611 0

After being announced at Oracle Openworld 2016 for cloud-only, 12.2 is now finally available as an on-premise release and available from Oracle E-Delivery 

12.2 E-Delivery

We've been using it in the Cloud for a while here at Beyond on our Exadata instance and you may have already seen my previous blog posts on some of the new features such as Analytic Views. More to come soon.

Last modified on Continue reading
in Technical 1634 0

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&D whilst we were formulating some recommendations for a BICS customer.

Whilst doing this we encountered a couple of issues with connectivity but fortunately we were helped out by this paper that has just been released by Oracle in February 2017 called "Known Issues for Oracle Business Intelligence Cloud Service".

In addition this paper covers a few other things you will likely want to know about, so if you have embarked on a BICS installation then I highly recommend giving this a quick read.


Last modified on Continue reading
in Installation and Patches 1317 0

In my previous blog post An Introduction to Analytic Views in Oracle 12.2 I briefly mentioned that one of the killer features of Analytic Views is their ability to hold a huge amount of metadata within the database objects themselves, which can then be accessed and utilized from the application tier. Last time we built up a very simple Employee Sales view, which I will reuse again for the purposes of this demo. If you haven't already read the previous blog then I'd suggest doing that before continuing here.

So taking our very simple data model - what does it actually represent? Well, I have already told you that, it represents sales by employees, however what if I wanted the database to provide you with that information? So you don't need to maintain a separate set of documentation or have a local expert who can recall the details from memory. Well, using the Classification clause we can do just that. We can modify the view definition we created previously to the following:

Create or Replace Analytic View emp_sales_av
  Classification Caption Value 'Employee Sales'
  Classification Description Value 'Employee Sales Amount over Time'
Using emp_sales
Dimension By (
    Key date_wid References row_wid Hierarchies (calendar_hier Default),
    Key emp_wid References row_wid Hierarchies (employee_hier Default)
Measures (
  amount Fact amount
  Classification Caption Value 'Sales Amount'

Note I have also given a more descriptive classification to the measure we defined. If we now create a very simple application (I am going to use Oracle Application Express due to its power, ease of use and the fact that it comes ready shipped with an Oracle Cloud Exadata Express instance), we can make use of that metadata within the application very easy by using the dictionary views for AV's. First, we will get the information about our model and display it.

Last modified on Continue reading
in Technical 1813 0

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 tips to assist.  Note that Exadata Express provides you with a pluggable database (PDB) so if this is your first time with a 12c database then I recommend reading up all about how container and pluggable databases work.

Firstly you'll need to enable SQL*Net access and then click on the "Download Client Credential" in your console. 


This will download a zip file to which you allocate a password and you'll need to store that somewhere in your filesystem that SQL Developer can see it.

Now you'll need at least version 4.1.5 of SQL Developer for this to work, so upgrade if you're on an earlier one.  I'm a keen user of the 4.2 early adopter.


Create a new connection and use the new "Cloud PDB" connector.  The configuration file as the one that you downloaded when you were in the console.  Press "Test" and hopefully you should see the "success" message that I have.


That should be you up and running. 

.If you're following John's blog published on the 8th of October on Analytic Views then you may find the following useful.  SQL Developer now comes with a bunch of pre-built reports that give you some great insights of the analytics and their metadata that have been created.


Last modified on Continue reading
in Technical 1652 0