Search Results

Find a complete list of all the FULL exercises the are included in our Complimentary BI Quick Reference Guide - Save hours and understand the power of Project Server 2010 Reporting.  You may also be interested in saving several hours and money with our Project Report Pack.

As an extension of our BI Reporting Quick Reference Guide – the Microsoft Reporting database & OLAP Cube schemas are available in Project Server 2010 SDK found here: http://www.microsoft.com/en-us/download/details.aspx?id=15511 Note:  Use unique service account with Read Only permission to access the data Download Complimentary BI Quick Reference Guide - Save hours and understand the power […]

In our BI Reporting series, we address several BUI reporting tools. This blog expands on our Business Intelligence Quick Reference Guide in the area of SSRS reporting. Enjoy.   1.From SQL Server Business Intelligence Development Studio (comes with SQL) create a project File?New?Project?Report Server Project 2.Enter Project Name and click OK 3.In Solution Explorer right-click […]

In our BI Reporting series, we address several BUI reporting tools.  This blog expands on our Business Intelligence Quick Reference Guide. Enjoy. Step Action Details 1. Start Visio     2. Mock up report in Visio     3. Link shapes to database: Data?Link Data to Shapes?Microsoft SQL Server Database   4. Select the UserView: […]

Step Action Details 1 Launch PWA, Navigate to the Business Intelligence Center > PerformancePoint Content. 2 Navigate to PerformancePoint Content 3 Navigate to the Items ribbon, then New Item > PerformancePoint Report. 4 The PerformancePoint Dashboard Designer begins to load 5 Once fully launched, from the Workspace Browser right-click on Data Connections, then select New […]

When you first attempt to create a PerformancePoint report you may receive an error stating an issue with an unattended service account.  The steps below will resolve this error and allow you to develop your reports. Step Action Details 1 Launch SharePoint Central Administration by Selecting Start > SharePoint 2010 Central Administration 2 Under Application […]

Step Actions Details 1 Download then double-click the ReportBuilder3 executable file. 2 Navigate Start > Report Builder 3.0 to launch the application 3 Report Builder is launching 4 When prompted, specify the URL for your SQL Server Reporting Services. 5 The Getting Started window displays 6 Select New Report > Chart Wizard 7 Check the […]

We have a configuration of Project Server 2010 that uses Analysis Services over HTTPS/ssl.  With one particular environment the cube build process would always fail with the message noted in this post.  Based on the typical findings on the web, I’d run through and confirm the typical settings, including permissions among other things.  Strange enough, […]

Step Action Details 1 Launch Project Web App and navigate to the Business Intelligence Center 2 Navigate to Business Intelligence Center > Sample Reports > English (United States) 4 Expose the contextual menu for the Simple Projects List > Edit in Microsoft Excel 5 If presented with a security warning, click the Enable Content button […]

reposted from Technet. I located this method and found it interesting, and therefore wanted to post to our blog. Updated: 2009-07-20 This article describes how to extract a Project Web Access (PWA) site from an existing content database that also contains non-Project Web Access sites, and then move the Project Web Access site data to […]

I was recently performing a development refresh of a Project Server 2007 environment for a client this week in preparation for training we are to be conducting.  In this case I needed the Project Workpaces as well.  The simple approach I took is outlined below: Log into SharePoint Central Administration in the development environment Navigate […]

  reposted from technet   This article describes several methods that you can use to recover a project workspace site when the problems that are mentioned in this "Summary" occur. Project workspaces are saved in a content database for the Web application that hosts the Project Web Access site. If a Project Web Access site […]

This is a frequent occurrence when refreshing a development environment.  The commands below will kill the connections and allow the restore to continue:   ALTER DATABASE <databaseName>     SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ALTER DATABASE <databaseName> SET MULTI_USER GO

Recently I was setting up a Visual Studio 2010 solution on a client’s environment in order to perform some development work.  In this case I was performing development that required use of some Project Server web services.  In the Visual Studio solution I easy enough navigated right-click on project and selected Add Web Reference (see […]

If you are creating a SSRS report in Visual Studio 2008 and would like a parameter to display multiple values including NULL values, you will get a message saying, “A multi-value parameter cannot include null values”. However, there is a 2 step method to work around this. 1)       In the Dataset that provides values for […]

Should your log files grow too large you may truncate/shrink them in SQL Server 2012 as follows: -- this method USE SharePoint_Config_A003; GO SELECT file_id, name FROM sys.database_files; GO DBCC SHRINKFILE (2, TRUNCATEONLY); -- or this method DBCC SHRINKFILE (SharePoint_Config_A003_log, 1)     -Dan

Resposted from Christophe Fiessinger by Christophe Fiessinger on October 11 That’s right, today the Project engineering team signed off on the Release to Manufacturing (RTM) build of the new Project. We wanted to share this very exciting news with you before we went off to celebrate. We are very excited about the new version of […]

Step Action Details 1 From PWA, Navigate Server Settings > Manage Views 2 Click the New View toolbar button 4 From the View Type drop down, select Project Center, then specify a name for your new view.  You may optionally specify a description 5 In the Table and Fields section, add fields to your view […]