Server Calculated Members in Excel 2007

[Whitebear]

Hello!
I'm using Excel as OLAP browser of SSAS'2005 database. It is impossible for
me using CalculatedMembers.Add VBA technique to add my custom CM, because
this .Add method do not supports universal MDX language construction

With Member ... as ...

(I'm lack on MDX-based coloring and formatting functionality with .Add method)

So I have to declare calculated members in my Cube during it's design. I add
calculated members not to Measures, but into my Dimensions:

CREATE MEMBER MyCube.[My Dimension].[My Attributes].[All].MyMember as ...

So, my Excel users needs more than one report, and in one report some there
is need to visualize some calculated members, while in another report there
is need to visualize another members. But when I set the checkbox in pivot
table setup to show calculated members from SSAS, ALL members are shown
simultaneousely, and they are greyed in a list of dimension attribute
members, so I cannot uncheck one of them and leave only needed members. It is
a great problem for me. Is there any solution or workaround of my problem?

Thank you.
Dmitry Zholobov

 

[Jialiang Ge [MSFT]]

Hello Dmitry,

This a quick note to let you know that I am performing research on this
issue. In our internal log, I find some relevant reports, but I need to ask
for more information from the product team. I will get back to you as soon
as possible. Thank you for your patience.

Regards,
Jialiang Ge ([email protected], remove ¡®online.¡¯)
Microsoft Online Community Support

==================================================
For MSDN subscribers whose posts are left unanswered, please check this
document: http://blogs.msdn.com/msdnts/pages/postingAlias.aspx

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications. If you are using Outlook Express/Windows Mail, please make sure
you clear the check box ¡°Tools/Options/Read: Get 300 headers at a time¡±
to see your reply promptly.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided ¡°AS IS¡± with no warranties, and confers no
rights.

 

[Jialiang Ge [MSFT]]

Hello Dmitry,

I am still dicussing the issue with the product team members. The change
that the calculated members are greyed is introduced by SQL Server 2005
SP2. Based on our test, the calculated members can be partially selected in
Excel 2007 without SQL Server 2005 SP2. According to the notes logged by
the Excel product team when they design&developed Excel 2007, it is by
design to grey the calculated members. I am asking for the reason, and
trying to find workarounds for you. I will get back as soon as possible.
Thank you for the patience.

Happy New Year!

Regards,
Jialiang Ge ([email protected], 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.

 

[Jialiang Ge [MSFT]]

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 ([email protected], 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.

 

[Jialiang Ge [MSFT]]

Hello Dmitry,

Would you mind telling me if you have any other concerns? We will do our
best to help you.

Regards,
Jialiang Ge ([email protected], 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.