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