A. Set a linked server (analysis server) in your SQL Server In the SQL Server Surface Area Configuration enable 'Ad Hoc Remote Queries' 1. Open SQL Surface Area configuration 2. Go to Database enginer --> Ad Hoc Remote Queries --> Set...

Technorati Tags: SSAS , Cube , Security , Dynamic Security , username , Analysis Services , SQL Analysis Services For implementing dynamic security in your SSAS cube you need make little change in the Dimension model. Steps: 1. Assuming you...

In this post let’s see how you can pass the parameters into your OLAP report. The parameters have to be passed dynamically through the WinForm application. Here we will NOT be using the report parameters which you would have added on the report at...

In one of my current data warehouse projects I wanted to use a time dimension. The time dimension structure I wanted was very similar to the one available with AdventureWorksDW but it has the date only till year 2004. I had written a simple SP to populate...

1. Use calculated members with Scope assignments instead of using IIF The reason this option is faster is because the scope subcube definitions enable the Query Execution Engine to know ahead of time the calculation space for each business rule. Using...

TFS Migration and Synchronization Toolkit is now available at http://www.codeplex.com/MigrationSyncToolkit

This is awesome! A much needed thing has finally arrived. We have been getting request from customer and partner community about How to use TFS effectively in their company/projects with the real work constraint. Thanks a lot to P & P team who worked...

Microsoft Visual Studio 2005 Team Foundation Server Power Tool The Microsoft Visual Studio 2005 Team Foundation Server Power Tool (formerly known as Power Toys) is a set of enhancements, tools and command-line utilities that improve the Team Foundation...

Configuring Visual Studio 2005 Team Foundation Server with Windows SharePoint Services 3.0: http://blogs.msdn.com/bharry/archive/2007/04/17/configuring-tfs-to-use-sharepoint-2007.aspx Reference: Brian Harry's blog --> http://blogs.msdn.com/bharry...

1. Export the exiting workitem type (xml) Syntax: witexport /f <filename>.xml /t < Team Foundation Server name > /p <project name> /n <WorkItem Type name> Example: witexport /f task.xml /t MyTFS /p MyProject /n Task 2...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1443311&SiteID=1

TeamPlain Web Access is now available as a free download < http://www.devbiz.com/teamplain/webaccess/download.aspx > to all Team Foundation Server customers. TeamPlain Web Access will be re-released as Team System Web Access as part of the Team...