So it appears that Power View (RC0) doesn't recognize hierarchies that are built in PowerPivot... I'll double check to see if it works from an actual BISM but I'm not optimistic..
Power View in SQL Server 2012 RTM doesn't support hierarchies in the model, but we hope to close that gap as soon as we can.
Program Manager, SQL Server Reporting Services
Proposed As Answer byDan EnglishMVPTuesday, March 20, 2012 11:27 AM
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.