Roger Doherty's SQL Server Evangelism Blog 47 minutes, 18 seconds 39 minutes, 9 seconds 5 minutes, 18 seconds 10 minutes, 57 seconds 14 minutes, 48 seconds 6 minutes, 31 seconds 12 minutes, 19 seconds 5 minutes, 17 seconds 4 minutes, 43 seconds 11 minutes, 9 seconds How To Create a Hyperlink to SharePoint's List Export to Spreadsheet - Westin's Technical Log Because you can't copy the hyperlink on the "Export to spreadsheet" link on SharePoint lists, here is how you can create your own hyperlink. Replace the [Placeholders] with your environment's information. A handy way to get the list and view GUIDs is to go into "Modify Columns and Settings" then scoll down to the views section and click on the view that you want to use. Here is an example: See also, MSDN's article: URL Protocol and my article: How To Add a Hyperlink To a SharePoint Event Outlook Export
Intro to Excel Services Data Sources - PerformancePoint Services The Excel Services Data Source in PerformancePoint 2010 allows you to create data using familiar Excel tools and methods that you can then surface in PerformancePoint scorecards. To demonstrate the use of the Excel Services Data Source, I'll walk you through creating a scorecard that shows information about U.S. state government finance. The data for the this scorecard will be in an Excel workbook in a SharePoint document library. For this example, I've created a sample workbook containing data about U.S. state government finances and population. To use a workbook like the one I've created as a PerformancePoint data source, first save it to a SharePoint site with Excel Services enabled. Publishing options control which parts of the workbook are exposed though Excel Services. Expose only the StateFinances2008 data table by selecting it on the Show tab of the Publish Options dialog: Here's the workbook in my BI Center document library: Once you've finished this, your data source is complete.
SharePoint: Script to Install All Application Templates | Alpesh Nakars' Blogosphere I referred to couple of posts to help you install WSS v3 application templates. If you followed those instructions to a tee, then you would have been successful in installing the application templates. However, installing 20 or 40 templates using that method made me cranky Why not install all of them using a script? Note: Make sure Windows SharePoint Services Administration service is running. Just include this in your script if you want net start spadmin Now extract all you Application Templates in a folder. Create a batch file with this code (Place this in the same folder where you have the templates) for %%f in (*.wsp) do “C:Program FilesCommon FilesMicrosoft Sharedweb server extensions12BINstsadm.exe” -o addsolution -filename %%f Run this. Create another batch file with this code (Place this in the same folder where you have the templates) pause I have added stop command for Windows SharePoint Services Administration service and also a pause. Done! Related posts:
Creating simple budget KPIs from SharePoint Lists - PerformancePoint Services In this post we're going to walk through how our favorite fictional company Litware uses PerformancePoint Services with SharePoint list data to do simple "under budget" KPIs. In Litware's party planning committee we log how much we spend on events using a SharePoint list. Corporate's creating a corporate balanced scorecard using PerformancePoint Services, and they've asked us to contribute a KPI showing how we're doing. For now our KPI will be based on the data we have, and the rules will be >100% budget is warning, >120% budget is bad. Later we can swap in other sources of information, for example employee anticipation around the next golf scramble, into the KPI's definition to make it a more accurate or more predictive metric, and the changes will flow into the higher level scorecard that uses the KPI. Here's a sample of our spending history list. I launch Dashboard Designer from the Business Intelligence site template homepage. Now we're ready to build the KPI and a test scorecard.
SharePoint Object Browser. Free source code and programming help Download the project - 13.37 KB Introduction This application is a SharePoint site object browser which shows all the contents of a SharePoint site in a tree structure. Background There are lot's of samples and help for SharePoint administration and customization. What this Application Does This is a SharePoint site object browser application. Understanding the Code We can take a SharePoint site instance (SPSite) from the site's URL. uxBrowser.Nodes.Clear(); SPSite site = new SPSite(uxAddress.Text); TreeNode rootNode = uxBrowser.Nodes.Add(site.Url); uxBrowser.NodeMouseClick += new TreeNodeMouseClickEventHandler(uxBrowser_NodeMouseClick); for (Int32 i = 0; i < site.AllWebs.Count; i++) { SPWeb web = site.AllWebs[i]; TreeNode webNode = rootNode.Nodes.Add(web.Name); for (Int32 j = 0; j < web.Lists.Count; j++) { SPList list = web.Lists[j]; TreeNode listNode = webNode.Nodes.Add(list.Title); listNode.Tag = list; } } _CurrentSelectedList = ((SPList)e.Node.Tag); Conclusion
Create a Reporting Services report by using Dashboard Designer Published: May 29, 2010 By using PerformancePoint Dashboard Designer, you can create Microsoft SQL Server Reporting Services (SSRS) reports for your dashboards. A Reporting Services report is a report that is published to SQL Server Reporting Services and contains one or more charts and tables. By adding a Reporting Services report to a PerformancePoint dashboard, you can reuse an existing report. In Dashboard Designer, you do not actually create a Reporting Services report. To create a Reporting Services report, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS). When you create a Reporting Services report by using Dashboard Designer, you do it in several stages, as described in the following list: Create the basic structure of the Web Part. To create the basic structure of your report Web Part In Dashboard Designer, in the Workspace Browser, click PerformancePoint Content. To connect to the report by using Report Center mode
SharePoint Shelter » Blog Archive » Differentiating Between the Cost and Value of SharePoint In class today, we had a heated debate regarding trustworthy, commercial collaborative software. Not surprisingly, I took the side of SharePoint so joined the group preparing the argument for the Microsoft stack (it was small group session breakout). Interestingly, the argument ended in a stalemate after both presented cases, both sides agreeing that each has their inherent benefits (its god damn hard to come up with an ample argument against Open Source benefits), and innate faults. However, from that preliminary argument, a new dialogue was produced. Regardless of the stack choice that either group was defending, it is typical that management level sponsorship for collaborative environment efforts often has difficulty pegging down the value of standing up a collaborative software instance. The celebrated dramatist Oscar Wilde once said: A cynic is a man who knows the price of everything but the value of nothing. Why? So, stuff like this is somewhat conjectural at the moment.
Getting acquainted with PerformancePoint dashboards and Web Parts - SharePoint Server PerformancePoint dashboards and their Web Parts can offer you a world of information about your organization. Because PerformancePoint dashboards are continually connected to their data sources, the information in them is up-to-date and it is usually interactive, too. You can do any or all of the following in a PerformancePoint dashboard: Drill up or down in data Filter data to see just the information you need Explore data through actions on various menus Open reports in new windows Export reports to Microsoft Excel or PowerPoint Print dashboards and reports This article covers what you can expect to see on a PerformancePoint dashboard page and what is included in a PerformancePoint Web Part. What do you want to know? What’s on a PerformancePoint dashboard page? PerformancePoint dashboards or dashboard pages vary considerably, depending on their purpose and their design. The Quick Launch pane Web Parts A link to Help In many cases, page navigation links and filters are also present. Filter
Chris O'Brien's blog: Using the SharePoint Content Deployment Wizard So if you've read the earlier posts about the tool (Introducing the SharePoint Content Deployment Wizard and When to use the SharePoint Content Deployment Wizard) and figure this is a useful tool, let's go onto the next level of detail. Generally speaking the Content Deployment Wizard 'just works', but if you want to know more about the different options, read on. This post contains reference information and a guide to some deployment scenarios at the end. Firstly, let's remind ourselves of some of the fundamental things to remember when moving content using the Content Migration API (the underlying SharePoint API used by the tool): In particular it's the 2nd and 3rd points which make the API (and the Wizard) a good way to deploy content in SharePoint. What can be deployed? The Content Deployment Wizard allows any content to be selected for export - site collections, webs, lists/document libraries, folders, right down to individual list items and files. These are explained:- Export options
PerformancePoint Services in SharePoint Server 2010 Learn about fundamental PerformancePoint Services concepts, procedures, and code samples, and find getting started information, troubleshooting tips, and other PerformancePoint Services resources. Last modified: June 03, 2011 PerformancePoint Services in Microsoft SharePoint Server 2010 is a SharePoint Server service application that you can use to gain insight into your organization's performance. It enables users to create business intelligence (BI) dashboards with scorecard, report, and filter Web Parts that contain interactive data visualizations. The PerformancePoint Services documentation contains overview topics, how-to topics, and code examples for developing custom extensions for PerformancePoint Services. Applies to: SharePoint Server 2010 Other online documentation for PerformancePoint Services includes topics that describe how to use PerformancePoint Services applications and how to set up PerformancePoint Services.
Chris O'Brien's blog: Creating lookup columns as a feature This is the second article in a series aimed at explaining the process of creating a MOSS site using SharePoint features. For the full series contents, see my introduction. Last time we looked at the process of creating some SharePoint lists using VSeWSS. Sure, creating a list is a simple end-user task using the SharePoint UI, but in some scenarios such as when your site is a highly controlled internet/WCM site (or generally anywhere where we have multiple environments for dev/QA/staging/production) this deployment technique doesn't really cut it. Today we'll look at creating site columns which get their data from lists (lookup columns). Note that a similar method is to define a site column with several CHOICE elements, as below:- However, this doesn't offer the same functionality as retrieving the values from a list. Now, when creating site artifacts as a feature, the developer will typically construct the definition in CAML, or allow VSeWSS to do this for him/her.
How to navigate PerformancePoint dashboards and explore data - SharePoint Server When you look at a PerformancePoint dashboard on a SharePoint site, you might see one or several items on it. Typically, but not always, the dashboard contains a scorecard, and some filters, charts and grids. Each scorecard and report is placed on the dashboard as a Web Part. You can navigate within a report or perform actions on the Web part itself. The dashboard in the example below shows a filter, links to more pages, a scorecard, an analytic bar chart, a KPI details report, and a pie chart. In some cases, the actions that you take in one Web Part affect the results that you see in another Web Part. You can easily view and explore data by using the scorecards and reports that are on a dashboard. What do you want to do? Navigate in a dashboard The real power of a PerformancePoint dashboard lies in its interactivity. Moving around the dashboard Use your cursor to select the scorecard or report you want to focus on. Interacting with scorecards and reports Top of Page Top of Page .
Leveraging Custom Property Builders in SharePoint Web Parts I'm anxiously awaiting Microsoft's release of Visual Studio Extensions for SharePoint Services as mentioned by Mathew Cosier here, Mart Muller here, and Wes Preston here. When released, these new extensions should make our lives as SharePoint developers a bit simpler. In the meantime, if you follow a consistent approach when laying out the structure and outputs of your WSS v3 Feature project, it becomes possible to create useful and time-saving tools for automation inside the Visual Studio 2005 IDE. As I previously mentioned, for these external tools to be useful across all of your WSS Feature projects requires consistency in how you structure the artifacts and outputs of your project. Makecab.exe is called from the Visual Studio project's AfterBuild target to create the WSS Solution Package including the project's freshly compiled assembly. Let's take a look at specific implementation for each of the external tools I'm using. WSP Solution Add WSP Solution Deploy Global