Tuesday, November 19, 2013

Datasource Menu disabled in Dashboard Designer

Are you trying to create a new performance point report but "Datasource" menu is disabled?

The reason of this behavior of absence of App "Dataconnection Library for Performancepoint" 

In order to create this app, Click on Site contents - > Add an App - > "DataConnections Library for PerformancePoint"

Once the App is added, "Datasource" menu will be available.

Monday, November 18, 2013

Unable to connect to SQL Server 2012 Analysis Services from Dashboard Designer (SharePoint 2013)

Are you trying to connect to SQL Server 2012 Analysis Cube using Performance point designer? Are you getting any errors? or it seems as if nothing is happening.

Probably your mind will having multiple thoughts  "What's the problem with this, i hate performance point , What should i even search in google without any error message" ............goes on and on and on

Well i had similar thoughts , till i came across an below article..( Thanks to Omicron)

PerformancePoint here isn’t using ADOMD.NET 11, the SQL Server 2012 version

Download and install  version 10 of ADOMD.NET installer which comes with the SQL Server 2008 R2

Wednesday, November 13, 2013

How To's SharePoint 2013 ( Apps)

Good samples for all the developers planning to start apps development in SharePoint 2013.


It probably might feel too much initially but taken a step at a time, makes it much easier to understand and fun to implement.


Apps are disabled on this site

Created an app and while  deploying the app to portal, visual studio threw and error with failed deployment.

Apps are disabled on this site

Good thing is there is lots of article our there to resolve this issue. In my case it was lack of basic configuration which needs to be performed before deploying the Apps.

Follow steps, mentioned in link below to avoid this error.

How to: Set up an on-premises development environment for apps for SharePoint

Enjoy Apps.


Friday, August 30, 2013

Expand VHD - Increase Capacity of Virtual Hard disk

well, i was stuck with 25 GB of in my virtual hard disk and started my favorite computer operation "Google" to find solution and surprisingly  found one pretty quickly

Here is goes.

Run below command sequentially in command prompt

diskpart                                    [open command prompt and type  this command]
Select vdisk file="Path of VHD"
list vdisk
expand vdisk maximum=40000                    [Size in MB]
attach vdisk
list disk
Online Disk
list volume
select volume                         [Select disk volume to be exteded]
List Volume
detach vdisk

Wednesday, July 17, 2013

SPHierarchyDataSourceControl changes is not reflecting in tree view control

You get a simple requirement
Hide some of the components from Tree view control of SharePoint 2010. ( Though hiding specific items is still not supported out of box and you probably will have to use custom tree view control)

Make changes to master page specifically to node "SPHierarchyDataSourceControl "

You can add following properties:

You make changes and refresh page to see the change and to your surprise tree view doesn't change at all and still showing all components. Now you feel changes in your blood pressure and probably thinking what shoud i do next ....

Well probably if you find this article you will save some some of artery damage due to high pressure :-).

Details are give in below link

In nutshell, SharePoint 2010 feature(Metadata Navigation and Filtering Feature)  generally overrides your master page settings, To get this working change the ControlId of Delegate Control that wraps the SPHierarchyDataSourceControl from TreeViewAndDataSource to    TreeViewAndDataSourceCustom.


Friday, May 24, 2013

People Picker Control - SharePoint 2010 ( Customizing Search Results)

For customizing search results in people picker configured for Windows Authentication in Classic Mode or claims mode check below link

To customize search results in people picker configured in different authentication mode, you need to define custom claims provider:

Thursday, May 23, 2013

WSS_Logging DB SharePoint 2010 ( Usage Reporting)

SharePoint 2013 is out  but i still get the queries regarding the usage reporting capability of SP 2010.

