Hello Dmitry,

According to the response of the product team, the calculated members are
greyed due to the lack of support for calculated members in sub-selects in
Analysis Service 2005. However, the team is planning to address this
problem with the next version of Excel and SQL Server, Analysis Service
2008. We failed to find any workaround for the current versions. I am sorry
we cannot help you with this issue but If there is anything else I can do
for you, please feel free to let me know. Thank you for your understanding.

Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.