ODTUG Technical Journal – Searchable Content, Raise Your T!

For those who have not visited the ODTUG Technical Journal Corner lately, it’s time you start

The ODTUG website in general contains material from all our past conferences, plus years of excellent material from our expert columnists in Business Intelligence, PL/SQL, Oracle Tools, Fusion MIddleware, Hyperion, Essbase and more.  We have articles and updates from your favorite authors, such as Lucas Jellema on Fusion Middleware, Steven Feuerstein on (you guessed it) PL/SQL, , Mark Rittman on Business Intelligence,  and Tim Tow, Edward Roske and Tracy McMullen on Hyperion/Essbase topics.

Check out our two newest articles:

EPMA Tips and Tricks by Daniel Villani, Peloton

Is the classic method of building Essbase, Planning, HFM, and HPCM applications becoming too cumbersome? Are you tired of building hierarchies through flat files? Often, the process of loading dimensions and hierarchies to Planning and Essbase can be a time-consuming process and a maintenance nightmare! Enterprise Performance Management Architect (EPMA) is the leading tool, provided as part of the Oracle EPM Suite and designed to ease the burden of managing data and metadata for various application types between multiple Essbase, Planning, HFM, and HPCM Applications with common dimensionality.

Five Guiding Principles for Hyperion Code Standards and Documentation
by Sarah Zumbrum, Finit Solutions

In my decade-long quest to become a better Hyperion code writer, I have seen (and learned) some interesting things. I have seen some beautifully written code, some that I wondered how it worked, some so mangled I thought it would crash and burn if I dared put a space in the line, and some that technically worked but wasn’t efficient. What I have taken away from these experiences is that there should be standard set of code and documenting code so we don’t have to collectively wonder what a set of code is doing.

Watch the ODTUG Technical Journal Corner for upcoming posting of our 2014 Editor’s Choice Award winning article on NoSQL by Iggy Fernandez.

Never ever suffer from Low T – stop by ODTUG.com and the Technical Journal Corner for a quick T-fix.  For a bigger T boost, submit your article (or article ideas) to the ODTUG Technical Journal Corner – email kcannell@odtug.com for more info.

KScope 14 Wrap-up – APEX 5 Highlights


I am just back from KScope14 in Seattle, WA – what a week. No “Low-T” here!

APEX 5.0 Early Adopter 2 was featured on Sunday by the Oracle APEX team, after which I was able to complete prep for my APEX Interactive Reports, The Good, The Bad and The Ugly, Revisited.  I demoed APEX 5 IR new features, including multiple IRs on a single page with links between those reports – we now have a simple way to quickly generate dashboard-like layouts.  The big news with IRs in APEX 5 is Change – there is a new scheme of classes and Id’s for the IR elements – the old apexir_* set are gone.  There is completely new jQuery widget that controls IRs – sooooo… any custom code – dynamic actions, plugins, javascript, whatever – that does not use the standard API’s will need to be refactored.  I’ll be posting more in APEX 5 Interactive Reports in the coming week.

There were many highlights – APEX 5, great sessions, an awesome party at EMP, great people.  A standout for me was seeing Mike Riley there, smiling, and receive the ODTUG Volunteer of the Year Award – Congratulations Mike!  To read more about Mike Riley, and his journey in life and with ODTUG, see the ODTUG Technical Journal Corner.Volunteer Spotlight by John King.

While there check out two articles on SQL Developer – one by Jeff Smith, on making your job easier with SQL Developer, and one from Galo Balda, Using SQL Developer to Work With GitHub.  Great stuff, by two great people.


ODTUG – Calling All Media for Kscope Submissions

As Editor of the Oracle Developer Tools User Group (ODTUG) Technical Journal, I am privileged to read and review all conference materials submitted for the ODTUG Editor’s Choice Award. This is a task I look forward to each year – since 2007 or 8 when I first volunteered for the ODTUG Technical Journal.  This year should be interesting …

The popularity of blogs, videos, and podcasts attests to the fact that today’s developers are gathering information in a wide variety of media. Our members are consuming more information online and in alternate formats, as opposed to formal white papers and other printed media. Some have said the white paper is dead; others say they just don’t have time to read one, let alone write one.

ODTUG’s aim is to deliver quality, timely technical content to our members in the most convenient online formats possible – and we want to keep that momentum going. Over a year ago, our Technical Journal transitioned to an entirely online format. Accordingly, it’s time to make the next transition, with our Kscope conference materials.

