Why I created a blog

Its been many years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.

Thursday, June 29, 2017

Smart View and Office 2016

I'm just returning from KScope 17 and while sitting in the airport, decided to talk about something I was asked multiple times during the week. There are multiple instances where people have issues with Smart View and Office 16 (or 13 or 10). while I am no expert in this, Oracle has a number of  white papers and tips and tricks for improving performance. I take no credit for them but list them below to hopefully help you out. As a note, The Smart View team really is interested in issues you have so if you run into something, submit an SR or enhancement request (If you are stuck, respond to this post and I'll try to help you navigate Oracle to get your issue resolved, no promises on results)

Flickering issues

How to disable Toobar transitions in 2013 and 2016:


Disable Animations:


Memory and Performance


Http Session Timeout:


If these issues do help, please post as well to let others know of your success.

Wednesday, June 7, 2017

Using Cube Designer with OAC to convert to Hybrid

Recently on OTN (or was it network 54) someone asked about changing all of parents to be dynamic for a Hybrid cube in Essbase.  There were a number of suggestions from getting utilities to downloading the Next generation Outline extractor from Applied OLAP, to using Excel.  All good suggestions, But if you are using Essbase in OAC, there is even an easier way, wait for it - Cube Designer.

Huh? Cube designer is the Smart View extension for OAC that lets you build your outline in excel and uploads it to the cloud. It is pretty slick. One of the items they figured is people will want to convert cubes to the Advanced Analytic Engine (a fancy term for Hybrid).  So they added an Easy button. 

First you have to have imported your cube into the DBX format.(I’m guessing DBX stands for Database extract, but it could mean anything).  This can be done a few ways:

1.       If the cube is already in the OAC instance, in Cube Designer, select private->Export cube to application workbook


2.       If it is not in OAC, then get your hands on the DBXtool utility (ask a cloud friend for it). With it you can export your on-prem cubes into excel (and who wouldn’t want to do that)

Once you have it in Excel, go to the dimension you want to change. In my example it is Customer. For this example it is a nice small dimension

Next click on View Hierarchy


The hierarchy will appear in a dialog box. Expand “Edit Parents” and select “Set Storage to dynamic”

Click refresh and all of the parents in your worksheet are changed to dynamic. Close the editor


I know what you are saying. Glenn it was only two members. Yes in this case it was, but in most instances it will be hundreds of members scattered throughout the hierarchy. This will handle them all at once and it is super-fast.

After that you can use the Build cube icon to update your existing OAC cube or build a new one.  What could be easier than that?  (well at least for OAC).

Look for more of these little tidbits about Cube Designer and OAC in general in future posts