APEX 5 IR Guts and Performance

APEX 5 Interactive Reports (IR) are powerful out of the box, but one can significantly improve performance by strategic settings of certain key parameters.  The full presentation covers all the options.

When your data volumes are low to medium, there may not be much noticeable difference. But when data volumes are high, or the query is resource intensive, the following advice and settings can have a significant performance impact.

In brief:

  • Tune your query, then fine-tune your SQL query. Any slowness here will be magnified in APEX
  • Check MAXROWCOUNT.   The more rows, the longer it takes APEX to retrieve them.  do users really need ALL the rows? OR is it reasonable to ask users to filter first. (APEX 5.1 Interactive Grid will include features to FORCE users to filter first – nice!) Consider  supplying users who need to Download All a separate pag,e os not all users are handicapped by a high MAXROWCOUNT value.
  • Check Max Rows Per Page
  • Check your Pagination setting.  The X to Y of Z is popular, but the “of Z” part is expensive – APEX needs to retrieve all rows then set up pagination. That All Rows part takes time.  Consider using X to Y, and adding a page item that calculates the Z separately. (THere are various options to do this, a topic for another blog post, ranging from a straight COUNT(*) to a sophistcated use of APEX_IR to get the count of the as-filtered IR query)

These are your big-impact settings.

For more info, see the full presentation via the link below or Slideshare:

As you move to APEX 5 Interactive Grid, these three settings till apply – but you have better pagination options, and pagination works differently – heck, all of Interactive Grid works differently – better!  So watch here for upcoming information on Interactive Grid.

APEX5 IR Guts and Performance

Smart use of the IR settings makes for a better end user experience ~ and that’s the whole point!

Announcing the ODTUG Innovation Award

What Oracle development project in the past year made you say WOW!

What project, collaborative or individual, demonstrates exceptionally innovative and creative use of Oracle technology?

What stands out as an above-and-beyond example of Oracle technology applied to real world problems? 

To honor such creativity and innovation, ODTUG announces a more modern mode of honoring excellence within ODTUG’s supported communities (ADF, APEX, BI, Database, and EPM), the ODTUG Innovation Award.

The ODTUG Innovation Award honors excellence in creative, effective, innovative use of Oracle development tools. The goal is to honor developers – individuals or teams – whose passion and creativity shines through in their application of Oracle technology to address real world problems in our ODTUG communities.

communites

We are looking for innovative, exceptional ahead-of-the-curve applications of Oracle development tools that stand out as examples of “the next big thing” in Oracle technology, or as unusually creative applications of new and emerging Oracle tools in our ODTUG communities.

To make a nomination for the award, you must be an ODTUG member (Associate or Full). If you are not a member, join ODTUG now.

Who/What is Eligible:

  • Nominees may be individuals or teams that are non-Oracle employees.
  • Nominees need not be ODTUG members, but they must work with a tool that supports at least one of our communities (ADF, APEX, BI, Database, and EPM).
  • Open Source and / or collaborate efforts are eligible.

Nominations:

  • Nominations Open: Now!
  • Nominations Close: May 31st

More information:

What we are looking for are the things that make us go Wow! when we first see them.  Here are a few historical examples:

  • Integration of Oracle Forms and Java ADF (years ago)
  • HTMLDB, when it first came out – and the first practical applications of HTMLDB (years ago)
  • Oracle-based applications on an iPhone
  • Oracle applications of Google Glasses
  • Our first look at Node.js integrated with (extending) an APEX application. (a few years back)
  • Peter Koletzke and Paul Dorsey’s work deciphering and promoting JDeveloper when it first launched

We know sure there are examples from every Oracle technology community. ~ let us know about them!

Judging:

The 2016 ODTUG Innovation Award winner will be decided by a team of ODTUG experts who will review all of the nominations and discuss and rate them according to these general topics:

Innovation – The Wow factor: Acknowledges the exceptional and innovative
Quality – Not only does it have to be Wow, it has to work.
Applicability – Evaluates subject matter importance, completeness, effectiveness, and accuracy
Topic Merit – Treatment of a cutting-edge topic, technical complexity, or a new and unique approach to a common problem.

For this first year, the  ODTUG Innovation Award will be awarded decided by a select panel of experts from across all ODTUG communities. In future years, nominations will be open all year long, and all ODTUG members will be able to vote for their favorite.

