Apr 12
17
BI Power View in SQL 2012
Power view seems awesome eventhough it uses Silverlight.
Contoso Energy Demo:
https://businessintelligencedemoportal.com/sites/contosoenergy/SitePages/pvrsample.aspx
More demos here: http://www.microsoft.com/en-us/bi/GetMicrosoftBI/TryIt.aspx
Posted in Analysis Services SharePoint by .
By default the Assigned To allows multiple selections that will not allow you to group by. Just set allow multiple selections to No and then you will be able to Group By Assigned To
Posted in General SharePoint by .
One of my developers was having an issue refreshing data using excel services in browser to Analysis Server 2008. It seems he added PowerPivot for excel that change some default connection string setting in excel. His connection string was generating “provider=MSOLAP.5;…” Which is not listed as a trusted provider in Excel Services.
Once i added MSOLAP.5 as a trusted provider, data refresh worked in browser!
Posted in Analysis Services Excel Services SharePoint by .
I found a great flowchart for troubleshooting data refresh in excel services for SharePoint 2010. I also ended up using the Secure Store instead of kerberos. I had a few issues connecting to OLAP, but this diagram helped. View PDF: Excel Services Troubleshooting
Posted in Authentication Excel Services SharePoint by .
One of my developers was getting a connection timeout on using an External Content Type. The real problem was that BCS has a limit of 2000 rows returned in a query. Here’s a PowerShell script to edit that limit:
$wthbcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $wthbcs
$BCSThrottle
Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000
Posted in BCS Services SharePoint tools and utilities by .
Oct 11
12
Download SharePoint 2010 Demo VM
SharePoint 2010 and Office 2010 Hyper-V VHD files are now available for download. It’s spit up in 23 files for SharePoint 2010. This includes Windows Server 2008 R2, SharePoint 2010, Office 2010, Visual Studio 2010, SQL Server 2008 R2. Theres 2 more VMs for Exchange and Communicator.
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27417
Posted in FAST Search SharePoint tools and utilities by .
SharePoint 2010 Profile sync services uses Forefront Identity Management services. To troubleshoot the sync process you can use Forefront Identity Synchronization Manager Client UI in:
[Install drive]:Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\miisclient.exe
This tool has so many details its hard to figure out at first. Once you click around you can find the AD mappings. This can also be used to sycn with other sources other than AD.
If you click on Management Agents, then Double click on MOSSAD-[domain], you can see the AD Mappings rules.
Once i create and test a new agent i will post the details.
Posted in Services SharePoint tools and utilities by .
If you notice People Search is still serverd by SharePoint enterprise search. FAST does not handle people search very well yet…
Posted in FAST Search SharePoint by .
Microsoft has a tool for scanning your farm and providng a detailed report on potential issues. You will need to have premier support for a rep to help you analyze the report. But any sharp admin can probably fix any issues.
Download scoping tool here: http://www.microsoft.com/download/en/details.aspx?id=13150
PDF with more details: