Future of Query and Analysis Studio, Time for Workspace Advanced?

​Future of Query & Analysis Studio, Time for Workspace Advanced Training?

Future of Query and Analysis Studio solved - The solution to address your needs is IBM Cognos Workspace Advanced. You probably own Workspace Advanced and you may just need some training on it. Lodestar Solutions will be hosting a 2 day classroom or virtual instructor led training class. The current schedule is listed on the Lodestar Solutions events page.

Future of Query and Analysis Studio
Attention all IBM Cognos Query Studio and Analysis Studio Users. The future of query studio and analysis studio in dim! Start thinking about Cognos Workspace Advanced as IBM announced Cognos Query Studio and Cognos Analysis Studio are being deprecated/will sunset. This essentially means they are going away with the next release (after Cognos BI 10.2.2). IBM FAQ on Deprecation of Cognos Query and Analysis Studio (Must Read)

What is Cognos Workspace Advanced?

Cognos Workspace Advanced brings together Query Studio, Analysis Studio, and Report Studio Express feathers...all in one place. IBM Video on Workspace Advanced

If you are a legacy IBM Cognos 8.x user, you can continue to use your queries from IBM Cognos BI8.x in IBM Cognos BI v10.x so you shouldn't have to rebuild everything you have. However, Lodestar Solutions recommends that you get prepared now. If you are on Cognos BI 10, you already have Workspace Advanced, so it's time to use it. It can create amazing dashboards and allow users to become less dependent on the BI team which will free you up.

Curious which of your IBM Cognos users have rights to Cognos Workspace Advanced?

All of your Cognos Business Analytics users, Cognos Business Analytics Explorers and Cognos Business Analytics Admins have rights to Workspace Advance. If you are on the current licensing structure, that's almost everyone! "But I still have Cognos Consumer licenses...so what about them?" Sorry...they do not have the rights to Cognos Workspace Advanced, however, with a simple trade-up, your Cognos BI Consumer can become Cognos Business Analytic user. Email Sales@LodestarSolutions.com for more info on licensing and trade-ups.

Call to Action:

  1. Lodestar Solutions recommends you take the 2 day training class and learn the tricks of Cognos Workspace Advanced. https://lodestarsolutions.com/calendar/
  2. Demonstrate Cognos Workspace Advanced to your user community. Lodestar Solutions has a video on our YouTube channel that will give you tips on how to give a software demo. How to give a software Demo - Lodestar Solutions

Cognos Analysis Query Studio Deprecation

With BI 10.2.2’s release, IBM announced Cognos Analysis Query Studio Deprecation

Now that Cognos Analysis Query Studio Deprecation has been announced, what should you do?  In software, deprecated typically means the software features remains in the software but it is recommended you discontinue use because the feature will be removed in the future. Features are deprecated rather than immediately removed to allow users some time to adjust. 

Cognos Analysis Query Studio Deprecation
Cognos Analysis Query Studio Deprecation

So what IBM is telling you is that it’s time to migrate your users from being reliant on Cognos Query Studio or Analysis Studio to using Cognos Workspace Advanced.  A great way to accomplish this is to teach them how to use Cognos Insight which is the desktop personal analytics solution that comes with many of the IBM Cognos licenses. Cognos Insight is a lightweight version of TM1 and BI all rolled up into one.

If you need help creating the plan to educate your users on Cognos Workspace… Lodestar Solutions is here to help.

• Lodestar can create a customized training programs that can be recorded to train the masses.
• Lodestar offers a free Cognos Insight workshop which you can host for your users.

Lodestar also offers training on Workspace and Workspace Advanced to minimize the risk of Query and Analysis Studio going away in future releases.​​

Call Lodestar Solutions To Create Your Plan.

There are other features that IBM deprecated. Support for the following features and products will not be continued after the 10.2.2 release:
• Cognos Query Studio
• Cognos Analysis Studio
• OLAP data sources with Compatible Query Mode (CQM), with the exception of Power® Cubes
• All 32-bit platforms
• Support for Cognos Mobile native client on Blackberry Server

