Friday, September 29, 2017

OAC Datasets and Connections in Synopsis

it is late in the evening of Sept. 29, 2017 or early in the morning of Sept. 30, 2017...Regardless...I cannot sleep!

I noticed that my Galaxy Note 8 updated my Oracle Synopsis App.  I see that it is a 2.0 release...I am not one to read manuals and updates right off so I started looking around on the app to see what was new.  The first thing that caught my eye was in the Settings.  Something new stood out...Smart Lock on OAC


Well that really got me wondering...Can my Synopsis connect to my OAC instance and if so what can I access.  So I went to the main screen and created a new project and there was an option to connect to OAC.

So I figured, in for a penny in for a pound.  I tapped (because we all know you do not click on a tablet) and I got a sign on screen.

I provided my credentials and I was presented with a list of data sources. I had just created a data file named Kool Kart Dataset from a Data Flow I was working on and I noticed it was in my list.



Checking my Data Sources in OAC i see most of the same list...



The only difference is that my Subject Areas (the purple icons at the top of the list) are not listed in my Synopsis menu...This seems right since Synopsis seems top operate from a data file based on columns of Dimensions and Facts.  So what happens if I try to load up one of the Essbase Connections...I tapped on Sample.Basic and...



Well that was educational.

So I tapped on my Kool Kart Dataset.  And it loaded up into Synopsis with some quick analyses based on the data in the file.


While it did a pretty good job of interpreting the data in the data file it treated the Year column as a measure as indicated by it being displayed on the X-axis with Revenue and Number of Orders.

Well that is something to investigate further.  

The ability to connect to OAC, display content in Synopsis is a huge leap forward in mobile analytics.  Oh and by the way, did you know Synopsis is FREE...Look for it on Apple iTunes and Google Play.