Author Archives: Melinda Cole

Cannot Create a BI Semantic Model Connection to Tabular Cube

Here’s the scenario: Within the PowerPivot Gallery in SharePoint 2010 you create a new “BI Semantic Model Connection”.  In the “New BI Semantic Model” page you specify the name of the connection, the Workbook URL, and Database.  When you click OK the … Continue reading

Posted in Uncategorized | 9 Comments

BISM Connection to Tabular Cube and Data Link Properties

Here’s the scenario: You have a PowerPivot Gallery within SharePoint 2010.  Within the gallery is a BISM connection that points to a Tabular cube.  You attempt to use the BISM connection to open a new Excel workbook by clicking on … Continue reading

Posted in Uncategorized | Leave a comment

How to Open Dashboard Designer in SharePoint 2010

So you’ve got a new Sharepoint 2010 server configured and now you want to create a PerformancePoint dashboard.  The first thing you need to do is create a new “Business Intelligence Center” site.  You can find it under the Data category in the … Continue reading

Posted in PPS, SharePoint | 1 Comment

YTD Calculations

Whether you’re creating a report, chart, KPI, or calculated measure, at some point you’ll probably need to add year-to-date calculations. It doesn’t matter if you’re using SQL or MDX, the technique to generate the From and To dates for a … Continue reading

Posted in MDX, SQL | Leave a comment

When To Use NVARCHAR

The Short Answer Only when you need to store multi-lingual (unicode) data.  The Nitty Gritty The fundamental unit of storage in a SQL Server database is an 8 KB page.  To paraphrase the MSDN, SQL Server reads and writes whole … Continue reading

Posted in SQL Server | Tagged , , , , , , | 4 Comments

How to Generate Insert Scripts for Existing Data

Let’s say you have a bunch of data stored in a table and you need to generate an insert script for each record. Maybe you need to save the scripts in source control or maybe you need the scripts to … Continue reading

Posted in SQL Server, SSMS | Tagged , , | 9 Comments

Virtual PC and Windows 7

This morning while trying to spin up one of my Virutal PCs I ran into some peculiar error messages.  In case the same thing happens to you, the workaround is pretty simple.  When I opened Virtual PC and selected my … Continue reading

Posted in Windows | Tagged , , | 6 Comments

Prevent SSRS 2008 from Overwriting Datasets

Report development is one of my favorite areas of Business Intelligence and I have to say I’ve been fairly happy with the new interface for SSRS 2008.  Except for when it comes to MDX queries.  Off the top of my … Continue reading

Posted in SSRS | Tagged , , , , , , | 2 Comments

SQL Server 2005 Installation Failures

Recently I was trying to install SQL Server 2005 on a workstation running Windows XP Professional SP3 and for some reason the installation kept failing. The first item in the list that failed was MSXML 6.0. After combing through the … Continue reading

Posted in SQL Server | Tagged , , , | 1 Comment

SharePoint JavaScript Error: Library Not Registered

The other day one of my clients upgraded from Outlook 2003 to Outlook 2007.  Since then, whenever she went to her company’s SharePoint site, she received the following error:  ==================================================================  Website error details  User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows … Continue reading

Posted in SharePoint | Tagged , , , , , , | 15 Comments