Action visible in BIDS but not in Excel 2010

• Jonathan Mallia

  SSCertifiable

  Points: 5192

  More actions

  June 22, 2012 at 8:35 am

  #392586

  Hi all,

  I have created an SSAS Action in my cube, deployed the action, and tested in cube browser. Everything works great in cube browser.

  However, when query the cube from Excel 2010, the Action is not visible.

  Anyone has a clue of why this strange behaviour?

  Thanks in advance for your suggestions.

  Jon

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  June 25, 2012 at 3:06 am

  #1504943

  Strange answer by a MS employee:

  Whether to support this kind of feature depends on your client display tool, PivotTable support this kind of feature, but Excel workbook does not have this feature, thanks for your understanding.

  http://social.msdn.microsoft.com/Forums/en-IN/sqlanalysisservices/thread/6532d0ea-fa97-494e-b188-747e5e1d38ee

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP