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


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
  1213 Hits
  0 Comments
1213 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
  1299 Hits
  0 Comments
1299 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
  1407 Hits
  0 Comments
1407 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
  751 Hits
  0 Comments
751 Hits
0 Comments

Using Data Dictionary Metadata in Oracle 12.2 Analytic View Applications

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 Sal...
Continue reading
  1533 Hits
  0 Comments
1533 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