Microsoft Business Intelligence by Nishant

This Blog is a collection of Tips and Articles about Microsoft BI Tools :SQL Server ,SSAS,SSRS,SSIS,PPS 2010,PowerPivot,SharePoint 2010

Filter Performance Point Services 2010 dashboard using QueryString Filter in SharePoint 2010

Passing QueryString in a web url is old method .This can also be done in SharePoint 2010. The steps...

Author: Nishant SQL BI Date: 01/04/2011

Performance Point Services 2010 Limitations

Following are the major limitations of PPS 2010 : Can't sort stack bar Analytical charts out of box....

Author: Nishant SQL BI Date: 12/23/2010

Importing PerformancePoint 2007 Content to PPS 2010 Using the Import Wizard

PerformancePoint 2010 comes with a migration tool that allows you to import your 2007 dashboard...

Author: Nishant SQL BI Date: 12/11/2010

How to find location of database files(.mdf,.ldf etc .)

Run the following query SELECT SUBSTRING(physical_name,...

Author: Nishant SQL BI Date: 12/08/2010

Reporting Services(SSRS) Reports deployment using batch file(command line)

Create a batch file SSRS_Deployment.bat which will contain following code : @Echo Off for /f...

Author: Nishant SQL BI Date: 12/08/2010

SharePoint Master Page editing

Hidding Left Navigation and Status Bar in SharePoint 2010 : Add this css style under head tag of...

Author: Nishant SQL BI Date: 11/21/2010