Tuesday, April 17, 2012

Dodeca and the Outline Extractor Now Supported on Essbase 11.1.2.2

Today, we have made the Dodeca-Essbase server for Essbase 11.1.2.2 available to licensed customers.  Support for this version of Essbase comes just 6 days after Oracle made the 11.1.2.2 release and shows our dedication to support for Oracle Essbase.  In addition, the ability to support this new release so quickly validates the superior architecture of Dodeca.  With this release, Dodeca supports every version of Essbase between 6.5.3 and 11.1.2.2 and features the unique ability to query data from any supported Essbase version into a single Dodeca report.  This ability, along with Essbase retrieval performance often exceeding 100,000 cells per second, shows Dodeca is the fastest and most agile Essbase product on the market.

In addition, we also posted an 11.1.2.2 version of the OlapUnderground Outline Extractor to the download site at  http://www.appliedolap.com/resources/downloads. 

Thursday, April 12, 2012

My Top 10 List of Reasons to Upgrade to the New Smart View 11.1.2.1.102


Recently, I did a presentation on the new Smart View 11.1.2.1.102 at the ODTUG Hyperion SIG event in Dallas.  In the presentation, I listed all of the technical innovations that brought this version of Smart View closer to the functionality of the classic Excel add-in for Essbase.  I also spent some time talking about the remaining differences between Smart View and the classic Excel add-in.  It was during this part of the presentation that I was asked a question I was completely unprepared for.  Someone asked me, “Why should we upgrade to Smart View over the classic add-in?”

At that moment, my mind went blank.  Maybe it was due to lack of sleep or maybe it was due to the fact that when I look at the new feature list, I feel the reasons to upgrade are pretty self-apparent.  Since that presentation however, I have stepped back and tried to look at it from more of a user's perspective.  In doing that, I came up with this list of reasons to upgrade.  Of course, some of the reasons are more compelling than others, so I decided to rank them based on what I would want as a user.

10. Smart View has integration with other Oracle products; the classic add-in does not.  Okay, if you exclusively use Essbase, this argument may not help convince you to move to the new Smart View.  If, however, you use any of the other products, this can help you get a better return on your investment in Oracle technology.

9. Smart View has integration with other Microsoft Office technologies; the classic add-in does not.  This can save you time if you have a recurring need to bring Essbase data into Microsoft Word or Microsoft Powerpoint.

8. Smart View allows you to setup favorite private connections that make it much easier, and faster, to connect to your favorite cubes.

7.

Smart View has new options for formula and format fill that leverages Excel formatting in ways not available in the classic Excel add-in. These options automatically apply Excel formatting from the Zoom-In operation source cells. Here is a simple example. In this grid, you can see that the cell containing the member name Cola has been formatted with a background color.

After a Zoom-In operation, the children of Colas also get the same formatting. This could be a very useful functionality for some users as they explore data in Essbase.

6. Smart View has a number of VBA functions which were not available in the classic Excel add-in. These VBA functions help customers who are would like to do lightweight automation tasks with Essbase. Of course, in the classic Excel add-in, you could revert to the Essbase API to do some of these tasks, but that added its own level of maintenance and deployment problems. Further, many customers have tried to use Excel as a development platform to build robust Essbase applications. Excel is a very good end user tool, but it is not a very good platform for building robust applications. Instead, if you need a robust Essbase development platform, save yourself a lot of time, effort, and pain and by checking out Dodeca. (Disclosure: I am the founder of, and lead the development team for, the company that publishes Dodeca.)

5. Multiple range operations are easy to use in Smart View; they are not easy to use in the classic Excel add-in.  This gives companies much more flexibility in designing their templates without the need for VBA coding.  The multiple range operation functionality embeds information about the different cubes within the workbook so that it can be refreshed without the need for the user to manually select a given range and connect to different cubes.  This makes these operations faster, more dependable, and much less susceptible to user error in Smart View than in the classic Excel add-in.

4. When you perform a cascade in Smart View, the Excel sheet tabs are appropriately named.  Cascade functionality is a very powerful feature of multidimensional databases, but it was severely limited by way it was implemented in the classic Excel add-in.  In the classic add-in, users had the choice of splitting the cascade into different worksheets or workbooks, but the worksheets, or workbooks, were named using a numbering system.  Users had to look at an optional tab of contents to determine which worksheet contained data for a specific member.  In the new version, the sheet names are based on the sheet member in the cascade.

3.

The ability to query more than 65,535 rows of data gives users the ability to see more data if necessary.  You may say to yourself, “Why would anybody need to see this much data?”  With today’s larger and larger datasets, it is easily possible for a ‘Next Level’ zoom to exceed the row limit enforced in the classic add-in.  Further, the classic add-in does not display the first 65,535 rows, but rather it puts up an error messages and prevents users from seeing those rows.  Here is a screenshot showing a large retrieve where I did a zoom-in to all levels of the largest 4 dimensions of Sample Basic.


Of course, if you try the same thing in the classic Excel add-in, you don't even get that far as you very quickly get an error message telling you that you have exceeded the maximum retrieval size.


2. Smart View users can have multiple instances of Excel open at once.  This may not seem like a big deal, but those of us who live and die in Excel feel very constrained if we have to be careful not to launch a second Excel instance.  What's the big deal, you ask?  The big deal is that the classic Excel add-in cannot do this.  Once you open a second instance of Excel, the add-in becomes very undependable as it can lose track of its connected worksheets.  I posted a 15 second video on my blog a couple of years ago that shows just how easy it is for multiple Excel instances to get mixed up.  Check out the video at http://timtows-hyperion-blog.blogspot.com/2009/09/fun-with-excel.html.

