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


Duplex printing Batch Reports to multiple clients on an even number of pages using RTF templates

Invoice_Banner
Following on from my previous blog featuring RTF templates, this blog addresses another issue that was encountered when working with a client who required reports (Invoices, Purchase Orders etc) from Oracle EBS to be printed duplex and in batch.​Printing reports duplex as opposed to Simplex throws out an issue where 2 separate invoices can be print...
Continue reading
  312 Hits
  0 Comments
312 Hits
0 Comments

Adding a Barcode or Cheque font to a RTF template when using Template Builder for Word.

Adding a Barcode or Cheque font to a RTF template when using Template Builder for Word.
We have recently had demand from a client to create RTF templates for both printing cheques and invoices. Both of which require using fonts which are not default in Microsoft Word. This blog will firstly talk through how to add these fonts both to your local machine for use in the RTF template, and to the server for use within Oracle EBS. ...
Continue reading
  320 Hits
  0 Comments
320 Hits
0 Comments

Connecting to an Essbase Cube using Smart View

Connecting to an Essbase Cube using Smart ViewMore 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 types...
Continue reading
  2538 Hits
  0 Comments
2538 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
  1805 Hits
  0 Comments
1805 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
  2663 Hits
  0 Comments
2663 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

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 projec...
Continue reading
  2704 Hits
  0 Comments
2704 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
  4443 Hits
  0 Comments
4443 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 functionalityhttps://www.youtube.com/user/OracleBITechDemos/videosThere'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 tal...
Continue reading
  2257 Hits
  0 Comments
2257 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
  2253 Hits
  0 Comments
2253 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 aggreg...
Continue reading
  3162 Hits
  0 Comments
3162 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
  3174 Hits
  0 Comments
3174 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
  2162 Hits
  0 Comments
Tags:
2162 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 there...
Continue reading
  1856 Hits
  0 Comments
1856 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
  1562 Hits
  0 Comments
1562 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
  7469 Hits
  0 Comments
7469 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