Saturday, November 18, 2017

OAC Essbase & DV Hit Play

Have to say that I am really liking the OAC DV and the custom Plug-Ins that you can easily download and drag and drop the zip file!

I mentioned a few of them in my prior post with the Tree Viz and the Row Expander

This is another custom plug-in that is really fun to use, Dim Player

Again, a few
Easy Prep Steps:

  • Navigate using your favorite browser to ->
  • Click the 'Plug-ins' tab
  • Find the Plug-in that you are interested in adding to your set of visualizations
  • Download the Zip file

Here are a few tips to make sure that you are able to properly use this plug-in

You need to have a Dimension with the Dimension Type = Time (required)

Years dimension is shown with a clock 🕒

Start creating your Project, select your dataset(source), visualization.. add measure(s) etc.

Next you want to navigate on the left menu column and click the vertical bar icon for Visualizations.

Scroll to find your next viz to add, in this case DimPlayer, drag it onto your canvas

The magic of this plug-in is that it uses the Time tagged dimension as the Play Axis

In my MLB cube, I have the Years dimension, drag the desired Generation in as the PlayAxis

But we are not ready. We need to ensure a few more items.

Open the 'menu' of this newly added viz.

Click/check ' Use as Filter'

You also have the ability to change the speed of the refresh rate of the viz, just use the interval and key-in +/- the # of seconds you would prefer.

You are now ready to Just.Hit.Play

All of the MLB Homeruns hit over time in approx. 1min!

Sunday, November 5, 2017

OAC Data Viz & BI + New DBX v12.

It has not been that long since the Halloween  👻  💀  🎃  holiday season.
So let's have a little trick or treat spirit to this blog post shall we.

And in that spirit, we will only be getting tips and treats and less on the tricks. 🍬 🍭 🍫

Let's begin.

As per one of my prior posts, I was able to 'connect' OAC DV/BI to OAC -Essbase and the amazingly fun Major League Baseball cube (And Yes I owe a few of you a copy of the Oracle Cube Designer for Excel model)

🍬  Fun Fact: the format for these Workbooks is called DBX format (Structured Excel)

🍭  It is also worth mentioning that there is also a New version of the Cube Designer Extension available to download and install; Build 117

There are a few updates to note in this version:

  • Member Formula validation
  • Hierarchy Viewer Duplicate Member Outline Support
  • Transform Data enhancements

Moving on. OAC DV/BI

I will be using the MLB STATS cube that I created to share my examples.

I noticed that there are a number of Visualizations already available, nice, but there are also more Plug-ins that can be easily download/uploaded for your use as well.

Easy Prep Steps:

  1. Navigate using your favorite browser to ->
  2. Click the 'Plug-ins' tab
  3. Find the Plug-in that you are interested in adding to your set of visualizations
  4. Download the Zip file

🍫  Next Steps within OAC DV/BI:

Login ;) -> http://<your IP address>/va/?pageid=home

Click 'Console'

Click 'Custom Plugins'

Either 'Upload Custom Plugin' or drag-and-drop the downloaded zip file into OAC

Time to create your New Project and add one of these newly added Custom Plugins

One of the ones that I recently got feedback "That is REALLY cool!" was the use of the 'Collapsible TreeViz' Plugin.

This Plugin does NOT require a #Measure! Take a look.

This example was for the MLB World Series matchup between the Dodgers and the Astros.
Looks like the list of Teams aligned to the Active Franchises of the Dodgers is 9 and the Astros is 3.

This in my opinion IS REALLY COOL!
Wonder what it would look like against DRM?!?! I might need to create that as a Data Source.

Another Custom Plugin that I added was 'RowExpander'

There are times in DV that I want to see my data easily in an expandable Tree View (Hierarchy). My dataset is naturally 'built' that way in Essbase. And I want an easy way to navigate my dataset accordingly.

To simplify my example, I filtered the data to only include Players that Last Names begin with 'AA'.

Notice that there is a 'carrot-arrow' symbol '>' next to each row member that is available for expansion. This makes me feel a little nostalgic and creating HFR reports .. checking the checkbox to 'Allow Expansion'. Maybe it is just me and the good ole days of learning to use it, and, well .. since it has stood the test of time of it's look and feel of 1997 .. But I would like to have HFR available in OAC to create highly structured and formatted reports, books and even batches, that is, at least for Essbase, Planning, or other EPM datasources created in OAC. One can only hope, although, HFR is now only Web version supported and no more desktop client installer (HFR desktop client install, you were my nemesis! Hope you rode off into the sunset of product installers well my friend). I digress.