Some pointers below.

  • The data displayed by SharePoint Web Analytics is pulled from "WSS_Logging" database. It aggregates all of the raw logging data accumulated in the text files under the 14 hive and imports it into logging database. 

  • Web Analytics Service Retention Policy 

          To persist the usage data in WSS_Logging for longer time you can change the retention policy
           by  changing the settings in central administration

          Central Administration - > Application Management - > Manage Servcie Application
          - >Select Web Analytics Service ->Click "Properties" in ribbon ->Change Data Retention
          Period up  to 25 months.

  • The data import from Logs files to Database is performed by Timer Job " Microsoft SharePoint Foundation Usage Data Import"
         You can set the frequency of timer job depending on load on your server.

  • More Information on Logging DB can be found at : 


Wednesday, May 01, 2013

Implementing SharePoint DR (SQL Server Log Shipping Method)

Great article on SharePoint DR implementation using SQL Server Log Shipping.


Thursday, April 18, 2013

TagCloud Webpart not available SharePoint 2010

Do you feel like breaking your head is less painful than looking for Tagcloud webpart ?.

Well than don't worry your head is probably safe is you haven't yet given  up searching :-)

Just Activate the PortalLayouts feature

stsadm -o activateFeature -name "PortalLayouts" -url "http:///sites/" -force

Wednesday, April 17, 2013

Usage Data Retention in SharePoint Database - SharePoint 2013

Check the current retention policy using :

By default it's 14 days.

To change the retention use the following script:

Set-SPUsageDefinition -Identity "Page Requests" -DaysRetained 31

Complete definition of this command can be found at :

Wednesday, March 27, 2013

SharePoint 2010 WSP BackUp

Simple script but very helpful considering the fact that it's easy to mess up and than end up trying to find  old WSP in your source control tool. (If your team has been updating the source control :-)).

Always take WSP backup from SharePoint Farm before you deploy revised one.

$farm = Get-SPFarm
$file = $farm.Solutions.Item("{WSPNAME}.wsp").SolutionFile


Friday, February 15, 2013

Claim Based Security explained in real simple way

Check this article if you are trying to understand claims based security

Sunday, February 10, 2013

Office Web Apps and SharePoint Services(Excel, Word, Powerpoint Services)

I always get queries from peers and clients on difference between SharePoint 2010 and Office Web Apps. They are completely different component. Office Products have tight integration with SharePoint using the Office Web Apps feature installed in SharePoint.

Note : You can run Office Webs Apps using Office Web Apps server even if you do not have SharePoint in your organization.

Useful Links:

Office Web Apps:

Office Web App Server Planning:

Office Web Apps Deployment :

Office Web Apps platform comparison

Excel Services vs Excel Web App


Tuesday, January 15, 2013

Detect Content DB orphans and delete in a SharePoint 2010 Farm thru Windows PowerShell

Detect orphans in Content DB:

if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) 
     {Add-PSSnapin Microsoft.SharePoint.Powershell}
       set-location "C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN"
         $SPFarm = Get-SPFarm
           $contentWebAppServices = (Get-SPFarm).services | ? {$_.typename -eq "Microsoft SharePoint Foundation Web Application"} 

               foreach ($SPWebApp in $contentWebAppServices.WebApplications)
                   foreach ($SPSite in $SPWebApp.Sites)
                       Write-Host "Going thru Site Collection" $SPSite.Url
                         $SPSite.Url >> C:\SPSiteOrphanObject.txt
                           stsadm.exe -o databaserepair -url $SPSite.Url -databasename $SPSite.ContentDatabase.Name >> C:\SPSiteOrphanObject.txt
                              • To delete orphan objects from a particular site use following script 
                              if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) 
                               {Add-PSSnapin Microsoft.SharePoint.Powershell}
                               set-location "C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN"
                              stsadm.exe -o databaserepair -url -databasename  >> C:\SPSiteOrphansDelete.txt

                              • You can get the Content DB of a particular site collection using below script
                              write-host $site.ContentDatabase.Name

                              Gray Failures: What is it and how to detect one?

                              If you are reading this article , i guess you are curious to know about gray failures and different methods to detect gray failures.  Hopefu...