One of the features of Dodeca is read-write functionality to SQL databases. We often get questions as to how to write data back to a relational database, so I thought I would post a quick blog entry for our customers to reference.
This example will use a simple table structure in SQL Server though the concepts are the same when using Oracle, DB2, and most other relational databases. The example will use a simple Dodeca (more...)
We recently released an updated version of the Next Generation Outline Extractor. This new version, 22.214.171.1247, addresses three issues:
- Fixed an issue where the username and password passed via the command line were improperly logged
- Fixed an issue reading MaxL XML data sources when the alias or UDA contained xml encoded characters such as the ampersand (&) character.
- Updated labels on the Input Source tab of the user interface to clarify their (more...)
Have you ever wanted your users to see an Essbase database outline structure, but had trouble giving them access to Essbase Administrative Services ("EAS") for fear that they may have access to change things they shouldn't change? Maybe you didn't want to give them EAS and have to deal with the version of Java installed on their machine? We have the solution to your problems. After a bit of fits and starts, we have finally (more...)
Today we released a new version of the Next Generation Outline Extractor, version 126.96.36.1999. Here are the release notes from this new version:
Version 188.8.131.529 supports the following Essbase versions:
The issue that has plagued a number of Essbase customers over the years related to running out of available ports has finally been fixed!
This issue, which often manifested itself with errors in the Essbase error 10420xx range, was caused by how the Essbase Java API communicated with the server. In essence, whenever a piece of information was needed, the Essbase Java API grabbed a port from the pool of available ports, did its business, (more...)
It is with a sad heart that bring you the news that, as of Essbase 184.108.40.206, the Essbase VB API is officially dead. I cut my teeth in Essbase working with that API way back in the mid-1990's, but the writing had been on the wall for some time. Microsoft stopped supporting VB years ago, so it was only a matter of time before this time would come. That being said, I (more...)
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...)
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 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...)
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...)
Last week, we released Dodeca version 220.127.116.1140 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...)
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.
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...)
This past Friday, November 22nd, we completed our work on the newest version of the Dodeca Spreadsheet Management System and made Dodeca 18.104.22.16894 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...)
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...)
If you are in or near Seattle on Friday, November 8th, don't miss the opportunity to see the new features of the Hyperion 22.214.171.124 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...)
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...)
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:
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...)
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...)