Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Server Calculated Members in Excel 2007
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Server Calculated Members in Excel 2007
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 , 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/subscripti...ult.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/subscripti...t/default.aspx. ================================================== This posting is provided ¡°AS IS¡± with no warranties, and confers no rights. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Server Calculated Members in Excel 2007
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 , 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Server Calculated Members in Excel 2007
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Server Calculated Members in Excel 2007
Hello Dmitry,
Would you mind telling me if you have any other concerns? We will do our best to help you. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
default "Show calculated members from OLAP server" on in Excel 200 | Excel Discussion (Misc queries) | |||
Excel 2007 - Calculated Dimension Members Greyed Out | Excel Discussion (Misc queries) | |||
excel is connected to sharepoint server and says too many members | Excel Discussion (Misc queries) | |||
Excel 2007 problems with AS 2005 calculated members | Excel Discussion (Misc queries) | |||
Calculated Members from analysis services | Excel Discussion (Misc queries) |