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.


3 comments:

  1. Hi Wayne, really cool article. I just want to share with you that Synopsis with the new OAC support will read your original data set from that cloud source. If some of the columns are not detected correctly, you can change its type like moving Year to a dimension column and you will see it on your x axis.
    If you have any other questions, please let me know.

    ReplyDelete
    Replies
    1. Thanks Alex. I saw option...I had planned to show that as an option in another post.

      Delete
  2. Hi Wayne,
    How to modify DB connection to in the existing DataSet?
    Let's say, I have created a Dataset with DB connection "DB-A", if I want to modify the connection to "DB-B" in the same Dataset - How do I do it? Could you please help me here.

    ReplyDelete