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

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

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

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

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

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

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

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

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

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

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

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