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

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
  860 Hits
  0 Comments
860 Hits
0 Comments

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
  830 Hits
  0 Comments
830 Hits
0 Comments

Calculated Measures in Analytic Views

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
  826 Hits
  0 Comments
826 Hits
0 Comments

Date Tracking with Temporal Validity in Oracle 12c

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
  947 Hits
  0 Comments
947 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
  378 Hits
  0 Comments
378 Hits
0 Comments

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Barnett House, 53 Fountain Street,

Manchester M2 2AN United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk