The link below gives a good description of the difference between SharePoint CU, PU and COD and recommendations for when they should be installed.
Category: Sharepoint
How to enable videos in SharePoint 2013
This blog post shows you how to enable video playback in SharePoint 2013.
In short you need to
- Activate “Video and Rich Media” feature at SiteCollection Level
- Delete the existing Asset library
- Create a new Asset library
Getting the CU for your SharePoint installation
The pages below shows you how to get information about the CU (Cumulative Update) for your SharePoint installation.
The first page shows you how to get information about the CU.
http://www.brightworksupport.com/find-your-sharepoint-cumulative-update-or-patch-level/
The second page shows you what CU you are using based on the information found through the first page.
http://blogs.technet.com/b/steve_chen/archive/2013/03/26/3561010.aspx
Opening PowerPivot data with Excel in Sharepoint 2010
It’s is not possible to use Excel through Sharepoint 2010 on PowerPivot data, if you are using a claims based authentication provider.
Although classic mode sign-in is not required for the more common data access scenario (where PowerPivot data is extracted from the same Excel workbook that renders it) do not attempt to use PowerPivot for SharePoint with SharePoint web applications that are configured to use other authentication providers. Doing so will result in a connection failure whenever users try to connect to PowerPivot workbooks as an external data source.
Source: http://msdn.microsoft.com/en-
If anyone has a solution to this please let me know by commenting this post.
One possible solution could be to use a third party OLAP-browser for example the freeware version of Ranet Uilibrary Olap or the commercial version of Ranet Uilibrary Olap.