So, for me the Player above with 755 Career Homeruns is obvious. Do you know who this MLB Player is?

Another Fun Fact in closing this post.
In order to see my Viz/analysis via Smart View, I needed to create Reports using the Classic OBIEE  Designer.

Only then was I able to create a Smart View connection, see the repository and add these objects into Office (Excel, PowerPoint, Word).

Until next time. Stay safe while using OAC. Your Alias Table(s) might not be  👻   😞   🙁  👻

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 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 & Smart View Extension - Cube Designer

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

Previous Cube Designer Extension -

New Cube Designer Extension -


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

Thursday, August 31, 2017

OAC - Cube Designer

### -> 106 -- 106 -- 106 <- ###   --  Smart View Cube Designer Extension

Yes, just a few days ago I blogged about 105 (Cube Designer Extension

and now ready to Update!

A few email exchanges and a few days later, here we are with another version AND with updates to features.

Let's take a look at a few of those additions

Outline Order - Outline Dimension Order

If you are building using the Cube Designer from scratch. When you click 'To Sheet' the Worksheets get created and the Outline Order is now auto populated, starting with the first dimension you typed into the Extension panel; Beginning with 1, 2, 3, etc.

If you have started by downloading/copying the cube workbook and deleted the number ordering, you can simply click on the 'To Sheet' button and the worksheet will get the Outline Order Numbering added directly into the worksheet "Essbase.Cube".

Application Properties section

Now added to the Cube Designer workbook is the ability to change the application level configuration settings (essbase.cfg settings). These at the moment are added manually and are required in a similar syntax/format as Substitution Variables; meaning Setting Name and Value in side-by-side cells.

via Cube Designer

via OAC Web (settings)

Text Lists

Generate Generations (Generation Names/Naming) for each Dimension

Happy to see the updates!!

Hope we see more updates, especially for the Hierarchy Tree View!

Sunday, August 27, 2017

OAC - Essbase version 17.3.3-926 Cell Information

This is the point in the weekend when I take a break and blog about how much fun I have been having. Going running. Or Walking. Okay, well maybe NOT. The Go No-Go decision will be coming up this week Friday, September 1st!! Think good thoughts everyone so that  >this guy< gets the green-light to start walking .. in the walking-boot!

But onto the other fun that I have been having this weekend. A little Cube Designer carry over from the last blog post as well as getting an Application:Cube built in OAC - Essbase! :)

I wanted to share a few fun items I found while building and validating data and OAC - Essbase features. Let's take a look.

First is the button for Member Information, take a look..

Wait, there is no more Member Information button! :)
It has now been transformed to a button called Cell Information!

With that, let's go ahead and click the button while our cursor is on a data cell.

Pretty nice. You can edit the solve order directly from Smart View. Press the Edit button on the lower left. Make the desired change to the solve order. Click OK.

Now let's take a look what happens when the cursor is on a dimension/member cell

Looks the same as it used to before, all of the member information for that dimension or member.
Information, Aliases, Attributes, Formula, UDA(s), etc.

If you are following the blog posts, maybe you are starting to see a trend or at least notice the cube that I am building .. it is a decent size cube (stats back to the first year in 1871) with the real data. And I am looking forward to more blog posts using this Essbase Cube in the Cloud with Data Visualization and BICS!

Hope to blog about those soon. Stay tuned.

Saturday, August 19, 2017

OAC - Cube Designer SV11.

YEAH! OAC - Essbase and the Cube Designer Ribbon and Extension

A new way to create and build Essbase cubes, is not just from Excel workbooks, but also with Smart View! :) This has been technically available and supported with recent versions going back in Smart View to version mentioned in a prior post

So let me get this out of the way. The naming/numbering conventions are making me a little insane

  • Software Release OAC 17.3.3-926 plus patch number
  • Smart View plus extension(s)
  • Cube Designer extension

why? Oh Why? JUST WHY?

Well, onto the geeky portion of the post that starts now. Hope you enjoy the little bit of fun I added while working on this post.

Let's get started.

Virtual machine .. Windows 10 64bit

Machine started in a matter of seconds

Note: I already had done the download and installation of the latest version of Smart View that recently came out in August-2017. Plus the Smart View Cube Designer Extension was previously installed and enabled

Time to launch Excel 2016 32bit. Done.

Let's verify the Version of Smart View

Beautiful. Let's take a look at the extensions.
Go to Smart View .. Options ..

