Cube [Cube1] has dimensions:
[Reporting Currency]
[Date]

Cube [CubeRate] has dimensions:
[Currency]
[Date]
and measure [Rate]"

[Date] is shared dimension between [Cube1] and [CubeRate], while
[Reporting Currency]
and [Currency] has the same date key.

What to is to define a calculated member in [Cube1] to get [Rate].
(Even I know there is intelligent way to get currency conversion in
SSAS2005, we decide to use separate cube to save the FX rate as
separated cube from product requirement)

////////STATEMENT ONE WORKS!
LOOKUPCUBE ("[CubeRate]", "([Measures].[Rate],
[date].[date].&[2005-11-30],
LINKMEMEBR([Reporting Currency].[Currency].&[CAD],
[Currency].[Currency]) " )

//////// STATEMENT TWO DOESN'T WORK!
LOOKUPCUBE ("[CubeRate]", "([Measures].[Rate],
[date].[date].&[2005-11-30],
LINKMEMEBR(" + [Reporting Currency].[CurrentMember]. UniqueName +
",
[Currency].[Currency]) " )

In run time, [Reporting Currency].[CurrentMember].UniqueName is
[Reporting Currency].[Currency].&[CAD]

The question is why STATEMENT TWO DOESN'T WORK, while the STATEMENT
ONE works? Can anyone please help me to figure out the reason?

Based on a similar Foodmart sample, this syntax works:

"([Measures].[Rate],[date].[date].&[2005-11-30],LINKMEMBER("
+ [Reporting Currency].CurrentMember.UniqueName
+ ",[Currency].[Currency]))")

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***