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

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
  640 Hits
  0 Comments
640 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
  753 Hits
  0 Comments
753 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
  217 Hits
  0 Comments
217 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
  891 Hits
  0 Comments
891 Hits
0 Comments

Oracle Exadata Express 12.2 - Connecting SQL Developer

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