Simpson Associates Blog

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

Monday 13th October 2014

{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 »

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

Monday 04th August 2014

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 »

Import Wizard SQL Server 2012 bug

Tuesday 17th June 2014

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 »

Using IE10 or IE11 with Cognos BI Studio

Tuesday 13th May 2014

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 »

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 »

Support Services – Frequently Asked Questions

Wednesday 01st January 2014

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 »

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 »