Archive for the ‘SharePoint 2007’ Category

Predixion Insight – Data Mining

January 22, 2011 1 comment

As I’m based in Sydney, I missed the webinar due to the time difference between US and AU. But luckily, I received a replay link and watched the demo.  Although I’ve play with Predixion software before, it is still exciting to watch over the demo.

Basically, in addition to the data mining functionality similar to the DM add-in for Excel, Predixion Insight is able to talk to PowerPivot. It is able to apply the trained mining model to the data set in PowerPivot and tag the record with the mining result. Then, using DAX to further format the dataset in PowerPivot and you can easily get a nicely analyzed predictive analytic report. Even more, with PMML support, you can even import SAS, SPSS model into Predixion Insight and then apply it to the dataset in Excel/PowerPivot as well as validation tools built into Predixion Insight to validate the model. Also, with Excel Services in SharePoint 2010, the final report can be uploaded and shared by everyone.

Before I had a bit concern about the data volume supported by Excel as well as Internet speed. Now I am much more confident after watching the demo. The PowerPivot would overcome the Excel data volume limitation. Regarding the data transferring across the Internet, the case given by Predixion software is that one of their client sent a 10 million records PowerPivot to the cloud server and it only takes around 4 minutes to get the mining results from the remote server. I believe in most cases, it would satisfy most of the small to medium organisations.

Now the only concern I have at the moment is the operational BI support. Imaging I have a model in the cloud used for identifying the customer category (e.g. good/bad). If a new customer is set up in the OLTP system, it would be fantastic if the system can query the model and tag the customer. In this case, Excel is not used at all. Instead, a web-service or APIs are required so that the OLTP systems can interact with the cloud mining services.

FW: WSS/MOSS 2007 Service Pack 2 breaks People Picker

August 13, 2009 Leave a comment
I had the same issue as the post described, see below
Categories: SharePoint 2007

Open links (PDF document) in a new window

A client requests that the PDFs stored in a SharePoint document library need to be opened in new window instead of navigating the page away.
Thanks to the tip from Dustin Miller (, I just modify the script to suit my needs.
   var theLinks = document.links;
   var thisDomain = window.location.hostname;
   // Edit "theMessage" to your liking
   var theMessage = "You are now leaving " + thisDomain + ".  The content of the requested web site is outside our control.  The requested web page will open in a new window.  You may click \"Cancel\" to stop loading the requested page.  You may need to hold your CTRL key down when pressing \"OK\" to bypass your pop-up blocking software.";
   // Change "showMessage" to 0 if you don’t want the warning to pop up when navigating to external sites.
   var showMessage = 1;
   function updateLinks() {
  for (i=0; i < theLinks.length; i++) {
   var thisLink = theLinks[ i ]; //Note: Remove the spaces if you like
   if (thisLink.href.indexOf(thisDomain) >=0 && thisLink.href.indexOf(".pdf") >=0) { = "_blank";
    //if (showMessage == 1) {
     //thisLink.onclick = confirmNav;
 function confirmNav() {
  return confirm(theMessage);
 document.body.onload = updateLinks;
Categories: SharePoint 2007

Registry file to point to SharePoint Data Connection Library

February 19, 2009 Leave a comment

We use SharePoint 2007 to host the centralized Data
Connection Library (DCL) to help the end users easily connect to SSAS cubes. From
the end users’ point of view, they don’t have to type server name, select cube
etc every time they are trying to query against SSAS. Instead, they will click
the “Existing Connection” to browse the specific folder and select the specific
Pre-defined DCL.

To do so, we need to create a registry file (.reg) and
publish onto the SharePoint. End users need to click the link and press “OK” to
import the .reg file. The below code is what you should have in the registry
file. The "http://MOSS2007/Reports/BI/Data
is the actual URL to the DCL we setup in SharePoint. You
can write multiple entries here if you do have more than one DCL.

Once you copy the code into a notepad and modify the URL
path, you can save it as a .reg file. Now it is ready to distribute.

/* Start of the code –don’t put this line in the .reg file. This is comment
Windows Registry Editor Version 5.00


"Data Connection Library"="http://MOSS2007/Reports/BI/Data

Categories: SharePoint 2007

PageViewer WebPart and QueryString parameters for Sharepoint BI Dashboard

February 18, 2009 1 comment

WSS3.0 and MOSS 2007 doesn’t have an out of box Page Viewer control that supports query strings. Mads Haugbø Nissen has developed a QueryStringPageViewer WebPart ( )

Categories: SharePoint 2007