File Encoding in the Next Generation Outline Extractor

We had a couple of issues reported with the output of the Next Generation Outline Extractor where the exported file did not work properly as a load file. After some investigation, we found that the file encoding was incorrect. We were encoding the files using the Unicode/UTF-8 format. We chose this encoding so that we could write all characters in all languages, but we did not consider that UTF-8 is only valid for loading Unicode (more...)

Are you ready for Windows 10? Dodeca Is Ready!

Microsoft recently released it first preview version of their next desktop operating system, Windows 10. In our business, we have seen many large companies just migrate to Windows 7 and the general consensus seems to be that Windows 8 is a 'consumer' operating system. In other words, it will be a while before you have to think about Windows 10, but it is our business to be thinking about this now. We have the Windows (more...)

Kscope15 Abstract deadline is Wednesday, October 15!

Kscope15 abstract submission will close in just a few days and the ODTUG content teams want you!

I am sure there are many of you who have never done a presentation at a conference and may not feel comfortable speaking in public. Well, I have a secret for you, despite the fact that I won the Best Speaker Award at Kscope14, I share your discomfort with speaking. What works for me, however, is that I (more...)

Next Generation Outline Extractor Webcast – Oct 8th!

I am doing a repeat of my Kscope15 'Best Speaker' award-winning presentation as part of the ODTUG webcast series. Here is the official announcement from ODTUG:

Wednesday, October 8, 2014 12:00 PM - 1:00 PM EDT

Next Generation Essbase Outline Extractor Tips and Tricks
Tim Tow, Applied OLAP

The Next Generation Outline Extractor is the follow-up to the classic OlapUnderground Essbase Outline Extractor used by thousands of Essbase customers. This session, which was the highest-rated (more...)

What’s New in Dodeca 6.7.1?

Last week, we released Dodeca version 6.7.1.4340 which focuses on some new relational functionality. The major new features in 6.7.1 are:
  • Concurrent SQL Query Execution
  • Detailed SQL Timed Logging
  • Query and Display PDF format
  • Ability to Launch Local External Processes from Within Dodeca

Concurrent SQL Query Execution

Dodeca has a built-in SQLPassthroughDataSet object that supports queries to a relational database.  The SQLPassthroughDataSet functionality was engineered such that a SQLPassthroughDataSet object (more...)

Meet the Oracle ACE Directors Panel – January 9 – Seattle


I will be in Seattle on Thursday, January 9th for the Meet the Oracle ACE Directors Panel.  It is at the Sheraton Seattle from 4 - 6 pm and will feature several other ACE Directors including Martin D'Souza, Kellyn Pot'Vin, Tim Gorman, and my longtime friend and collaborator, Cameron Lackpour.  

Smart View Internals: Exploring the Plumbing of Smart View

Ever wonder how Smart View stores the information it needs inside an Excel file?  I thought I would take a look to see what I could learn.  First, I created this simple multi-grid retrieve in Smart View.



Note that the file was saved in the Excel 2007 and higher format (more...)

Dodeca 6.6.0.4194 Now Available for Download!

This past Friday, November 22nd, we completed our work on the newest version of the Dodeca Spreadsheet Management System and made Dodeca 6.6.0.4194 available for download from our website.  This blog entry is a sneak peek at some of the new features in version 6.6, as (more...)

Save $250 on Kscope14 Registration Now!

If you work in the Essbase, Oracle EPM, or Oracle BI world, *the* place to be every June is the annual Kscope conference.  Registration is open for the next conference, Kscope14, coming next June in Seattle, WA.  If you are not currently a full ODTUG member, let me tell you (more...)

Hyperion 11.1.2.3 Update – Kscope14 Street Team Meetup in Seattle – November 8th

If you are in or near Seattle on Friday, November 8th, don't miss the opportunity to see the new features of the Hyperion 11.1.2.3 release.  Oracle representatives are teaming together with the Kscope14 Street Team to bring you this 2-hour mini-session at the Fred Hutchison Cancer Research (more...)

The New AppliedOLAP.com / Free Tools Access

My team has been hard at work getting our new website out the door, and we feel that it will make for a better experience all-around for our users and the users of the free OLAPUnderground utilities.  To help make the experience better, we have implemented a new download process. (more...)

Oracle Open World 2013 General Session: Empowering Modern Enterprise Performance Management

Here at Oracle Open World 2013, I attended the general session entitled "Empowering Modern Enterprise Performance Management" which was led by Balaji Yelamanchili, Oracle Senior Vice President for Analytics and Performance Management Products.  His keynote focused on the development priorities within the Oracle EPM group.  Those priorities are:

Essbase Meetup in San Francisco This Tuesday!

As you may or may not know, this week is the annual mega-conference Oracle Open World and, in conjunction with the conference, I am hosting, with fellow Oracle ACE Director Cameron Lackpour, an Essbase Meetup this Tuesday evening in San Francisco.  Unlike most events during the week of Open World, (more...)

Kscope13 Top Speaker Award

I thought I would post a quick picture of the award I earned at Kscope13 as one of the Top 5 Speakers at Kscope13 for my presentation entitled "Introducing the Outline Extractor NG (Next Generation)".   The Next Generation Outline Extractor is a complete rewrite of the popular Outline Extractor. (more...)

Find Your Brilliance

I’d like to interrupt our regularly scheduled programming to tell you about one my personal highlight's of Kscope 13 which was held back in June in New Orleans. Every year ODTUG announces who the keynote speaker will be well in advance of the conference. Most of the time, the speaker (more...)

Next Generation Essbase Outline Extractor Released!

After a bunch of work, we have finally released the Next Generation Essbase Outline Extractor. So, what is the Next Generation Essbase Outline Extractor?  Well, the original outline extractor was written in Visual Basic and Visual Basic has has not been supported by Microsoft for a number of years.  In (more...)

EPM 11.1.2.3 Available for Download

Oracle Enterprise Performance Management 11.1.2.3 became available over the weekend, so let the rush of upgrading begin!

Here at Applied OLAP, we have already started our work with Essbase 11.1.2.3.  We have added the new version to our build list and have started testing (more...)

Oracle Excellence Awards 2013 – Nominations Open

One of my friends at Oracle asked me to help get the word out about the Oracle Excellence Awards for Oracle Fusion Middleware Innovation. These awards recognize customers for their cutting-edge solutions using Oracle Fusion Middleware and are featured in Oracle publications, videos and case studies. If you think you (more...)

Dodeca Dashboard Screenshot

One of our customers recently sent us a screenshot of a dashboard they developed in Dodeca. This application, which is deployed to over 1,000 Essbase users worldwide, allows users to easily analyze over 250,000 SKU-level products by customer and by business unit. The application, which was implemented to replace a (more...)

Happy Birthday Applied OLAP

Last Monday, we reached a milestone at Applied OLAP as it was the 15th anniversary of our incorporation.  I founded Applied OLAP on March 18, 1998, because I was not satisfied with the status quo of Essbase reporting at the time which was, of course, the classic Excel add-in.  And, (more...)