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


John Keymer

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
0
  1166 Hits
  0 Comments
Tweet
1166 Hits
0 Comments
John Keymer

Redacting Sensitive Data in Oracle 12c using Dbms_Redact

Since Oracle 10g it has been possible to hide data from specific users or under a set of specified conditions. This can be entire rows using Virtual Private Database (VPD) policies or specific columns in a table. In this post I'm going to look at the latter and how that has been enhanced in Oracle 12c. First, let's take a pre-12c example. Suppose I...
Continue reading
0
  1124 Hits
  0 Comments
Tweet
1124 Hits
0 Comments
John Keymer

Oracle LiveSQL Now at 12.2

I've been posting some bits recently on some of the new Oracle Database 12.2 features, particularly analytic views . However as 12.2 on-premise is not yet released you needed a paid Oracle Cloud account to be able to do anything. Recently however, Oracle Live SQL has been updated to version 12.2. This means with a free  Oracle account you can ...
Continue reading
0
  1018 Hits
  0 Comments
Tweet
1018 Hits
0 Comments
John Keymer

Calculated Measures in Analytic Views

SQL
Back onto analytical views, today I'm going to demo using calculated fact measures in analytic views as opposed to standard fact measures. You may recall from my Introduction to Analytic Views post that we can create simple fact measures within the fact table itself as follows. Create or Replace Analytic View emp_sales_avUsing emp_salesDimension By...
Continue reading
0
  1049 Hits
  0 Comments
Tweet
1049 Hits
0 Comments
John Keymer

Date Tracking with Temporal Validity in Oracle 12c

SQL
It's always nice to see new database features, and I especially like to see features which implement concepts that are commonly coded at the application level. I've posted a number of blogs recently on the new Analytic Views functionality in 12.2, however today I'm going to look at a feature introduced a little earlier in 12c (12.1) - Temporal Vali...
Continue reading
0
  1178 Hits
  0 Comments
Tweet
1178 Hits
0 Comments
       
4 5 6 7 8 9 10 11 12 13

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