Tag Archive for: Cognos Workspace Advanced

Due to the rapid pace of today’s business world, new strategies, products, projects, and tools are being introduced on a constant basis. This means that the speed of business often does not match the speed at which IT departments, which tend to have to follow rigorous testing and governance policies, can provide ways to measure the success of the given implementation. With tools like social media and Google at our fingertips to provide constant and immediate information at our every whim, the ability to get answers to business questions with the same deftness as we can in our personal lives becomes expected by BI end users. That’s why accounting for self-service options is essential. Read more

IBM Cognos Workspace Advanced and IBM Cognos Report Studio allow you to integrate external data directly into your reports. This allows you to create a report using an external source that contains data which is not part of your IBM Cognos Business Intelligence enterprise data. You can import your own data file and start reporting on it right away. After importing, your external data file is protected by the same IBM Cognos security as your enterprise data, thus allowing you to report on your data in a secure and private environment. Read more

For an updated version of this blog post using IBM Cognos Analytics 11.1.7, click here.

For users of IBM Cognos Workspace Advanced (formerly Business Insight Advanced), a popular request is to have the ability to highlight every other row in a list report. This technique has been demonstrated with IBM Cognos Report Studio using the running-count() and mod() functions. The issue is that IBM Cognos Workspace Advanced does not expose all functions that can be used in query calculations, so users think they are not available.

This article will demonstrate how to highlight every other row using IBM Cognos Workspace Advanced by entering a ‘non-exposed’ function in the expression editor (the twist!). Read more