1. Smart View is the strategic direction for Oracle; the classic add-in will start to sunset in the next 4 to 5 years.   This isn’t something you can wait out hoping the issue will go away.  The classic add-in will be done.

When Oracle first started working on these improvements, they asked my opinion of their proposals.  I told them that, if they implemented the proposed changes, then Smart View would be good enough that people could use it to author Dodeca templates.  I am glad they have finally hit that milestone with the new Smart View 11.1.2.1.102.

Thursday, April 5, 2012

MTG Recorded Webcasts

My friend Ron Moore over at Marketing Technologies Group send me a link to the recorded webcasts they have on their site and asked that I get the word out about their presence.  Ron and I go back many years and, in fact, I used to teach Essbase Excel VBA classes for him at his training room in New York.  Ron is also a great sponsor of the ODTUG Hyperion user group activities and these videos are a great contribution to the community.

Here is what the recorded library looks like.

There are currently 38 webcast videos in the library on a variety of topics.  You can see the webcast library at https://mtg.webex.com/mw0306ld/mywebex/default.do?siteurl=mtg.  This link takes you to the webcast schedule.  From there, click on the View Event Recordings link in the upper right corner to access the archived videos.




Saturday, March 31, 2012

New Dodeca Whitepaper En Francais!

Our partners at Limpida in Paris have recently published a whitepaper on Dodeca in French!  We recently hosted two Limpida consultants in our office here in Huntsville.  During their week in Huntsville, we had the opportunity to give them some in-depth training on Dodeca so they can provide quality implementation services back home in France.

I also used their visit to work on my French, the but progress is very slow (ou trop lent pour ceux d'entre vous en France), so I haven't translated the whitepaper.  I trust is says good things about Dodeca!


Tuesday, March 20, 2012

Kscope 12 Early Bird Deadline is Almost Here

If you are planning to attend Kscope 12 in San Antonio and you have not yet registered, be sure to register this week as Early Bird discounts end next Monday and the price goes up $150 $300. Better yet, register this week and use the Applied OLAP discount code, AOLAP, and you will save another $100.

Kscope features the world's most intensive learning opportunities for Essbase, Hyperion Planning, Hyperion Financial Management, Oracle Application Express (APEX) and Oracle Fusion Middleware.  Register today and I will see you there!

Tuesday, March 6, 2012

Smart View 11.1.2.1.102 Performance Tip

A couple of weeks ago, I was preparing to speak on the new Smart View 11.1.2.1.102 at the ODTUG Hyperion SIG Dallas meeting and found a performance issue when trying to zoom in on large datasets.  Here is the sheet I was zooming:





I used Sample Basic and zoomed in to all levels on Year, Measures, and Product.  When I zoomed in on Market, Smart View never returned but rather just kept trying to zoom in for a while.  After working on it for a bit, I decided to try the same thing in the classic Excel add-in and, guess what?  The same sequence of operations is not even possible there as it easily shoots past the 65,535 rows supported by the classic add-in.   I tried it in Dodeca and it returned a bit over 172,000 rows in 5 seconds, so it certainly isn't an issue with the Essbase server and large retrieves.

I next talked to one of my friends inside Oracle and found the source of the performance issue.  If you have used the classic Excel add-in, you may remember seeing the Use Styles option which formats the cells returned by Essbase based on member cell or data cell attributes.  Based on my VBA experience, I can tell you that doing lots of format operations in an Excel worksheet can be quite slow.  In Smart View 11.1.2.1.102, there is a new option called Use Excel Formatting which also defaults to false.  This setting is conceptually the opposite of Use Styles in the classic add-in.  In other words, Smart View 11.1.2.1.102, along with all previous versions of Smart View, automatically formats the cells that are returned.  In fact, you can see the formatting in the screenshot above.

To prevent this automatic formatting and speed up your retrievals, set the Use Excel Formatting option to true.




Once I made this change, the zoom in operation on Market did complete and brought back more than 172,000 rows.

Another thing you may note from the spreadsheet is that member labels are repeated.  This is another difference between the classic add-in and Smart View.  The Repeat Member Labels option has been renamed Suppress Repeated Members and the default behavior has changed.  With Smart View, you must select the option to Suppress Repeated Members to see the same behavior you saw by default in the classic add-in.  Frankly, I don't remember if this is something new in Smart View 11.1.2.1.102, but just be aware of it.  In the screenshot below, I have set the Suppress Repeated Members setting to mimic the classic add-in.



Tuesday, February 28, 2012

APS 11.1.2.2 New Feature: Essbase Web Services

APS 11.1.2.2 appears to have a significant new feature, Essbase Web Services.  Here is an excerpt from the readme file posted on the Oracle website:

Essbase Web Services

Web services are self-contained, modular applications that one can describe, publish, locate, and invoke over a network. Web services allow access to regular applications using a Web browser. Web services use XML to code and decode data, and SOAP (Simple Object Access Protocol) to transport it.
Essbase Web Services will expose Essbase user and administrative functionality in a services-oriented (SOA) environment via Provider Services, and allow Essbase to be easily integrated with both Oracle and third-party applications.

The APS Admin Guide also posted at the Oracle site has information on the Essbase Web Services and what you can do with them.  It appears you can query data and metadata along with performing some admin tasks.  One thing that looks useful immediately is the ability to execute a Maxl statement via a web service.  This would eliminate the need to install the Essbase client just to run Maxl statements; I have one customer who could benefit greatly from this functionality today.

Hopefully I will get a chance to play with these soon and post some sample code.  On the other hand, ten years ago I wrote web services to retrieve Essbase grid data into Dodeca and they are *very* fast, so I don't see myself working very hard on those particular APIs.

Oracle AI World 26

I've been attending Oracle conferences for many years, and one of the things I enjoy most is the opportunity to reconnect with longtime ...