July 10th 2017

RESOLVED: Snapshot to Excel ‘hangs’ at the ‘Currently Publishing…’ stage in IBM Cognos TM1.

If you find Snapshot to Excel appears to hang at the ‘Currently Publishing…’ stage, consider the length of the element names in the title dimensions you have selected to import. The critical dimension is the last dimension on the list which ...

Read Full Article
May 22nd 2017

IBM announce that support for Cognos Planning 10.1.1 will end on 30th April 2018.

IBM has announced the official end of support for Cognos Planning 10.1.1 as the 30th April, 2018. This may have different implications depending on a variety of circumstances. Due to this we are available to discuss your individual queries and needs, ...

Read Full Article
May 03rd 2017

Microsoft announce changes to their Power BI Service as they introduce Power BI Premium

Following the success of its Power BI service, Microsoft has unveiled a new licensing option for Power BI, ‘Power BI Premium’ that offers organisations more user licensing flexibility along with performance-tuning options. Power BI Premium is based on the capacity-based licensing ...

Read Full Article
April 28th 2017

Microsoft Power BI April Summary

This month Microsoft are delivering a number of great capabilities. They are introducing Quick measures, which is a huge update to the Quick Calculation experience. They have some very exciting updates in both data connectivity and query editing, including allowing you ...

Read Full Article
April 06th 2017

IBM announce that support for Cognos BI 10.2x will end on 30th April 2018.

IBM has announced the official end of support for Cognos BI 10.2.x versions as the 30th April, 2018. This may have different implications depending on a variety of circumstances. Due to this we are available to discuss your individual queries and ...

Read Full Article
March 30th 2017

Power BI March Summary

Microsoft is ever changing its Power BI product capabilities with monthly releases. Our monthly Microsoft Power BI roundup provides information regarding key updates to the tool. Microsoft release several highly-requested features in this month’s Desktop release We have a very exciting Power ...

Read Full Article
October 24th 2016

IBM Planning Analytics Local will be available from December 14, 2016

Last December IBM introduced us to the new face of TM1, IBM Planning Analytics. This announcement introduced a cloud based self-service, Financial Planning, Budgeting and Forecasting tool into the IBM Tool set. Up until now though the new face of TM1 had ...

Read Full Article
October 14th 2016

ALERT: TM1 Server and Client Certificates Expiring

Within all TM1 environments 9.5.X environments through to 10.2.2, Fix Pack 6, client (Performance Modeler, Cognos Insight, Architect, Perspectives) to server communications are encrypted by default using IBMs ‘Applix’ certificate chain of trusts and corresponding private keys. When all TM1 ...

Read Full Article
November 23rd 2015

Cognos TM1 10.2 to 10.2.2 – Application cannot be deployed

This blog describes how to deal with the TM1 error message occasionally received when you are trying to deploy an application (TM1 version 10 onwards). Full error message and details: The error occurs when you are trying to re-deploy an application from ...

Read Full Article
July 28th 2015

Blanks and Zeroes: Navigating the BOARD Excel Add-In

*Please note that you can click on the images to enlarge them* The Excel add-in is one of BOARD’s most user-friendly features. It allows the end user to edit data and execute familiar formulas whilst still benefitting from the exceptional reporting ...

Read Full Article
July 27th 2015

OneDrive for Business – New Security Options for IT Administrators

There are some really great updates to OneDrive for Business from an IT Administrators/Managers point of view in the Office 365 stack recently; One of main ones is that you can now restrict Onedrive sync to domain joined only machines. This ...

Read Full Article
June 16th 2015

Cognos and Hypervisor CPU Cycles

We are often asked by client’s VMware and Hyper-V administrators, where Cognos BI is hosted within a virtualised environment for confirmation on how Cognos deals with CPU cycles and the result/requirement this has on the Hypervisor platform. This blog will ...

Read Full Article
February 19th 2015

Excel Services Data Refresh Fail with PowerPivot and SharePoint

