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

An Introduction to Analytic Views in Oracle 12.2

Saturday, 08 October 2016

John Keymer

SQL

In my last blog post on Oracle Database 12.2 I mentioned the new Analytics View feature. Now in this post I am going to describe the basic structure of what an Analytic View is, and then show an example of creating a very simple one. Note - the Oracle documentation for syntax is very thin at the moment and this information has therefore been taken ...

2106 Hits

0 Comments

2106 Hits

0 Comments

Oracle Database 12.2 Released for Cloud Customers

Wednesday, 28 September 2016

John Keymer

Other Technical

Oracle Openworld 2016 saw the latest Oracle database version announced with immediate availability in the cloud - 12.2. Unfortunately this is not yet available on-premise however a free trial can be obtained over at cloud.oracle.com . This release contains some exciting stuff such as 128 byte identifiers (up from 30), additional approximation aggre...

961 Hits

0 Comments

961 Hits

0 Comments

Installation of Oracle Fusion Applications

Thursday, 25 August 2016

John Keymer

Other Technical

Here at Beyond we recently started updating some of our internal test environments. As part of this I embarked on the rather daunting task of installing Oracle Fusion Applications. Daunting because 1) I'm not a DBA and 2) I've never personally done such as installation myself ever before! What could possibly go wrong? We picked up a copy of Pro Ora...

1097 Hits

0 Comments

1097 Hits

0 Comments

Delegated Proxy Access in E-Business Suite R12.2

Friday, 12 August 2016

John Keymer

E-Business Suite

I've posted a few things over the previous months regarding new or changed functionality in E-Business Suite R12.2, and here is something that I think will be particularly useful. In previous versions of E-Business Suite it's possible to grant access to full account level access to another user, however as of 12.2 this has been enhanced to responsi...

1460 Hits

0 Comments

1460 Hits

0 Comments

Relationship Issues

Friday, 29 July 2016

John Keymer

SQL

Relationship Issues No, this isn't the latest agony aunt column - I'm talking about data relationships ! Specifically, relationships between columns within single tables. For example, let's take a simple list of UK towns with their associated county and country. This was the first hit on Google when I did such a search. Now assume we also have a ta...

1012 Hits

0 Comments

1012 Hits

0 Comments

Beyond Blog

An Introduction to Analytic Views in Oracle 12.2

Oracle Database 12.2 Released for Cloud Customers

Installation of Oracle Fusion Applications

Delegated Proxy Access in E-Business Suite R12.2

Relationship Issues

Demonstration

Contact