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

SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions - Part 1

I wasn't too sure of what title to use for this blog post. I wanted to share some things that I see quite regularly at various sites in SQL or PL/SQL code where the developer has either not fully understood what they have written, or have done so under assumptions or risk. These are not necessarily always "mistakes" as such (and they may similarly ...
Continue reading
  2397 Hits
  0 Comments
2397 Hits
0 Comments

Aggregation Based on Dimensions in OBIEE

The Business Model in OBIEE allows for measures to be aggregated using a variety of different functions. For most scenarios this is sufficient. For example, if we are recording sales by month, then SUM(sales) will allow us to report on those amounts at a higher level such as year. Consider the following sample dataset. SalesPerson Month Name Sales ...
Continue reading
  12229 Hits
  0 Comments
12229 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
  4308 Hits
  0 Comments
4308 Hits
0 Comments

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Barnett House, 53 Fountain Street,

Manchester M2 2AN United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk