title: Why won't my SSAS Cube URL Action appear in Excel?
body: <p>I am working with a SSAS 2008 R2 OLAP cube and Excel 2010. I have set up a URL Action in the cube with a target type of Cells and a Target object of All Cells. When I have a hard coded URL in the Action Expression - for example <code>"http://stackoverflow.com"</code> everything works fine - that is to say that when I right click on a fact within an Excel 2010 pivot table rendering my cube I can see the Context Menu with additional actions and my URL action is there and it works.</p>
  
  <p>When I try to add any MDX to the action expression - for example        <code>"http://stackoverflow.com/" + [Measures].[DataValue]</code> (which should represent the fact I'm right clicking on) - there are no additional actions available.</p>
  
  <p>Can anyone suggest what I'm doing wrong, or how to diagnose the actual problem? I'm pretty sure that <code>[Measures].[DataValue]</code> should have data in it.</p>
  
  <p>Thanks.</p>