*Please note that you can click on the images to enlarge them* I was recently working on deployment of SQL Server PowerPivot 2014 integration with SharePoint 2013. Once the components were successfully installed and configured, I created a sample PowerPivot Report within ...

Read Full Article
February 19th 2015

TM1 Application Web Administer Applications Icon and Published Applications Missing

  I was recently carrying out work for a client to upgrade their existing TM1 10.2.2 environment to Fix Pack 1. Once I installed Fix Pack 1 for TM1 server components on top of the existing 10.2.2 environment, I proceeded to starting ...

Read Full Article
November 17th 2014

Cognos Express – CXMD service failing to start

Recently we’ve encountered issues with Cognos Express whereby the CXMD (TM1) service stops almost immediately after starting. No error messages are presented except the Express Manager page indicates something is wrong, with other components complaining that Manager is in an unhealthy ...

Read Full Article
October 13th 2014

Unable to view Transaction Log in TM1 Architect – (Error ActiveX Control mcmask32.ocx)

{Remember you can expand the images below by clicking on them} In TM1 Architect in Express 10.2.1, when you select a Server and right click to select View Transaction Log You receive the following error The issued is caused by the fact that ...

Read Full Article
August 04th 2014

Cognos Express 10.2.1 – A Solution to the TM1 Server crashing after running the SaveDataAll process as a chore.

The TM1 server crashes after the SaveDataAll process is scheduled to run as a chore. This can results in loss of data/changes made since the last successful SaveDataAll process was run, and will require the express services to be restarted ...

Read Full Article
June 17th 2014

Import Wizard SQL Server 2012 bug

We recently encountered the following bug in SQL 2012 with the import export wizard. The problem occurs when you are using a query as the source for the import.  This cause’s data type mapping issues with any varchar datatypes, it changes ...

Read Full Article
May 13th 2014

Using IE10 or IE11 with Cognos BI Studio

If you have upgraded recently to use the latest versions of Internet Explorer 10 or Internet Explorer 11 you might notice some issues when using Cognos BI Studio. Issues include:- * Icons not displaying in Cognos Studio * Blank page when opening a ...

Read Full Article
March 28th 2014

A solution to Cognos Express data format issue

Error when trying change the format of a data Item (HAL Error – rs_fm_dta_frmt_props_en.xml) In report studio when you try to change the format of a data item either by using the Properties pane and selecting Data Format or selecting the ...

Read Full Article
March 19th 2014

Features of Power BI

Did you know Microsoft has recently announced the general availability of Power BI a cloud-based business intelligence service for analysing data with Excel and Office 365? Our easy to digest infographic explains some of the core features to this product. ...

Read Full Article
February 18th 2014

Our current favourite SQL Server 2012 functions

SQL Server 2012 introduced a new range of features all aimed at improving delivery of Business Intelligence (BI) solutions. This included some improvements to T-SQL which could easily be overlooked, but are extremely useful, particularly in the development of BI ...

Read Full Article
January 01st 2014

Support Services – Frequently Asked Questions

How can I log into the portal? - Email help@simpson-associates.co.uk and provide your email address, they will create a new userid and set your password. I have forgotten my password? -  Email help@simpson-associates.co.uk and request a new password. I have forgotten my login details? ...

Read Full Article
November 26th 2013

Cognos General Housekeeping

Cognos create many temporary files when performing many activities such as generating reports and creating cubes. These are stored in the temp location which is specified in Cognos Configuration, under Environment.   By default this is <Cognos Installed directory> temp If you have Transformer ...

Read Full Article
September 14th 2012

IBM Cognos Business Intelligence 10.2 Released

IBM has released the new version of Cognos Business Intelligence this week – version 10.2. The latest release contains welcomed updates as well new features across the suite of BI applications. Business Workspace Instantly the first thing that you'll notice is that ...

Read Full Article
May 24th 2012

Restoring Cognos Contributor Applications from SQL Server Based Datastores

A useful feature for importing an existing Contributor Application within the Cognos Planning Contributor Administration Console, if you haven’t taken a deployment using the export wizard is the ‘Link to Existing Applications’ option. This is available when right clicking on ...

