SSAS 2005 + Excel 2007 - how to create calculated measure based on formula

In previous Excel version (2003) I was able to create calculated measure using MDX. In new Excel (2007) this feature seems to be disabled - "Options"->"Formulas" button is disabled for SSAS 2005 connection. Anyone knows how can I create calculated measure from Excel using MDX?

Thank you,

Vidas Matelis

[347 byte] By [VidasMatelis] at [2008-1-1]

SQL Server

Site Classified