2100 Clearwater Dr. Suite 330, Oak Brook IL 60523

1-(708) 575-2090 contact@pmsquare.com Visit our other locations: australia singapore philippines

Tag: Cognos Analytics

Design Templates and Themes in Cognos

Design Templates and Themes in Cognos Analytics

Do you find yourself adding the same image or making the same formatting changes to all of your Cognos reports? Do the standard Cognos colors for lists and crosstabs not do it for you? Out of the box, you can use a set of standard templates and themes in Cognos […]

Improve data-level secuirty in cognos

Improve Data-level Security in Cognos Framework Manager Part II

In a previous article, we explained the process and general approach of implementing data-level security in your IBM Cognos BI environment which is absolutely important. However, the great drawback of this approach is the ongoing maintenance!  In this article, I will examine how to streamline and improve data-level security in […]

Data-Level Security Using Cognos Framework Manager

Data-Level Security Using Cognos Framework Manager Part I

Cognos Framework Manager (FM) is an essential part of using IBM Cognos Analytics. In addition to being the designated Business Intelligence (BI) modelling tool of the Cognos family, FM is where operators can implement data-level security.  Leveraging data-level security using Cognos Framework Manager is critical for organizations that need tailored […]

Configure IIS in Cognos Analytics

Configure IIS in Cognos Analytics with an Automated Script

IIS in Cognos Analytics Configuring Internet Information Service (IIS) as the web server for Cognos Analytics has been a challenge since the initial release of 11.0.  IBM made changes between version 10 and 11 which caused the web server to function as a reverse proxy. This meant that additional rules […]

Cognos Tips – Using Text Variable on a Null/Missing Crosstab Value

The Problem: No Data in the Fact Cells A common requirement that I come across is to have 0 values render in crosstab cells where there is no data at that intersection of the column and row dimensional/attribute data.  This is especially common when the output to Excel (spreadsheetXML) is […]

Cognos Portal Customization

A little branding goes a long way Do you remember how tedious it was to custom skin Cognos in the 10.x portal?  If you wanted to make global changes in the portal only, you had XML changes to makeā€¦but if you wanted to make global changes to the viewer or […]