If you’re trying to open a workbook from the SharePoint 2010 PowerPivot Gallery and you get this error: Data overflow converting to the data type for table ‘xxxxxxxxxxxxx’ column ‘Tape_Date’.” This is Excel Services saying that the PowerPivot Workbook is…
Getting started with Master Data Services in SQL Server 2012
Setting up MDS in a 2012 environment isn’t the most straight forward process. 2 issues I encountered while configuring on a standalone Hyper-V VM were IIS related, plus sample MDS package deployment. The following links will help to make the…
More BI videos – Ad-hoc reports, Data Mining
Data Mining: http://youtu.be/YrnD46xMFNk Ad-hoc reports : http://youtu.be/RWjUYpwOx70
SQL Server Business Intelligence – PowerPivot
MS SQL Server 2008 R2 Business Intelligence: PowerPivot http://youtu.be/hDCTr0AsGOg another vid
SQL Server Business Intelligence – Maps Integration
MS SQL Server 2008 R2 Business Intelligence: Maps Integration http://youtu.be/7Ukl6h06YDc A video I put together regarding Maps integration and MS SQL Server.
PowerPivot…
…is only supported by Excel 2010. While the Data mining add in will work with Excel 2007, Powerpivot will not.
RAID 5 vs. RAID 10
The following is a brief description of 2 of the main types of disk configuration you will deal with; RAID 5 and RAID 10. A notable differences is performance. In both cases disks are striped which at a high level means…
SharePoint 2010 Search returns results only for the current subsite
By default in SharePoint 2010, if you are using the search box on the top right hand side of a SharePoint 2010 sub-site, only search results for that sub-site are returned. If you want the search results to be returned based on the…
The server response was: 5.7.1 Unable to relay
SQL Server Database Mail has been configured correctly, but while trying to send a test email, an error is logged in the DatabaseMail log: The server response was: 5.7.1 Unable to relay After checking the mail log (Management studio –>…
Welcome
Welcome to my blog which will cover issues & resolutions related to Business Intelligence implementations mainly focusing on the Microsoft SQL Server Business Intelligence Stack