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 Row Generators and Cardinality

Thursday, 08 March 2018

John

SQL

I'm quite a fan of row generators. If I know I need a row for every day of the year for example, I generally avoid holding (and maintaining) a table of these dates, and instead will generate them. This is by no means a universal rule, so take each case on its merits.select trunc(sysdate,'YYYY') + level -1 dt from dualconnect by level <= add_mont...

3408 Hits

0 Comments

3408 Hits

0 Comments

Oracle 18c Available on Live SQL Now!

Thursday, 22 February 2018

John

Other Technical

If you haven't already used Live SQL then you're missing out. This free (Enterprise Edition) database instance provided by Oracle as a sandpit for trying things out and learning new stuff is a great resource. More importantly, it tends to be kept in line with the latest "hot off the press" database release.So it came as no real surprise last week w...

2958 Hits

0 Comments

2958 Hits

0 Comments

Timing Repository Variable Refreshes in BI Applications

Tuesday, 06 February 2018

John

Business Intelligence

This issue arose at a customer today, and I've seen it happen in the past, so I thought it worthwhile making a quick note. A situation had arisen which had caused the overnight ETL execution to be delayed. Once this had completed the users complained that the dashboard was missing some data. This was tracked down to a shared filter which contained ...

4042 Hits

0 Comments

4042 Hits

0 Comments

Simple Machine Learning

Wednesday, 10 January 2018

John

Other Technical

With machine learning being one of te big things at the moment, I thought I'd cast my mind back to my first ever c programming assignment at university - write the game of Pangolins. The game is based on the 20 Questions game, whereby the user thinks of an object and the machine aims to guess that object by asking simple yes/no style questions - id...

3676 Hits

0 Comments

3676 Hits

0 Comments

Oracle Data Visualization V4 - Data Flows

Wednesday, 20 December 2017

Mark Daynes

Business Intelligence

Data Flows in v4 of Oracle Data Visualization (in the new OAC as well as Desktop) is much improved, so let's look at creating a flow to :Join together two datasetsFilter the columnsCreate some binsAdd a new calculated columnSave the results as a singe data source that we can then analyze.Our flow will eventually look like this .....We will start wi...

4007 Hits

0 Comments

Tags:

4007 Hits

0 Comments

Beyond Blog

Oracle Row Generators and Cardinality

Oracle 18c Available on Live SQL Now!

Timing Repository Variable Refreshes in BI Applications

Simple Machine Learning

Oracle Data Visualization V4 - Data Flows

Demonstration

Contact