Open Data Protocol

OData Service for SQL Azure. Quick and easy way to demo a data feed from sql azure especially from PowerPivot. Here are some interesting links

https://odata.sqlazurelabs.com/OData.svc/v0.1/hqd7p8y6cy/AdventureWorks

http://www.odata.org/producers

Display children of parent automatically in a hierarchy in PPS

Not a new feature of PPS 2010, but one that is little known or used and is mighty cool. You can select a parent member in a hierarchy in say a filter, and the object (a scorecard or report) will automatically display all of the children members. All with one line of code in a connection formula <<UniqueName>>.Children

Here is my hierarchy

here is the connection formula

and the result. Notice I select a country and get all the provinces.

it works across the hierarchy. Here I select a province and get all the cities