How to Refresh a Cached Excel Services Report

This post doesn’t so much describe how to do something as why you shouldn’t worry about something you may see. It can be unnerving to make a change in a SharePoint object, then not see the change when you check for it. Here is a case where there is an explanation for that behavior. Here…


Conversations with data in analytic charts

Today’s post is by Jason Robertson, showing some ways to have a conversation with data using analytic charts in PerformancePoint Services for SharePoint 2010. I built a simple model using Bureau of Transportation‘s Airline On-Time Performance and Causes of Flight Delays and let Jason to go hunting. He built the initial chart using Dashboard Designer…


Analytic charts & grids in PerformancePoint Services

Analytic charts & grids are interactive visualizations rendered by PerformancePoint Services for SharePoint 2010. They let users drill down, across, and through any hierarchy in the model: hook it up to an Analysis Services database or PowerPivot model, define the initial layout, and you’re done. There’s nothing more to do to enable this interactivity. Here’s…

24

Integrating Trend Charts in Dashboards

After you have created your trend charts (see the trend chart creation blog here), you can use them in a dashboard.  The trend chart needs to be connected to the scorecard which it is based on in the dashboard designer, linked via the KPI ID to the Row Header in the Trend Chart as follows:…

4

Adding a Target Line to an Analytic Chart

If you want to add a constant line to an Analytic chart, such as a “Target” line, you can do it by adding a calculated measure to the query as described below:         1.       Create your view as you normally would using the Dashboard Designer 2.       Switch to the “Query” tab, and…

3