Read Full Article
May 23rd 2012

Active Reports Debug Menu

  For help debugging Cognos 10 Active Reports, it's possible to select a run option that shows the state of active report variables in the report as you click various controls: With the Active Report open in Report Studio, select the ...

Read Full Article
May 23rd 2012

IBM Cognos Planning 10.1.1 & Windows 2008 Installation Problem

Earlier this year whilst installing Cognos Planning 10.1.1, I uncovered a fairly major bug (or "known issue" as IBM like to call them). The environment consisted of a single Windows 2008 Cognos Planning server and a SQL Server 2008 SQL Server ...

Read Full Article
April 27th 2012

SCCM over VPN connections

As part of on-going internal infrastructure projects, we have recently implemented new Endpoint security across our network namely Microsoft Forefront 2010. As part of the prerequisites for Forefront we needed to install Microsoft SCCM 2007. The configuration of SCCM and Forefront ...

Read Full Article
March 23rd 2012

IBM Cognos 10 Report Studio Style & Conversion

Following a recent support call I found a nice way of changing the overall look and feel of a Cognos 8 report that has been imported into a Cognos 10 environment. When I looked at the XML of a new (blank) ...

Read Full Article
February 10th 2012

IBM Cognos and 64bit Servers, again!

If you receive this error message after installing IBM Cognos BI or Planning on a Windows 2008 64bit server: HTTP Error 500.0 - Internal Server Error The page cannot be displayed because an internal server error has occurred. Then it is more than ...

Read Full Article
December 15th 2011

IBM Cognos 10.1.1 and Adobe 10

During a recent site visit we found that IBM Cognos 10.1.1 could not print PDF Cognos reports. We received the following error: Failure RSV-DST-0014 Unable to deliver the output of the report. See the run history details for more information. Ensure ...

Read Full Article
November 21st 2011

Add Database Specific Functions into IBM Cognos Report Studio

Have you ever wanted to add database specific functions into Report Studio for easy access? Here’s how: 1. On your Cognos server navigate to the following directory: <C10 INSTALLATION DIRECTORY>c10configurationfunctions 2. Open the FileList.xml which contains definitions and descriptions of vendor specific functions. ...

Read Full Article
October 17th 2011

Microsoft IIS 7 Issues with HTTPS – Port 443 Access

During a recent Cognos BI and Planning, 8.4.1 to 10.1 upgrade I experienced issues around using port 443 for HTTPS access to the gateway. After successfully completing the installation of 10.1, I was able to access Cognos connection via the ...

Read Full Article
October 17th 2011

Windows Firewall and Port 9300

During an installation of Cognos 10.1 on a distributed environment, I ran into Windows Firewall issues. The environment consisted of 2 failover Content Manager servers, 2 Dispatcher servers and 1 Gateway server. I successfully started the first Content Manager server; ...

Read Full Article
October 12th 2011

IBM Cognos Planning on 64bit Servers

A known issue has arisen in the latest versions of IBM Cognos Planning when installing on 64bit servers as detailed here: https://www-304.ibm.com/support/docview.wss?uid=swg21472649. On developing a new production environment in our own infrastructure I was hit by the issue myself, but ...

Read Full Article
August 12th 2011

Creating Default Styles In IBM Cognos Connection

I have recently been working with a client to implement a corporate style/theme incorporating their company's logo, which will be displayed across the client's Cognos Connection. After we successfully implemented the style, it would usually be the case that the individual ...

Read Full Article
June 17th 2011

The importance of IBM Cognos Connection Content Store backups

I have lost count of the amount of occasions we see clients in a pickle due to a corrupt Content Store database. On many instances the only option is to revert to a working backup of the Content Store. However, IT may not ...

Read Full Article
May 25th 2011

IBM Cognos 10 External Data – Wizard not launching – Buttons Greyed Out

I was completing an install for a client this week and the Cognos 10 External Data Wizard was not launching and all the buttons where greyed out. If I logged on to the server as the same user, it worked correctly. I ...

Read Full Article