Excel cube functions

[Joerg]

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
...

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

-properties should return standard properties(e.g. level, ordinal) as well.


Thank you very much for listening

Jörg


P.S: I like all the new BI features in 2010; the slicer! Power Pivot! Great!









----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Bob Phillips]

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?

-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.

 

[Joerg]

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}

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.

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