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

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

Oracle 18c Available on Live SQL Now!

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

Timing Repository Variable Refreshes in BI Applications

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

Simple Machine Learning

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

Oracle Data Visualization V4 - Data Flows

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

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Suite 1.01 Jactin House,

24 Hood Street, Manchester

M4 6WX United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk