Query Studio 8.4

The often overlooked Query Studio has been a simple little query tool that hasn't seen much visible change in the last few years. While new studios for Query continue to pop-up (Express Author, PowerPlay Studio, CAFE), Query Studio chugs along as a handy product to quickly build lists and crosstabs. Cognos developers have always replied on Query Studio as a way to verify Framework Manager models -- it's fast and reliable, and seeing the data immediately rather than having to execute is great.

As with every Cognos 8 release, there's not much new to report with Query Studio. Still, a few nuggets have come out of 8.4:

• Filter Usability: Query Studio users rejoice! You can now type in values when filtering a dimension. This means you can easily copy and paste from a list you may keep handy in Excel or a note. This long awaited feature has arrived. And there's more -- you can also now add a filter without adding a column to the query -- just right click on the data item.

• Lineage: Lineage is a new feature in all 8.4 Studios that traces the metadata through the package and datasources. It's really handy when testing a multi-layered model, and is a great advancement in Cognos 8.4. It's there, as you would expect, in Query Studio 8.4.

• Performance: Like all studios, performance has been improved each release. 8.4 is really snappy on my demo data sets, both relational and dimensional.

I've been digging into Cognos 8.4, so I'll recount some of my findings here, and in a bit more detail on my IBM blog.  If you're really interested beyond what you see, please feel free to drop me an email.

Report Studio Positioning

Report Studio was released as  the Cognos production report authoring tool with ReportNet in 2003 .  Report Studio, though, has evolved into a more robust power user tool that can be used by financial analysts, operations, or any line-of-business user who has a good sense for data and design.

Since it's web-based, Report Studio takes end user deployment complications out of play.  That is, of course, except for that annoying IE requirement (more on that later).  While that's not particularly important in my work, it is extremely important, and valuable, for rolling out the tool to a broad user community.  Unlike programming-based report writers, many professionals can benefit from reporting and analysis through Report Studio.

I think Report Studio, when implemented with a few value-added templates and customizations, can be used by the majority of end-users who would otherwise use Cognos query and analysis studios.  It also can, and will, be useful for IT professionals to create reports that are distributed to the masses via the web, email, or filesystem.  Its combination of rich functionality and author productivity is truly unique in the market.

For true "production" reporting, it's still good practice to move complex logic to ETL processing, or the database itself.   While possible, its not a practical tool for replacing reports built in structured programming languages (COBOL, SQR, etc.) that produce massive volumes of static content, such as billing statements or other structured forms.

With that said, on to some deeper thoughts about 8.4...

8.4: What I Like

I'm happy to report there's a lot of good in 8.4.  This isn't an exhaustive list of new features, just the ones I found particularly valuable in my work:

• Microcharts: Three cheers for microcharts!  As an ardent follower of design techniques by Stephen Few, I've found microcharts to be an excellent implementation of dashboard content.  I've already gleefully used micro-column and line charts in my development.  Microcharts are excellent for a variety of decision support, including trending by category and win/loss.  Maximum information in minimum real-estate.
• Conditional Formatting:  This was overhauled in 8.3, but it deserves mention for the interface, which is vastly improved over the conditional variable approach.  The usability of the metrics-style range is fantastic, as is the interface to quickly set the most important properties in a condition.  The whole experience is improved, and saves the author significant time.
• Master/Detail:  This also was improved in earlier releases, but it's easier, and more intuitive, than ever to create master/detail reports.  Master/detail reports are also snappier, which is important, since they a primary feature needed to build more complex logic into Cognos reports.
• Performance:  Report Studio really performs well, even on an underpowered laptop or virtual machine.  Since the interface isn't truly WYSIWYG, the improvements running reports to refine formatting is another great time saver for the author.
• Singletons:  While introduced in 8.3, they seem to perform better in 8.4.  Use them often to highlight certain results that warrant immediate attention in a strategic piece of screen real estate.
• Cognos Mashup Services:  For OEM partners only, CMS is an important enabler of reports to third party applications.  Really important, and really cool.  

Report Studio: Where it Should Go... 

I have a number of ideas, including Express Author, Usability, and Openess.  Questions?  Comments?  Bring 'em!