I am extracting data form a cube using MDX and I want to obtain the foreign
key for the dimensions returned rather than the name. Is it possible to do
this.

Tom,

Try something like --

member measures.[Keyname] as '[Dimension].currentmember.key'

HTH,

Jim

"Tom M" wrote:

Using the MDX sample application ran the following against the Sales cube in
the Foodmart2000 sample
With MEMBER [Measures].[Product Key] as '[Product].CurrentMember.key'
Select NonEmptyCrossJoin([Promotion Media].Members, [Product].[Product
Family].Members) on rows,
{ [Measures].Members, [Measures].[Product key]} on columns
From Sales

In the Product Key column all that was displyaed was #ERR

"Jim_OLAP" wrote:

Tom,


With MEMBER [Measures].[Product Key] as
'[Product].CurrentMember.properties("ID")', solve_order=1

HTH,

Jim

"Tom M" wrote: