Excel计算成员 [英] Excel Calculated Members

问题描述

我使用的是Excel 2007 SP2和SSAS 2008 R2 10.50.2500.0。

I'm using Excel 2007 SP2 and SSAS 2008 R2 10.50.2500.0.

我有一个数据透视表连接到SSAS多维数据集，并在此多维数据集中调用了一个二元组[Dim Ledger Entry]。[Doc Code]。通过VBA我将计算成员添加到此维度：

I have a pivot table connected to a SSAS cube, and within this cube a dimesion called [Dim Ledger Entry].[Doc Code]. Via VBA I am adding a calculated member to this dimension:

 

pt.CalculatedMembers.Add Name:="[Dim Ledger Entry].[Doc Code].[Test]", Formula:="[Dim Ledger Entry].[Doc Code].[CASH]", Type:=xlCalculatedMember

 

所以我只是试图创建一个与现有成员相同的计算成员作为测试。

So I'm just trying to create, as a test, a calculated member which is identical to an existing member.

从SQL分析器我可以看到针对SSAS的mdx包括：

From the SQL profiler I can see the mdx fired against SSAS includes:

 

CREATE SESSION MEMBER [Coda Stage].[Dim Ledger Entry].[Doc Code].[Test] AS [Dim Ledger Entry].[Doc Code].[CASH]

 

并且：

 

SELECT NON EMPTY Hierarchize(AddCalculatedMembers({DrilldownLevel({[Dim Ledger Entry].[Doc Code].[All]})})) ...

 

正在运行mstudio中的这个mdx我可以看到我的[Test]计算成员，但它没有出现在Excel中（我勾选了方框"显示计算成员来自OLAP服务器"）。

On running this mdx in mstudio I can see my [Test] calculated member, but it does not appear in Excel (and I have ticked the box "Show calculated members from OLAP server").

创建计算度量的类似测试工作正常，但我无法理解为什么计算维度成员不会出现。请帮忙！

A similar test to create a calculated measure worked fine, but I cannot understand why calculated dimension members don't appear. Please help!

 

谢谢，

Charles

推荐答案

嗨Charles，

Hi Charles,

我们正在研究这个问题。响应可能会有一些延迟。感谢您的耐心等待。

We are doing the research about the problem. There might be some delay about the response. Appreciate your patience.

最诚挚的问候，

这篇关于Excel计算成员的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！