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

Prune Days on an E-Business Suite Source Environment

Prune days... often misunderstood, often just left "as default". Possibly not helped by the fact that entering the search term into Google yields the following as the top hit: The LAST_UPD column in Siebel transactional database tables is used for incremental change capture. This timestamp reflects the actual event time. It is therefore possible fo...
Continue reading
  4712 Hits
  0 Comments
4712 Hits
0 Comments

Star Transformations with Bitmap Indexes

One area of data warehousing that often confuses people (typically those who have come from an OLTP development background) is bitmap indexes... why do we use them from a design point of view? How does the optimizer use them? What benefits do they have? Whilst this topic alone can (and does) cover entire books, I'm hoping to give a brief overview o...
Continue reading
  2705 Hits
  0 Comments
2705 Hits
0 Comments

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
  2550 Hits
  0 Comments
2550 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
  12813 Hits
  0 Comments
12813 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
  4593 Hits
  0 Comments
4593 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