Watch for more information on the  ODTUG Innovation Award on all the usual channels: ODTUG emails, Twitter, the ODTUG website,

Our ODTUG Innovation Award honors innovation, excellence and amazing accomplishment in the realm of Oracle Development Tools adoption and integration.   The possibilities are endless ~ What makes you, as a developer, say Wow! ~ Nominate your favorite examples now!

 

ODTUG Board of Directors Election ~ Vote!

Vote for the ODTUG Board

The ODTUG Board of Directors election is underway now.  ODTUG memebers, this is your chance to choose 5 new board members for the 2016-2017 term.

Again this year there is a stellar selection of candidates.

Why do I run?  I have served ODTUG in many capacities behinds the scenes and as Editor of the Technical Journal, and want to :

  • Bring more quality learning material in all formats, online and offlne, to all Oracle developers:
    • more online material in more formats, and
    • more meetups to bring the message local.
  • Encourage women in technical fields:
    • to strive for higher positions in those careers, and
    • to have greater confidence in what they bring to the table technically and personally.
  • Strengthen the ODTUG Communities so that material and answers from ODTUG experts shows up in every search. We cannot keep our knowledge behind (fire)walls!

ODTUG should be the Oracle Developer go-to resource for learning, online and locally.  As a board member I will work to increase ODTUG’s online presence and increase ODTUG’s regional and local presence via co-hosted meetups.

There are many qualified candidates – regardless of who you vote for, VOTE!

Read all the campaign statements and biographies of the candidates.

ODTUG is the best source of learning for all Oracle development tools ~ your vote ensures we not only stay that way but grow as fast or faster as the tools we use.

To vote, please visit https://www.associationvoting.com/odtug and enter your email and Voter ID exactly as shown in the email you received from ODTUG (actually from announcement@associationvotiing.com) on or about 10/06/2015.

Not a member? Join!  You are missing out on the best Oracle training in the world, at minimal investment of a year’s membership fee. Betteryet, VOLUNTEER and quadruple the learning advantage.

As always, Happy Coding!

BTW ~ Accepting Viedos, Blog Posts, papers, podcasts – send us your excellence for publication in the ODTUG Technical Journal.

Karen

ODTUG Technical Journal Corner

ODTUG Technical Journal – submit papers now!

2015 ODTUG Kscope Editor’s Choice Award – Calling All Minds, Calling All Media

It’s that time of year again – for the ODTUG Editor’s Choice Awards. This year we welcome submissions in all media – even online annotated demos. Shows us your stuff – wow us with your brilliance and clever use of Oracle development tools!

Hello, ODTUG!

Spring is here – finally – and that means ODTUG KScope Editor’s Choice Award submissions are open,

The annual ODTUG Editor’s Choice Award honors excellence in creative, effective use of all modern media options to convey a complete technical topic to our members. Every Kscope presenter is eligible.

2015 is again an all-media year. The popularity of blogs, videos, and podcasts provest hat today’s developers gather and share information in a wide variety of media. ODTUG members consume information online and in various media formats, in addition to formal white papers and printed textbooks. Some say the white paper is dead; others simply save trees and present and consume all their technical content online. We are with you.

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. Two years ago, our Technical Journal transitioned to an entirely online format. Accordingly, we have made the same transition with our Kscope conference materials.

We ask our Kscope speakers to submit both their presentation slides (mandatory) and an alternate media technical submission (optional) that covers their presentation topic. The additional, non-PowerPoint submission is eligible for the Editor’s Choice Award. The Editor’s Choice submission may be in any combination of the media types: video, audio file, blog post, online demonstration, white paper or whatever, as long as we can reuse it in our online Technical Journal. Entries should convey a complete technical topic, the topic of the speaker’s presentation.

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

  • Increases the volume and variety 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. 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 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

Most important for the Editor’s Choice Award is overall excellence in technical communication of complete technical topic for our ODTUG members. Grammar, organization, proper formatting (for the media type), clarity, examples appropriate for the content, and how well the message is conveyed all matter more than the media type. The overall goal is to deliver great content to our members.

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. This is an easy way to volunteer for ODTUG and get a pre-conference view of all Kscope conference material. It’s like a conference before the conference.

So, Kscope presenters – WOW US with your stuff! 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,

Karen

 

Vote for the ODTUG Board!

 ODTUGatOOW

Voting for the ODTUG Board of Directors is now open, and this year brings an amazing list of candidates yours truly included.

