Simpson Associates Blog

TM1 Application Web Administer Applications Icon and Published Applications Missing

Thursday 19th February 2015

  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 »

Excel Services Data Refresh Fail with PowerPivot and SharePoint

Thursday 19th February 2015

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

Cognos Express – CXMD service failing to start

Monday 17th November 2014

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 »

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 »