Monday, August 6, 2018

Available to download - Oracle Data Visualization Custom PLUGIN "Elbow" Dendrogram

Excited to announce that a custom PLUGIN I have been working on is available to download and start using now - available on

The Oracle Analytics Library: https://www.oracle.com/solutions/business-analytics/data-visualization/extensions.html

Within the Extensions tab

or download here


Name: "Elbow" Dendrogram

Authors: G. Adashek & D.Flores

Description:
The “Elbow” Dendrogram creates a hierarchy based Parent-Child like structure with ‘links-arms’ that are bent at a 90° angle. This plugin can render a #measure element and is zoomable.

Friday, June 15, 2018

Smart View 11.1.2.5.800 released!

And so it is mid-June .. and we now have Smart View version 11.1.2.5.800 as stated released in GA!

per the documentation here are the listed new features a part of this release and the hyperlinks to go directly to the documentation for each



Let's take a look at one of the new features ...


Perform a Health Check On Your System (for Smart View settings, Options, etc.)

I really like this feature being added!

So many times as a new user (new Smart View installation), a power user, an administrator, there are a number of settings that are or are not set by default.

Glad that there is now an easy way to be able to see the commonly asked settings all in 1 place to be able to update and/or edit-provide yourself.

This setting is found on the Main Smart View tab within the "? Help" dropdown menu as menu item
named "Health Check"



Click on the menu item and you will see a Health Check diagnosis msg box that shows the Details as information, properties, settings, options are set on your local machine




If you click on the "Recommended Settings" button on the bottom of the msg box the health check will provide another dialog box. In my case, this is a brand new VM .. as my prior VM melted, so none of the Timeout settings have been updated.

This time, no Google searching required or digging up the regedit file .. just 2-button clicks and the settings were updated! I didn't need to know the hex values, etc.

Click "YES"




And with that .. I think this feature might cause 1 of my prior blog posts to become deprecated!!!

Thanks to the Oracle Smart View product management and development teams for implementing the suggestion :)


Side Note:
We heard, were told, and saw slides at KSCOPE18 during the EPM Sunday Symposium session that Smart View and Office 365 support will be coming at some point CY2018 as well as Mac support!!!





Sunday, May 27, 2018

Smart View 11.1.2.5.800 coming soon!

A NEW version of Oracle Smart View for Office will be available in mid-June ..

KSCOPE18 is about that time, would be nice to have the update prior to the conference 😉


Here is the release note:

Oracle Smart View for Office 11.1.2.5.800 will be available by mid-June. This version includes new features such as:
  • Move Formatting behavior enhancement to notify you of performance impact
  • Improved resolution on high-definition devices, such as Microsoft Surface Pro tablets
  • New Health Check, where you can view information about your system, and configure Smart View options and Windows Registry settings geared toward improving performance and reducing flickering
This release also fixes a number of defects.


These updates feel very cryptic, not without mention to MS Surface Pro tablets and wish that it read Macbook Pro instead for a High Def device. Someday a Mac version will be available.Maybe?

Health Check sounds fun. I wonder if this also includes the ability to regedit the 3 settings always needed to be added to first time users for timeout-fails.

Happy Birthday to me today! 🎂

Can't wait for KSCOPE18 in 2-weeks!!!


Sunday, April 29, 2018

Spring Fever .. OAC .. Major League Baseball

It is that time of year again --

when spring is upon us
the snow starts to melt
the birds chirp outside the window in the morning .. 
and the Major League Baseball season begins ⚾

As I am getting ready for presentations, I wanted to share a few neat visualizations .. a little bit of a sneak peak.

CAN'T WAIT for anyone who wants to attend to see the full finished product!


Custom Plugin CollapsibleTree

