So it turns out that refreshing all reports on a dashboard may not provide you with the desired user experience; Content Editor to the rescue.
Add a Content Editor Control web part to your Web Page
First find the ID of the Refresh Button on on the SSRS webpart tool bar of the report to be refreshed; I used IE Developer tools to find the ID.
Once you have the ID, add the following script to the content Editor control and every 60 seconds the report gets refreshed.
<script type=”text/javascript”>
function refreshReport()
{
var btn = document.getElementById(“ID Goes Here“);
btn.click();
}
setInterval(‘refreshReport()’ ,60000);
</script>
Thank you Brian Keay for your post
http://briankeaybi.wordpress.com/2011/02/21/auto-refresh-ssrs-in-sharepoint-2010/
If you happened to find this post and were pulling your hair head like I was when you copied and pasted Brian’s code snippet and it did not work, try deleting the single and double quotations and retyping them in, stupid fonts. If you did not find Brian’s post I have included his code snippet below
<script type=”text/javascript”>
// The time out value is set to be 60,000 milli-seconds (or 60 seconds)
setTimeout(‘document.location=document.location’ ,60000);
</script>
Couple additional things to note.
1. you can save this script into a text file, store in a document library and point your content editor -> content link to the txt file
2. you can also type the script directly into the Content Editor HTML Editor, click in the content editor in edit page mode. You will see the Content Editor Ribbons. On the Format Text Ribbon there is a Markup section where you will find an option to edit HTML, type the script there.
Wait 60 seconds and voila, refresh
A giant thanks again to Brian
Have you ever wanted to re theme the Horizaontal Navigation section of SharePoint. 2010
below are the styles that can be modified in COREV4.css
found here (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\1033\STYLES\Themable)
body #s4-topheader2
.s4-tn li.static > .menu-item
.s4-toplinks .s4-tn a.selected
.s4-toplinks .s4-tn a.selected:hover
.menu-horizontal .menu-item-text
Please let me know if I have missed anything major.
Looks like the PPS team will be including a new cascading filter type with the SP1 release, really looking to seeing how it works.
link to PPS blog below with more details about SP1
http://blogs.msdn.com/b/performancepoint/archive/2011/06/07/what-s-new-in-performancepoint-services-and-sp1.aspx
A colleague of mine Alan Whitehouse blogged about SharePoint Lists as data sources for PerformancePoint Services, you can find his post here.
PerformancePoint Services, SharePoint Lists and Business Connectivity Services.
After reading his blog I was inspired to:
- Create a WCF web service that consumes the public Netflix oData feed
- Create a SharePoint External Content Type in SharePoint Designer
- Create an External Content List in SharePoint
- Use that list as a source for PerformancePoint Items
Below is the Result, a very simple visualization displaying the Movie, Short Synopsis and Netflix Url