In the past, we asked Kscope speakers to submit both their presentation slides and a white paper that covered their presentation topic. Starting in 2014, we invite our Kscope conference presenters to submit their conference materials in the following media types: video, audio file, blog post, and white paper. Entries should convey a complete technical topic.

All conference materials are eventually available to our members. The purpose of this expansion is two-fold. Accepting speaker presentation submissions in the aforementioned reusable media types:

  • Increases the volume and type of technical material available to our members
  • Expands the ODTUG Editor’s Choice Award to acknowledge creative, effective use of all modern media options to convey a complete technical topic, not just white papers

Our Editor’s Choice Award honors excellence in conveying a complete technical topic to our members. Expanding the media type of Editor’s Choice submissions simply means we have a wider variety of submissions to judge. The Editor’s Choice Award winner is decided by a team of ODTUG experts who review all of the conference submissions and grade them according to a variety of scoring criteria that cover these general topics:

  • Communication Quality – assesses communication style (written or verbal), overall organization of the media, and grammar
  • Applicability – evaluates subject matter importance, completeness, effectiveness, and accuracy
  • Topic Merit – acknowledges the exceptional and innovative, treatment of a cutting-edge topic, technical complexity, or a new and unique approach to a common problem

There are two new scoring points related to media type – one for media format in the Communication Quality category, and one for effective use of media in the Applicability category. The recommended media type score values submission types in this order: video, white paper, audio file, blog post; however, each submission will be evaluated on its own merit. Effective use of the media in conveying the message is more important.

Remember that these new media-related scores are just two of over 150 possible points, so our advice is to not get too hung up on media format. The content and the message are the stars.

Most important for the Editor’s Choice Award is overall excellence in technical communication of complete technical topic for our ODTUG members. As such, grammar, organization, proper formatting (for the media type), clarity, examples appropriate for the content, and how well the message is conveyed all matter.

By the way – no tweets allowed! Our ODTUG members are smart and eager to learn; they are hungry for more than a tweet. As a technical editor, I believe our members deserve more than 140 characters.

We are also accepting nominations for our Editor’s Choice Review Team. This dedicated team of volunteers reviews each conference submission according to published scoring criteria. The scores are weighted and averaged to arrive at an overall winner. Our review team is comprised of a cross-section of our members – no one developer tool or technical topic is overly weighted or favored. We are always looking for new Editor’s Choice Team members. To join us, or to nominate someone else, please contact me at kcannell@odtug.com, or use the contact form below.  Reviewing conference submissions  is an easy way to volunteer for ODTUG and get a preconference view of all Kscope conference material. It’s like a conference before the conference.

So, Kscope presenters – wow us with your stuff!  Impress us!  The door is open – show us what you know, in your favorite media. I thank you in advance, from all our ODTUG members.

As always, happy coding,







RMOUG  – Rocky Mountain Oracle User Group – 2013 is around the corner – check out the RMOUG 2013 Training Days for more information. I’ll be presenting on Tabular Form Terrors and How to Overcome Them – updated APEX tabular form information, with guidance on how to build some of those out-of-the-sandbox features that are not readily built by existing wizards and dynamic actions. See you there!

APEX Data Load Options – How Do I Load Data …

How to Load MS Excel Data into APEX?

The most common APEX data load problem….how to load MS Excel files as XLS, not as CSV.

There are as many ways to load data into an Oracle database as … well, there are a lot of them.  When building an Oracle Application Express application, there are some data load options that are more suitable than others.  This presentation outlines the standard APEX-supplied data load options, explores the APEX Data Load wizard, and discuss how to integrate some more traditional Oracle data load options into your APEX applications.  This is by no means an inclusive view of all the possibilities, but some of these options will give you ideas on how best to approach your data load issues.

Download the presentation here:  APEX Data Loading Options

RMOUG 2012 Coming Up Feb 14-16,2012


I will be speaking at RMOUG – the Rocky Mountain Oracle User Group annual Training Days February 14-16, 2012 in Denver CO.  This is a great conference – tons of learning packed into two full days.  Followed by a few of skiing, for those so inclined.

How to Load Data – Let me Count the Ways – This presentation reviews various data loading options for Oracle Application Express (APEX) applications, including the new Data Load wizard/component and the APEX Listener XLS upload. How hard, or easy, is it to use various data load options? Which works best for which incoming data types? You’ll learn the pros and cons of each, enough to make intelligent decisions for your data loading needs.

See the RMOUG website for more information on RMOUG Training Days 2012.

See you there!