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


Connecting to an Essbase Cube using Smart View

Connecting to an Essbase Cube using Smart View More and more Customers are moving onto Cloud ERP and there are so many new tools that can be used. In this blog I will be running through how to use Smart View to connect directly to an Essbase cube. Smart View reports are accessible using Financial Reporting Center which is a hub for 7 different type...
Continue reading
  36 Hits
  0 Comments
36 Hits
0 Comments

A Quick Glimpse into the Power of R

I remember when I moved into our first house, and I had to do a bit of DIY in the bathroom to replace some silicon sealant. I removed the old stuff using a utility knife, which whilst worked, involved a lot of messing about, a scratched bath panel, a cut finger and quite a bit of cursing. Several years on I had to do something similar, however this...
Continue reading
  352 Hits
  0 Comments
352 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 ...
Continue reading
  927 Hits
  0 Comments
927 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 - i...
Continue reading
  1684 Hits
  0 Comments
1684 Hits
0 Comments

Data Visualization Desktop – Data Actions

Oracle Data Visualization Desktop has a lot of useful features that you might not know about on first inspection, so in this blog I will run through what Data Actions are, and the clever ways they can be used in your own projects. A data action enables you to link a visualization with an URL, move to another page in your project or to another proje...
Continue reading
  555 Hits
  0 Comments
555 Hits
0 Comments

Creating an Organization or Position Hierarchy Chart

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...
Continue reading
  1091 Hits
  0 Comments
1091 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
  540 Hits
  0 Comments
540 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
  513 Hits
  0 Comments
513 Hits
0 Comments

Oracle Database 12.2 Released for Cloud Customers

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

Installation of Oracle Fusion Applications

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

Advanced Analytics with Oracle BI 12c

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right...
Continue reading
  517 Hits
  0 Comments
Tags:
517 Hits
0 Comments

If you're still using BI Enterprise 11.1.1.7 then watch out for 14th May 2016

Oracle BI Enterprise Edition 11g has been around for many years now and there are many people using 11.1.1.7 versions. This goes out of error correction support on the 14th May 2016, so something you want to be planning for if you're using that in production. You've got a couple of interesting options though: 1) Upgrade to BI EE 11.1.1.9 - yes ther...
Continue reading
  425 Hits
  0 Comments
425 Hits
0 Comments

Oracle BICS (BI Cloud Services) - Visual Analyzer

v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);} Normal 0 false false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-s...
Continue reading
  347 Hits
  0 Comments
347 Hits
0 Comments

External Tables from Shell Scripts

Here's a little example of something I found quite interesting, and which you generally don't see being used every day... Oracle has a concept known as "External Tables" which basically allows a table to be created inside the database which sources its content from outside the database.  This can be as simple as a .csv file, or more exciting (...
Continue reading
  4841 Hits
  0 Comments
4841 Hits
0 Comments

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

76 King Street, Manchester

M2 4NH United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk