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

Extracting Data from Oracle Fusion SaaS using Data Replicator in Oracle Analytic Cloud Service

Daniel Willmott

Thursday, 25 October 2018

Business Intelligence Cloud

If you were keeping up to date with the goings on at Oracle OpenWorld last week, then you may have caught Larry Ellison announcing the ' Fusion Analytics Data Warehouse '. Whilst the specific features that were showcased are unlikely to be avai...

Oracle Day by Day App

Monday, 19 June 2017

Mark Daynes

Business Intelligence

Oracle have released the new Day by Day app for both iOS and Android and it's rather good. There's a great 6min video here https://www.youtube.com/watch?v=8q4foZyYQJc which I highly recommend watching, but I thought I'd share my first experiment with it. I connected to my demo Oracle Analytic Cloud instance to use the good old Sample App test data....

2282 Hits

0 Comments

Tags:

Day by Day Oracle

2282 Hits

0 Comments

Auditing Record Changes in an E-Business Suite Environment

Monday, 15 May 2017

John Keymer

E-Business Suite

A question that comes up all the time on the OTN Forums is "How do I know who updated this record?" . Generally the response is to point the member in the direction of the last_updated_by column on the table. The next question often then comes up... So how do I see what the old value was?" . Hmmmm... a little more tricky. We can try to look at flas...

3261 Hits

0 Comments

3261 Hits

0 Comments

BI with D3 Visualisations in APEX

Wednesday, 03 May 2017

Mark Daynes

APEX

Oracle's APEX ships with some great plugins such as D3 Collapsible Treemaps. The most immediate way to see these is to install the Sample Charts application and have a play with it. Now it is then fairly striaghtforward to utilise this plug-in in your own APEX applications. Here I simply exported the plugin from the Sample Chart applications and lo...

2101 Hits

0 Comments

Tags:

APEX APEX 5.1

2101 Hits

0 Comments

Creating an Organization or Position Hierarchy Chart

Thursday, 20 April 2017

John Keymer

Other Technical

Many clients I have worked for have expressed an interest in a graphical organization chart generated from their E-Business Suite ERP system. Unfortunately the org chart diagrammer in EBS isn't really all that great. And the strategic Oracle reporting tools (Business Intelligence etc) are even worse! It's actually surprisingly difficult to render a...

2677 Hits

0 Comments

2677 Hits

0 Comments

The Basics of Consumption Queries in SQL

Friday, 31 March 2017

John Keymer

SQL

I was inspired to post this blog by a post on the OTN Forums where a user was asking about calculating the consumption of hours against a target - that is, given a target of X hours with N hours per day, how many days would it be until they reached the target? I knew I had done similar things several times in the past, and each time I always seem t...

1546 Hits

0 Comments

1546 Hits

0 Comments

Beyond Blog

Extracting Data from Oracle Fusion SaaS using Data Replicator in Oracle Analytic Cloud Service

Oracle Day by Day App

Auditing Record Changes in an E-Business Suite Environment

BI with D3 Visualisations in APEX

Creating an Organization or Position Hierarchy Chart

The Basics of Consumption Queries in SQL

Demonstration

Contact