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 |
Excel cube functions
"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? -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. |
Excel cube functions
"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 |
All times are GMT +1. The time now is 04:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com