LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Excel cube functions

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/comm...et.f unctions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing cube functions (ie cubevalue) from VBA Jose B. Excel Worksheet Functions 0 September 27th 07 08:02 AM
suppress warning and locate cube in a pivot table from olap cube Tewari Excel Discussion (Misc queries) 0 March 28th 07 06:54 AM
CUBE Functions in Excel 2007 Hans Preuer Excel Worksheet Functions 1 January 6th 07 11:05 PM
Excel 2007 Cube access problems Mike L Excel Discussion (Misc queries) 5 October 10th 06 04:49 PM
What is the formula for cube root on Excel? tbh_29 Excel Worksheet Functions 3 July 5th 05 04:14 PM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"