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 Data Visualization with Oracle Cloud ERP data sourced from OTBI

I was at a conference recently when I asked the audience who's connected DV to OTBI.  Not many had, so as it is relatively straightforward then I thought I show you how to do that.  Firstly we need to create a connection, so click on create a new connection and select Oracle Applications Next, fill in the appropriate connection details.&n...
Continue reading
  249 Hits
  0 Comments
249 Hits
0 Comments

Creating new calculated items with Oracle Data Visualization

I’m often asked ‘How do I/Can I create my own calculations in DV?’, so I thought that I’d put up a short blog on how to achieve this. I’m going to quickly create some sample data that show some simple sales figures for 99 offices. I’m then going to create 10 buckets ( or ‘bins’ ) and get DV to show wh...
Continue reading
  376 Hits
  0 Comments
376 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
  971 Hits
  0 Comments
971 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 datasets Filter the columns Create some bins Add a new calculated column Save the results as a singe data source that we can then analyze. Our flow will eventually look like this ..... We will s...
Continue reading
  500 Hits
  0 Comments
500 Hits
0 Comments

Oracle Data Visualization v4 - Sentiment Analysis

Oracle Data Visualizer has been out for a couple of years now and is already on version 4. I'm a big fan and have been digging deep into the latest release which has brought in a substantial amount of changes. They are all available here , but I think that the most exciting inclusions are around the Explain capability and new algorithms that have b...
Continue reading
  592 Hits
  0 Comments
592 Hits
0 Comments

Data Visualization Version 3

Data Visualization 12.2.3 ( aka v3 ) is now downloadable from here What a great upgrade it is, absolutely packed with new enhancements to increase the functionality and make data discovery even quicker. The trendlines (as shown above) now allow for additional functionality such as a %age confidence. There's new data sources too - we can even connec...
Continue reading
  438 Hits
  0 Comments
438 Hits
0 Comments

Organization or Position Hierarchies in Oracle OBIEE

A while back I created a post describing how to produce an organization chart in Oracle APEX using Google visualizations. If you didn't catch that then go and take a look here first before reading on as it will provide the background reading to this post. So in this post I am going to demo how we can do this in OBIEE - and it's actually quite easy ...
Continue reading
  2200 Hits
  0 Comments
2200 Hits
0 Comments

Oracle Day by Day App

Oracle have released the new Day by Day app for both iOS and Android and it's rather good. There's a great 6min video here https://www.youtube.com/watch?v=8q4foZyYQJc which I highly recommend watching, but I thought I'd share my first experiment with it. I connected to my demo Oracle Analytic Cloud instance to use the good old Sample App test data....
Continue reading
  518 Hits
  0 Comments
518 Hits
0 Comments

Known Issues for Oracle Business Intelligence Cloud Service - February 2017

Whilst BICS comes with complete Schema as a Service, some customers choose to use database as a service (DBaaS) for many reasons (such as the ability to use the on-premise modelling tool and "lift and shift" the model). DBaaS has recently been upgraded to offer 12.2 as an option for the database which is what we were trialling as part of internal R...
Continue reading
  346 Hits
  0 Comments
346 Hits
0 Comments

Oracle Synopsis for iOS Released

Oracle Synopsis was first announced at Openworld 2016; a mobile platform to allow data analysis on the go on a mobile device. Think of it a bit like Oracle Data Visualizer Desktop for your phone or tablet. Up until now though it's only been available for Android devices, however over the weekend the iOS version was released on the Apple Store . So ...
Continue reading
  944 Hits
  0 Comments
944 Hits
0 Comments

Combining Facts/Subject Areas in Oracle OBIEE - Part 2

A while back I wrote a post about how to combine measures from different facts in an OBIEE analysis. If you missed that then you can find it here . One of the key issues I highlighted was that generally it is only possible to join up facts where the dimensions you are using are common across both facts. I.e. There is however a technique that can be...
Continue reading
  1795 Hits
  0 Comments
1795 Hits
0 Comments

Data Visualization Desktop

Oracle have recently released Data Visualization Desktop (http://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html) which “gives decision-makers their own personal desktop application to access, explore, blend, and share data visualizations” . If you already know Ora...
Continue reading
  442 Hits
  0 Comments
442 Hits
0 Comments

Creating Popup charts in Oracle BI 12c

We've been working with a number of customers who want to see context specific charts/graphs displayed when the mouse rolls over values in a table, rather than having to drill. In order to show an example of this rather slick approach we have created a 30 second video as a demonstration Please have look here https://www.youtube.com/watch?v=bZHzcMmL...
Continue reading
  456 Hits
  0 Comments
456 Hits
0 Comments

Combining Facts/Subject Areas in Oracle OBIEE

I wanted to write this as an introduction to combining data from multiple facts/subject areas into a single analytic. The post is aimed primarily at end-users as there are developer techniques we can use to circumvent some of the restrictions described below. Let us first refresh ourselves with a subject area actually is. In its most basic form it ...
Continue reading
  4002 Hits
  0 Comments
4002 Hits
0 Comments

*)nqgtu(* - Working Around an Odd Bug in OBIEE

Note: This post relates to an issue which has been produced in Version  11.1.1.7.150120  for the purposes of this blog. It  may not be present in previous versions and may be fixed in future releases. You write an analytic and it runs fine. You stick it on a dashboard with prompts and it runs fine. So you now decide to extend that da...
Continue reading
  4084 Hits
  0 Comments
4084 Hits
0 Comments

Extending and Enhancing the use of Variables in the OBIEE Repository

Session variables are used in the OBIEE repository for (amongst other things) setting user context information for use in analytics and dashboards. These can either be standard variables, or row-wise variables, the difference being that a row-wise variable acts as an array, i.e. it can hold multiple values. A standard variable may be used to hold a...
Continue reading
  4100 Hits
  0 Comments
4100 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
  245 Hits
  0 Comments
245 Hits
0 Comments

Oracle BI Cloud Service (BICS) - Going Beyond SampleApp

One of the products Oracle are currently pushing very heavily is Oracle BI Cloud Service (BICS). BICS allows customers to leverage the features of Oracle Business Intelligence (a limited set of them at least) without the need for on-premise hardware, maintenance overhead, upgrade management and so on. Data can be either uploaded directly into the t...
Continue reading
  4082 Hits
  0 Comments
4082 Hits
0 Comments

Monitoring Oracle Data Integrator (ODI) Load Plan Executions with BI Apps

Whilst using the standard Oracle tools for load plan execution monitoring and diagnosis I can't help but feel sometimes that it's a little "clunky". An overview of the execution can be seen from BIACM and progress can be seen through ODI Studio Operator, however I either have to look in multiple places to see the current progress and state of a loa...
Continue reading
  4339 Hits
  0 Comments
4339 Hits
0 Comments

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

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