2100 Clearwater Dr. Suite 330, Oak Brook IL 60523

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

Blog

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 […]

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 […]

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 […]