Go to the Extensions tab on the bottom left

You may have more or less extensions, we are looking for and to make sure we have the 'Cube Designer' extension, which we do. Perfect.

The Cube Designer Ribbon

This post is going to focus on the Cube Designer and more posts to follow.

AND NOW .. for the main attraction. Cube Designer.

Make sure that you have an active Excel Workbook. Click the Cube Designer button to begin building an Essbase cube with the Wizard. Did someone say wizard?

Essbase Cloud Cube Designer. Slightly different name. Must be a version thing mentioned earlier ;)

And there you have it.

But we are not done just yet.

Why don't we continue to see what happens when we step through the extension window 'wizard' to build a cube.

Tabs across the top of the extension. Cube, Settings, Dimensions, Data, Calc

Add (enter) an 'Application Name'
Add (enter) a 'Cube Name'
Dimensions: where it says in italic-grey font 'Add Dimension' start typing your desired dimension name, hit enter/return and keep repeating until you have all your desired dimensions.

Pretty easy and straight forward so far.

Now at this point or really any point from now on you can click on the button 'To Sheet'

this little button starts the magic to begin or adds the magic once you have begun to build your cube in the workbook .. click it and see

Pretty slick so far.
And there are my wizards, I mean Dimensions to the worksheet named 'Essbase.Cube'

Next is 'Settings' or 'Cube.Settings'

As is, the Cube designer wizard builds a BSO cube as the default.
But that can be easily changed by manually typing ASO into the cell changing the Application Type manually or by simply unchecking the checkbox 'BSO (Block Storage Outline) and clicking our friend the button 'To Sheet'

Moving onto Dimensions. The Dimension names were added on the 'Cube' tab but the tab 'Dimensions' is now where the property types, build method and mode, generation information (used for Drill-Through), along with the fields that are desired for use in the build process

And don't forget about any UDAs that you might want to add, provide how many, or the Alias Table you want to use, check the checkbox

Next, time to add the magic potion .. I mean Data

Provide the name for your data. This is probably best to think of your data in datasets.
Actual. Budget. Forecast, etc. or in my example, Magic Potions

Onto the last tab in the wizard, Spells .. I mean Calc
Add any calcs as needed!

Now that you have stepped through the wizard. I want to look at 1 item quickly before this post is done. Dimensions. And specifically adding members and viewing them in a Hierarchy GUI TreeView fashion. Like EAS or for those still using AppMan (Application Manager and I know you are out there.. I have seen you for myself and nothing wrong if it still works..)

The Cube Designer on the ribbon has a button 'View Hierarchy'

For those that are familiar with cubes, multidimensional, non-relational (field-record-row) data. Maybe this is not entirely needed but a part of my cube builds it is nice to see from time to time what the resulting outline is going to look like..

So in the Dimension that I wanted to create, Harry_Potter I started to define what that hierarchy was going to be .. and added a few members manually.. take a look what happened when I clicked the 'View Hierarchy' button on the ribbon, I can see what the hierarchy looks like and even make edits from this GUI window, very nice!

I would like to add that it is nice to see the TreeView of the Hierarchy and the features that are there in this version. In future versions of the Cube designer, it would be nice most if not all of the dimension/member property information. Including the child/descendant count, Generation # & Level #, Member Formula(s),  the UDA(s), just to name a few.

So that is the OAC - Essbase Cube Designer Wizard in a nutshell .. look, this is me in a nutshell (Austin Powers) 😀

More blogging soon on the creation of the cube in OAC.
And then onto DV (Data Visualization) and maybe a little bit BICS!!!

p.s. Yes, I was in a car accident. Head on collision. Only me in my car. Only her in her car. As told to me on the accident site and also states in the police report. She was tired and fell asleep at the wheel. YIKES!! A LITTLE COMMON SENSE PEOPLE.. as a result >this guy< got a Broken Right Foot. Had Surgery 1-week later. Dr. says x-rays looked good 2-weeks after surgery. Surgery cast off, stitches out. Walking boot, YEAH.. but a big boo since i am still non-weight-bearing :( at least until my next doctor visit on September 1st.. wow, that still feels like a long ways away .. 

but I guess that just means more time on the nights and weekends to research on fun EPM and BI things going on, catch up on other fun things at work and oh what the hay.. download the free trial of the HBO NOW app on my iPad and start, yes start, watching Game of Thrones #GOT.. Season 1 done. Season 2 done. And just started on Season 3! Don't spoil it for me .. I do want to catch up to this season :)