Tuesday, February 19, 2013

Excel graph look and feel issue- PowerPivot

Issue
Graph available in excel not looks fine while opening through web browser. Some of the Vertical line missed. The same graph works fine if it is opened with excel instead of web browser.
Resolution:
After a long research I found that the feature needs to be activate one feature at site collection and site feature:
I enabled once again the feature at "site feature" and "Site collection feature":
SharePoint Server Enterprise Site features
Features such as Visio Services, Access Services, and Excel Services Application, included in the SharePoint Server Enterprise License.

Please note: The excel graph view in web browser will be a problem for existing files but working for new files with same content.

UPA in SharePoint 2010

User profile service application:
We must have SharePoint standard or enterprise edition, An instance of the managed metadata service must exists, A managed path exists, My site application pool exists, A site collection taht uses the My site host template exists, June 2011 CU update or later. With out this update the UPA Db cannot be restored. Add UPS service account in Managed accounts through Central Admin.
Should have service account for sync, it should have managed replicate permission at AD.

Create UPA:
Manage service application --> Create new --> Click User profile service application --> Enter the name of new application --> Enter the name of new App pool --> Select Security account for this app pool --> Enter Profile DB name and SQL server name, Authentication would e windows Authentication --> Enter Sync DB, SQL server name and windows authentication --> Social DB, SQL server and windows authentication --> My Site Host URL --> Type - My Site Managed Path --> Enable Self site creation for the Web application that hosts My Sites--> Site naming format would be best to select Domain and user name(will not conflict)

Enter the Sync settings in UPA, set the sync timings.
Set the credential at both the Forefront Identity Manager services in services console as Sync account.

Start the full sync at every change in sync connection.
Set the netBios name =1 if netbios have different name FQDN