Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CUBE Functions in Excel 2007
Hallo,
I do BI Reports with Excel 2007, and with the new CUBE-Functions (CUBEMEMBER, CUBEVALUE, ...) it works very well. With my knowledge now, I can only select normal values, for example with CUBEVALUE("Adventure Works", "[Measures].[Gross Profit]", "[Product].[Category].[Bikes]", "[Date].[Fiscal Year].[FY 2006]") the value for Gross Profit. How can I select Year-to-date Values (for example CUBEVALUE("Adventure Works", "sum(ytd(), [Measures].[Gross Profit])", "[Product].[Category].[Bikes]", "[Date].[Fiscal Year].[FY 2006]")??? With this syntax it doesn't work!). Many thanks for all help. Hans |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CUBE Functions in Excel 2007
Hans,
You cannot use expressions like sum(ytd(), [Measures].[Gross Profit]) in cube formulas. I think you have to create such a calculated member in the cube. Hope that helps Andreas Flockermann --- BonaVista Systems Charts Reduced to the Max! www.microcharts.net "Hans Preuer" wrote in message ... Hallo, I do BI Reports with Excel 2007, and with the new CUBE-Functions (CUBEMEMBER, CUBEVALUE, ...) it works very well. With my knowledge now, I can only select normal values, for example with CUBEVALUE("Adventure Works", "[Measures].[Gross Profit]", "[Product].[Category].[Bikes]", "[Date].[Fiscal Year].[FY 2006]") the value for Gross Profit. How can I select Year-to-date Values (for example CUBEVALUE("Adventure Works", "sum(ytd(), [Measures].[Gross Profit])", "[Product].[Category].[Bikes]", "[Date].[Fiscal Year].[FY 2006]")??? With this syntax it doesn't work!). Many thanks for all help. Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - MMULT | Excel Discussion (Misc queries) | |||
Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
Excel 2007 Beta Advanced Filter Performance | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) |