"Bob Phillips" wrote:


"Joerg" wrote in message
...
Hello,

i really like or to be honest i am excited about the cube functions in
excel 2007 and excel 2010.

I can't wait to create workbooks with these formulars and publish them
in Excel Services.

I am missing 3 things(in order of priority)

-a built in function called mdx(): should return the unique name of an
element
function mdx(r as range)
mdx = r.mdx


Doesn't CUBEMEMBER effectrively give you this?

Unfortunelty not. Cubemember gives the caption.
but i want to concenate the the member unique name to create a dependant
set:

cubemember = smith
uniquename = [Customers].[smith].&[123456]

{[customers].[smith].&[123456].children}





-if cubevalue returns null the cell should contain nothing; yet an empty
string
will is returned.


=IFERROR(CUBEVALUE(...),"")


-properties should return standard properties(e.g. level, ordinal) as
well.
I don't understand that one.


.



Doesn't CUBEMEMBER effectrively give you this?

Unfortunelty not. Cubemember gives the caption.
but i want to concenate the the member unique name to create a dependant
set:

cubemember = smith
uniquename = [Customers].[smith].&[123456]

{[customers].[smith].&[123456].children}


=IFERROR(CUBEVALUE(...),"")

if cell c6 contains an empty string the formula C6+5 returns an error.

-properties should return standard properties(e.g. level, ordinal) as
well.
I don't understand that one.

currently i can query custom properties like gender for smith
but not instrinct properties like the key of smith


Thank you for listening