Azaz's blog

It's all about Microsoft SQL Server and Business Intelligence. Sharing my experience, views, learning and findings on SQL Server, SQL Azure, MS BI - SSIS, SSAS, SSRS, MDX, Proclarity and Sharepoint BI - Performancepoint Services, and Powerpivot. - raso

Parameterize OLAP Report using SP

A. Set a linked server (analysis server) in your SQL Server In the SQL Server Surface Area...

Author: Azaz Rasool Date: 12/04/2008

Dynamic Security in SSAS Cube

Technorati Tags: SSAS,Cube,Security,Dynamic Security,username,Analysis Services,SQL Analysis...

Author: Azaz Rasool Date: 08/14/2008

Parameterize the OLAP Reports in Client Applications

In this post let’s see how you can pass the parameters into your OLAP report. The parameters have to...

Author: Azaz Rasool Date: 08/14/2008

Populate Time Dimension of AdventureWorksDW Sample Database and use it in your Datawarehouse/cube

In one of my current data warehouse projects I wanted to use a time dimension. The time dimension...

Author: Azaz Rasool Date: 05/09/2008

Ways of Improving MDX Performance and Improvements with MDX in Katmai (SQL 2008)

  1. Use calculated members with Scope assignments instead of using IIF The reason this option is...

Author: Azaz Rasool Date: 04/30/2008

TFS Migration and Synchronization Toolkit

TFS Migration and Synchronization Toolkit is now available at...

Author: Azaz Rasool Date: 06/29/2007

TFS Guide - Know the effective usage of TFS in the real world constraints

This is awesome! A much needed thing has finally arrived. We have been getting request from customer...

Author: Azaz Rasool Date: 05/24/2007

Power Toys is now TFS Power Tool (Try it)

Microsoft Visual Studio 2005 Team Foundation Server Power Tool The Microsoft Visual Studio 2005 Team...

Author: Azaz Rasool Date: 04/30/2007

Configuring TFS to use Sharepoint 2007

Configuring Visual Studio 2005 Team Foundation Server with Windows SharePoint Services 3.0:...

Author: Azaz Rasool Date: 04/30/2007

Add New Tab/New Field in WorkItem windows

  1. Export the exiting workitem type (xml) Syntax: witexport /f <filename>.xml /t < Team...

Author: Azaz Rasool Date: 04/21/2007

Manage access permission of Team Projects in TeamPlain

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

Author: Azaz Rasool Date: 04/19/2007

Branching and Merging

Coming soon

Author: Azaz Rasool Date: 04/19/2007

Work with Team System over web

TeamPlain Web Access is now available as a free download <...

Author: Azaz Rasool Date: 04/19/2007