Cloud

O SpecGold OracleBusIntApps7 clr

 Gcloud

 

   Call us now 

  Manchester Office

  +44 (0) 8450 940 998

 

  

 

Mark Daynes - Director of Beyond Systems

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

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
    Login Login form
Mark Daynes

Mark Daynes

Mark's first experience of Oracle was back in the 80's building applications using very early versions of Oracle Forms at Staffordshire University. Upon graduating in 1990 with a First Class B.Sc.(Hons) in Information Systems, he joined Oracle UK's consultancy team working on some of the first Oracle Applications implementations across the UK, eventually working for Oracle Local Government. Over the subsequent years to 2006 he worked in a mainly technical/functional capacity across sectors such as Corporate Banking, Utilities and Public Sector, solely on projects underpinned by Oracle technology. In 2006 he became a founding Director of Beyond Systems where he has honed the focus of the company to be one of enabling public sector customers to achieve excellence with Oracle Business Intelligence, especially Oracle BI Applications sourced from Oracle E-Business. Mark has presented at many joint Oracle/Beyond events as well as contributing his perspectives on the technical/strategic business usages of Oracle to various magazines, the first appearing in ODTUG back in 1995. Outside of business, Mark is a keen musician and plays lead guitar in a covers band and also enjoys sports, especially skiing and golf.

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.  I then used the microphone to dictate into the app "Revenue in Americas for game station".  Yes - that's right - I just dictated - asked a fact ( the Revenue ) for a dimension value ( Americas which is in Regions ) for a specific Product (  Game Station ).

b2ap3_thumbnail_IMG_4943.PNG

If you see how that was interpreted, it replayed "America's" and "four" based on my diction and .... went and got exactly the right results!

I doubled checked this figure by actually going and querying it back using the traditional clicking about in the screens. 

I then thought that what would be interesting would be to ask Day by Day the same question but also extend it out to say "by Year" and see how it handles that.  Rather well it would appear.  It initially gave me a line graph that I was then easily able to toggle to a bar chart like this :

 

b2ap3_thumbnail_IMG_4945.PNG

Pretty cool.  I thought that I'd tell it that, so I pressed the "comment" button and commented on that

b2ap3_thumbnail_IMG_4946.PNG

I can then also share that with my "Crew" - or colleagues - as there's quite a bit of social engagement about it. 

b2ap3_thumbnail_IMG_4948.PNG

There's a lot to like about this - not just the fact I can ask it questions and get instant answers, but also that it can do location specific stuff and give me a feed of things I'm actually interested in and also share that information with colleagues.  I suggest that you do watch the video and if you need OAC/Day by Day setting up then please ask us!

Last modified on Continue reading
Tagged in: Day by Day Oracle
in Business Intelligence 24 0
0

Oracle's APEX ships with some great plugins such as D3 Collapsible Treemaps.  The most immediate way to see these is to install the Sample Charts application and have a play with it.

Now it is then fairly striaghtforward to utilise this plug-in in your own APEX applications.  Here I simply exported the plugin from the Sample Chart applications and loaded it into my new application.  I then changed the SQL to drive from my own tables and here we are.  What is appealing about this visualisation is that it shows the number of children under each node before you click to expland.  For example, here I can see that 1200 has 5 children underneath it.

 

I have also used the "Tooltip" funtionality to give me a nice popup description when I "Mouse-over" the node. 

 

 

Also each node can be made as a link that can drill off to show the user further detail, so it does really become quite a useful visualisation that can be used quickly and easily.

The Sample applications that ship with APEX ( and I'm currently using the latest 5.1.1 ) come with quite a few plugins that show off the extensibility of the framework and should give you some ideas on how best to use them, so if you are upgrading from older versions of APEX and making the leap to 5.1 then i'd highly recommend installing  selection of the applications and see what's been shipped there.  Of course this is the release that has finally integrated JET charts and we will cover some of their use and examples such as drilling to detail in a later blog.

 

 

Last modified on Continue reading
Tagged in: APEX APEX 5.1 D3
in Business Intelligence 233 0
0

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&D whilst we were formulating some recommendations for a BICS customer.

Whilst doing this we encountered a couple of issues with connectivity but fortunately we were helped out by this paper that has just been released by Oracle in February 2017 called "Known Issues for Oracle Business Intelligence Cloud Service". 

https://docs.oracle.com/cloud/latest/reportingcs_use/BILRN/BILRN.pdf

In addition this paper covers a few other things you will likely want to know about, so if you have embarked on a BICS installation then I highly recommend giving this a quick read.

 

Last modified on Continue reading
in Installation and Patches 414 0
0

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 functionality

https://www.youtube.com/user/OracleBITechDemos/videos

There'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 talking about yet is the SDK or the ability to use plugins to add new content; here's a quick way of doing this.

1) Goto the Oracle BI Public store

b2ap3_thumbnail_dial2.png

2) Select a plugin and download it.  Note that you DO NOT UNZIP the file and also you will need to create the /plugin directory.  By default on windows your %LOCALAPPDATA% directory is hidden so you'll probably need to unhide it to find it!

b2ap3_thumbnail_dial3.png

3) Volia - the new visualisation is available for use; here I have tweaked the setup of the dials and used them in my application.

b2ap3_thumbnail_dial1.png

...any questions ... please ask.

Last modified on Continue reading
in Techniques 841 0
0

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 tips to assist.  Note that Exadata Express provides you with a pluggable database (PDB) so if this is your first time with a 12c database then I recommend reading up all about how container and pluggable databases work.

Firstly you'll need to enable SQL*Net access and then click on the "Download Client Credential" in your console. 

b2ap3_thumbnail_consol1.png

This will download a zip file to which you allocate a password and you'll need to store that somewhere in your filesystem that SQL Developer can see it.

Now you'll need at least version 4.1.5 of SQL Developer for this to work, so upgrade if you're on an earlier one.  I'm a keen user of the 4.2 early adopter.

b2ap3_thumbnail_SQLDev.png

Create a new connection and use the new "Cloud PDB" connector.  The configuration file as the one that you downloaded when you were in the console.  Press "Test" and hopefully you should see the "success" message that I have.

b2ap3_thumbnail_DevConnect.png

That should be you up and running. 

.If you're following John's blog published on the 8th of October on Analytic Views then you may find the following useful.  SQL Developer now comes with a bunch of pre-built reports that give you some great insights of the analytics and their metadata that have been created.

b2ap3_thumbnail_HV-reports.png

Last modified on Continue reading
in Technical 778 0
0