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


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

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

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
  1915 Hits
  0 Comments
1915 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
  1565 Hits
  0 Comments
1565 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
  1770 Hits
  0 Comments
1770 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