Sunday, October 15, 2017

Smart View Query Designer Gets Emotional

Smart View and Query Designer

I can't recall ever seeing this 'Warning Box' before while using Smart View and creating Query Designer Worksheets, etc. 

So, here is a little blog post about it.


  



And it is a Sunday GAMEDAY with less than an hour before kick-off, so I better complete this short but loving post in time..

I was creating a few Ad-Hoc Essbase queries and wanted to take one of my analysis sheets and turn that into a nice dynamic Query Designer report.

So, I followed the steps that I normally do. I usually start with an Ad-Hoc Query first. Then let Smart View and the Query Designer do a bit of the heavy lifting and transform that sheet into a 'Query'. I applied the query and got the desired results that I wanted.

A part of my analysis required me to start over and so I went ahead and started deleting the worksheets from the workbook. When I was done, I went to save my work. Clicked Save. And then the error appeared..

Sometimes when working with Smart View, I have to admit, I am reminded of this wonderful Disney Movie, Inside Out and all of the emotions.














Good news is that it looks to only be a warning-suggestion. But it feels a bit sad or even angry that the Query Designer worksheets were missing. Sorry to upset you Smart View.



















Borderline anger?



I went ahead and clicked 'OK'. Closed the workbook, re-opened and everything worked just fine.



Glad to see that Smart View was only maybe giving me a suggestion or trying to remind me :)



Well, phew, glad this was a short post. Now time for me to grab a bite to eat and watch the game!



Friday, October 13, 2017

OAC Patch 17.3.5 - Version 12.2.1.1.107 Essbase & Cube Designer

Oracle Analytics Cloud Service (OACS) 17.3.5 is Available - apply the latest patch

This caveat to the latest patch was talked about a TON at OOW this year .. 
  • OAC 17.3.5 does NOT offer IDCS integration (targeted for next release)

Essbase Version 12.2.1.1.107 & Smart View Extension - Cube Designer





Along with this patch was an update to the Cube Designer Extension

Previous Cube Designer Extension - 12.2.1.1.106



New Cube Designer Extension - 12.2.1.1.107





OAC - DV


I know that there have been a few others that have posted about how to do this but I don't think it would hurt to continue to share how to be able to set up
OAC - Essbase as a Data Source in OAC - DV

It is really all about creating two (2) Access Roles on the OAC - Essbase-side

This is the Oracle Support document that is easy enough to walk through
OAC : How to create connection to Essbase from Visual Analyzer (VA) in Oracle Analytics Cloud (OAC) (Doc ID 2265410.1)


Once the roles are created you are then able to set up OAC - Essbase as a data source in OAC - DV, pretty cool! Happy visualizing 💭  👀
More posts on OAC DV coming soon.



My MLB Baseball Essbase cube in the cloud fun side project (Yes, that is what i consider something fun to work on nights and weekends when I am not doing work-work, creating dioramas, reading, listening to all sorts of Disney movies, songs, dancing, etc.) has been coming along very nicely.

I am looking forward to seeing what that data looks like in OAC DV now! 😎


More blog posts to follow