Question about the usage of "LookupCube"

#1

Hi! Everybody,

I have a question about using the "LookupCube".

I am using SQL Server 2000 to create my data cube. Now,I want to create a
calculated member in the virtual cube and the syntax is as follows:

LookupCube("Cube
Name","([Measures].[ABC],"+MemberToStr([Date].currentmember) +")")

I can view the result in development tool or write MDX query in MDX Sample
Application. However, when I view the result in Excel spreedsheet, the result
is "#Value". What happen to my Excel? Am I writing wrong MDX syntax?

Hope somebody can help me to solve this problem. Thanks!

Polly

#2

Hi Polly:

Instead of

MemberToStr([Date].currentmember)

try

[Date].CurrentMember.Name

Keep everything else the same.

- David Clem

Polly wrote:

Quote:

Hi! Everybody,

I have a question about using the "LookupCube".

I am using SQL Server 2000 to create my data cube. Now,I want to create a
calculated member in the virtual cube and the syntax is as follows:

LookupCube("Cube
Name","([Measures].[ABC],"+MemberToStr([Date].currentmember) +")")

I can view the result in development tool or write MDX query in MDX Sample
Application. However, when I view the result in Excel spreedsheet, the result
is "#Value". What happen to my Excel? Am I writing wrong MDX syntax?

Hope somebody can help me to solve this problem. Thanks!

Polly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Question about the usage of "LookupCube"

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Question about the usage of "LookupCube" - 06-16-2006 , 11:26 PM

Re: Question about the usage of "LookupCube" - 06-28-2006 , 07:10 AM