REF: www.ibm.com/common/ssi/cgi-bin/ssialias?infotype=an&subtype=ca&appname=gpateam&supplier=760&letternum=ENUSJP14-0536

Call 813-254-2040 or email Services@LodestarSolutions.com

If you enjoyed this blog on Cognos Analysis Query Studio Deprecation, then check out this blog on PowerPlay Studio in IBM Cognos 10 by clicking here.

Who should use Cognos Workspace Advanced?

Cognos Workspace Advanced (known as Business Insight Advanced in 10.0) is an IBM Cognos product that encompasses Query Studio, Analysis Studio and Report Studio Express capabilities into one application. Now ad-hoc meets slice and dice, and can be wrapped up in a pretty package too.

Unlike Analysis Studio, end users no longer have to predetermine whether a data package is relational or dimensional because Query Studio functionality is also included in the application. The Cognos Workspace Advanced user interface and program capabilities automatically change to match the data source; reducing confusion and increasing end user satisfaction.

Query Studio and Analysis Studio require a very low skill set to master.  However, when advanced users outgrow the capabilities of these two studios and try to make the leap to Report Studio, they often find the distance to be too great.  The Report Studio Express functions available in Cognos Workspace Advanced are a perfect stepping stone.  Some of the functions that these advanced users will enjoy include creating calculated members and measures based on tuples, and creating sets in order to determine top and bottom members.  Additionally, since the expected skill level is lower, Workspace Advanced only requires a BI Advanced Business Author license; whereas, Report Studio requires a BI Professional Author license.  This is the beauty of Cognos Workspace Advanced; end users are trained once, on one application, and have room to grow without increasing cost.

The Difference Between Cognos Express and Cognos Enterprise

The Difference Between Cognos Express and Cognos Enterprise

IBM Cognos has two offerings for organizations looking for a complete Performance Management solution. One is IBM Cognos Enterprise Solutions and the other is Cognos Express. If you are looking for the power IBM offers, you may have some questions about what is the difference between Cognos Express and Cognos Enterprise.

So, we thought we would take a moment to walk through some of the differences. Note with each new release this information will change. IBM is expected to release a new Cognos Express version in the very near future and we will write again on Express once it’s released. As for now, IBM Cognos Express is positioned as the mid-market solution from IBM however, large companies can purchase it.

Cognos Express offers integrated modules for query, reporting, analysis, visualization, dashboarding and planning. Once installed, the product essentially creates a local data mart (via TM1) behind the scenes.

The biggest difference between Cognos Express and Cognos Enterprise is the number of users.

Express product supports a maximum of 100 users running a single server. Originally IBM had four modules in Cognos Express: Reporter, Advisor, Xcelerator, and Planner. Over the years, they simplified the licensing. In Express you can invest in Performance Management (TM1) or Business Intelligence, or both. Below is an older comparison to help you translate the old license to the Enterprise licenses. For the latest information on the differences between Cognos Express and Cognos Enterprise check out our most recent Cognos Express comparison blog.

Cognos Express LicensesClosest Comparable Cognos Enterprise Studios
ReporterReport Studio & Query Studio
AdvisorAnalysis Studio
XceleratorTM1 Modeler
PlannerTM1 Contributor
CompleteReport Studio, Query Studio, Analysis Studio, TM1 Modeler, TM1 Contributor

The biggest difference between Cognos Express and Cognos Enterprise is clearly the price. As of this posting, Cognos 10 Enterprise has a lot of new functionality that is not available in Cognos Express. Functionality like mobility, Business Insight, Active Reports and Metric Studio is missing. My recommendation is that you evaluate your business requirements and explore how both options meet your needs. Consider your expected growth. Make sure you will not out grow IBM Cognos Express too quickly and you will have to upgrade to Enterprise. Both offerings provide powerful Performance Management solutions, but check it out for yourself. Lodestar Solutions would be happy to answer any questions you may have on the differences between Cognos Express and Cognos Enterprise.

Link to Latest Version of Cognos BI

For the latest information, contact Lodestar Solutions at Services@lodestarsolutions.com.