Simpson Associates Blog

A solution to Cognos Express data format issue

Friday 28th March 2014

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 »

Features of Power BI

Wednesday 19th March 2014

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 »

Our current favourite SQL Server 2012 functions

Tuesday 18th February 2014

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 »

Cognos General Housekeeping

Tuesday 26th November 2013

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 »

IBM Cognos Business Intelligence 10.2 Released

Friday 14th September 2012

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 »

Restoring Cognos Contributor Applications from SQL Server Based Datastores

Thursday 24th May 2012

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 »

Active Reports Debug Menu

Wednesday 23rd May 2012

  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 'Run' ...

Read Full Article »

IBM Cognos Planning 10.1.1 & Windows 2008 Installation Problem

Wednesday 23rd May 2012

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 »

SCCM over VPN connections

Friday 27th April 2012

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 »

IBM Cognos 10 Report Studio Style & Conversion

Friday 23rd March 2012

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 »