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

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
  214 Hits
  0 Comments
214 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
  763 Hits
  0 Comments
763 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
  260 Hits
  0 Comments
260 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
  289 Hits
  0 Comments
289 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
  237 Hits
  0 Comments
237 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
  2054 Hits
  0 Comments
2054 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
  262 Hits
  0 Comments
262 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
  173 Hits
  0 Comments
173 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
  733 Hits
  0 Comments
733 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
  1524 Hits
  0 Comments
1524 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
  224 Hits
  0 Comments
224 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
  243 Hits
  0 Comments
243 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
  3657 Hits
  0 Comments
3657 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
  3920 Hits
  0 Comments
3920 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
  3866 Hits
  0 Comments
3866 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
  124 Hits
  0 Comments
124 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
  3890 Hits
  0 Comments
3890 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
  4048 Hits
  0 Comments
4048 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
  4457 Hits
  0 Comments
4457 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

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