WITH DATA (#measure)




WITHOUT DATA (#measure)



This is still one of my favorite visualizations!

DimPlayer is my favorite combo visualization!


And now that the 2018 MLB season is underway, it is time to update the ALL_MLB_STATS Essbase cube with 2017 data :)


A nice night & weekend little project is about to get started!! Stay tuned


Thursday, March 15, 2018

Selected to Present at KScope18!


I am honored to be selected as a speaker-presenter x2 at KScope18!


This year it will be in Florida at Disney World!   



According to the ODTUG communication, there were more than 1,000 abstracts submitted!


These are the presentation titles and can't wait to attend!



Presentation Title (solo): Inside Out OAC Essbase & DV


hope you like the disney pixar theme


Presentation Title (co-presenting with Gary Crisci): Save "The Beverage Company"! -- How to impress people with Smart View in PowerPoint

And an Essbase classic or should i say a basic sample

Sunday, March 11, 2018

OAC - DV .. Plus BI via Smart View

OAC - Essbase & DV .. plus BI via Smart View


It was a few posts ago and I only mentioned it at the very end of this prior post

http://adashek-epm.blogspot.com/2017/11/oac-data-viz-bi-new-dbx-v12211108.html

That if you want to see the Visualizations in Smart View you had to open the Classic Home...


How do you create .. a "classic" BI report/analysis


Well, you can find the Classic BI as it is the link on the lower left of the Data Visualization panel pane

"Open Classic Home..."







Once clicked, it should open a new browser window/tab.
And you are now in the "Classic" BI .. this is the same BI as it always was ..
go ahead and start to create analysis and dashboards, etc.

Only a small point to note, this BI does let you know that you are still in Oracle Analytics Cloud (OAC), meh




For this example I created a simple analysis with a Pivot Table visualization-type
as of now there are only a few limited visualizations that are supported in Smart View, hope we see all of them some day soon ..






Once created, it is time to see it via Smart View.


Here again, it follows the same tried and true procedure of setting up a Smart View OBIEE connection.



using the syntax: 

http://my.ip.address:80/analytics/jbips


Now that the connection is created, login

As I attempt to login, I am reminded of the painful question, why is the Connection type named, Oracle BI space EE???

Moving on, by expanding the folder where you have saved your analysis, etc. you can now bring that in via Smart View






I selected to see all objects on 1-slide .. I mean worksheet as I am in Excel.



And there you have it, OAC - Essbase/DV plus now a little bit of BI via Smart View.




Again, hope to see many many many more visualization types supported in Smart View soon!

Until next time, stay safe in the cloud.


Thursday, February 15, 2018

OAC - Essbase .. WRITEBACK via OAC - DV!!

OAC - Essbase WRITEBACK IS ALIVE!


Well, the day has finally arrived, Essbase Writeback in the cloud is real .. and a thing 😎🤓🤓😎


Let's get into the how-to and what it looks like.



But first, a BIG shout out to Gary Crisci for being able to battle the patch frontier and slay the OAC demons!


OAC - Essbase patched to version 109 .. skipped right over 108 to specifically Version 12.2.1.1.109 - Build 126







Steps to success



  • Create an Essbase cube in OAC (thought that this step and a few others might be obvious ..)



https://www.oracle.com/solutions/business-analytics/data-visualization/library.html


  • Find the Custom Plug-In: Essbase Write-Back plugin by Oracle





  • Click Download to Download the zip file


  • Log into the OAC - DV/BI instance


  • Go to Console




  • On the panel, click Custom Plugins





  • Upload the saved Custom Plugin from the step above, drag and drop or click "Upload Custom Plugin" and select the zip file



  • On the panel, click Safe Domains




  • Click, "add domain"



  • Domain Name: enter * (wildcard)
  • Check all of the boxes: Image, Frame, Script, Font, Media, Connect





















  • Sign Out of OAC DV/BI
  • Sign back into OAC DV/BI
  • Navigate to Data Sources / Create / Connection / Oracle Essbase (Beta)
>>> When does this Connection Type not say (Beta)! <<<



Connection Details:

*New Connection Name: "Your Essbase Server"

*DSN: IP or host:Port /essbase /agent
ex. http://my.IP.address:80/essbase/agent

*Username: <AdminUsername>

*Password: <AdminPassword>

*Authentication: Always use this credentials??

  • Click 'Save'


From the OAC - DV/BI Home

  • Click Create .. Data Set ..
  • Select the Newly created Connection
  • Select the Essbase Cube that is a part of that Connection that you want
  • Click 'Add'


You should see a notification "The Data Set was successfully saved."


  • Now go ahead and create a Project
  • Select the cube you added as a Data Source of the "Essbase Server" above
  • Create your visualization adding the dimensions .. ALL of the dimensions
  • Change the Visualization..


  • Select the "Essbase Writeback" Viz




Now your Viz looks more like a reporting grid 😀 .. go ahead and double click a data cell .. and enter/change data .. Click 'Submit'


In this case I changed Sample Basic
Budget Sales May 400-10 Wisconsin from 90 to 100



Nice to see the cell change color to the muted yellow similar to either Workspace or Smart View

You should now get an inline popup window that is asking to re-validate the credentials in order to accept the data change being submitted to the cube..






Target Database Detail:
Should all be the same credentials that were used above
ex. http://my.IP.address:80/essbase/agent
*Username: <AdminUsername>
*Password: <AdminPassword>

  • Click 'Fetch'
  • Click the dropdown arrow for Application and make your selection
  • Click the dropdown arrow for Database and make your selection
  • Click 'OK'

.. and your grid should "Refresh" .. wait for it

and now be updated with the new data value(s) saved in the cube!!!!






Coming soon .. a blog post about the latest version of

Cube Designer Version 12.2.1.1.109 Build 126