Author Archives: Melinda Cole

Cannot Create a BI Semantic Model Connection to Tabular Cube

Posted on November 3, 2012 by Melinda Cole

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 | Leave a comment

BISM Connection to Tabular Cube and Data Link Properties

Posted on November 3, 2012 by Melinda Cole

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

Posted on November 3, 2012 by Melinda Cole

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 | Leave a comment

YTD Calculations

Posted on January 14, 2012 by Melinda Cole

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

Posted on September 9, 2011 by Melinda Cole

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

Posted on April 4, 2011 by Melinda Cole

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

Posted on October 7, 2010 by Melinda Cole

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 , , | 4 Comments

Prevent SSRS 2008 from Overwriting Datasets

Posted on September 13, 2010 by Melinda Cole

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

Posted on June 24, 2010 by Melinda Cole

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

Posted on January 5, 2010 by Melinda Cole

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