I believe ODTUG is and should continue to be THE center of excellence for Oracle Developers – we do that through attracting and maintaining quality members, quality material and expert technical information in all media types, all through the work of our awesome volunteers. Social media and limited budgets bring opportunity and challenges to ensuring all our members have access to all our materials, not just those fortunate enough to attend KScope.  

I have been a member and volunteer for ODTUG since 2007, Editor of the ODTUG Technical Journal since 2008. Prior to that a member and volunteer for IOUG, Contributing Editor for the IOUG Select Journal. I have served on conference review teams, Editor’s Coice Award teams, speaker, ambassador, and in whatever other capacity is needed.  I want ODTUG to always be there when the next Oracle developer needs help and advice. 

Check out all the candidate statements here, and cast your vote to help ensure a strong and growing future for ODTUG.  Votes for Karen Cannell are much appreciated!

You must be an ODTUG member to vote, and if you are not already a member, I encourage you to join. Our user group is truly a fantastic source of technical material and side-by-side networking with the experts across the full suite of Oracle development tools. 

If you are an Oracle developer, ODTUG can help get you and keep you up-to-speed on the latest Oracle technology. And have fun and meet great people along the way.

 ODTUGatOOW

Mr. PL/SQL on NoSQL: YesSQL and the Oracle Database

Steven Feuerstein’s latest Confessions of a Dirty Programmer column actually focuses on – surprise – NoSQL. Yes, Mr. PL/SQL is writing about “Not Only SQL”.  In YesSQL and the Oracle Database, Steve addresses the NoSQL movement head on.  Is SQL old and tired?  Is Database a commodity?  Read on a Steven answers these questions, giving valid arguments why NoSQL and SQL (and of course PLSQL) can live together.  Btween Steven’s NoSQL perspectives and Iggy’s NoSQL information, you will be well-armed for NoSQL considerations.

If you have not seen this week’s ODTUG Technical Journal Corner – check it out now!

Next up is one of our ODTUG Editor’s Choice Award finalists, William Hodges on “Slow and Fast Changing Dimensions in Hyperion Planning”.  A fine paper – stay tuned.

After that, watch for our new BI columnist, Kevin McGinley, debuting with Part 1 of the three-part series, “Making the Case for Leveraging Agile and Continuous Integration in Oracle BI”.  Welcome Kevin!

 

Many thanks to Mark Rittman for bringing us years of BI Perspectives columns, all while maintaining many other writing, speaking and work commitments. BTW, Mark has an astounding T score if 1253!  No Low-T there.  Thank you Mark, and enjoy your “retirement”!

APEX 5.0 Interactive Reports: The Good, the Bad and the Ugly, Revisited

This presentation covers the Good, the Bad and the Ugly of APEX 5.0 Interactive Reports. In short, the good news is APEX 5.0 brings us multiple IR’s on a single page, plus some other enhancements like improved Group By and Pivot. 

The Bad is, to do this, the APEX Team changed the guts – CSS and JavaScript / jQuery – so anything you may have built previously that does not use the standard APEX APIs will need to be refactored.  Fortunately, I found the mapping between the old and the new quite easy to follow.  While the changes are tedious to make and test, I was fairly quickly able to get my customized IRs back in working order on APEX 5.0.

The Ugly remains the default look and feel, and WYSIWYG printing options.  In APEX 5.0 Theme Option will make applying consistent styles easier  – all told less work to make you IRs match the rest of your application.  As for WYSIWYG PDF output, so far there are no advances here.  The best option I have found is to capture the as-is IR query (different APEX_IR_QUERY solutions for APEX 4.1 vs APEX 4.2, and again for APEX 5.0 – improvements each version) combined with a function that returns a table in the Report Query, combined with a custom Report Layout.  One could use the generic layout, but since this does not allow for varying column widths or highlighting and other conditional formatting, for my case I needed a customized XLS-FO template.  No worries, I found once I  built the first few the process gets easier. I also used a generator for the first pass – a time-saver – then customized. That is a topic for it’s own post on another day.  Any way you slice it, PDF output beyond the default generic for IRs is time-consuming and tedious.

See the full presentation here:

APEX 5 Interactive Reports: The Good, the Bad, and the Ugly:  kcannell.GoodBadAPEXIR.presentation

.

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.

and
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

Aside

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,

Karen