Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pravin14u
Posting Yak Master
246 Posts |
 Posted - 2007-06-26 : 08:51:45
|
| Hi All,I am trying to access a SSAS cube from Excel 2007 using CUBEVALUE() function. When i try to give two memebers of the same dimension (In the following example I have used 2 members of Status dimension - Complete, Done), its giving me an error.When I just use a single member from each dimension, I could get the value.--Following results in error=CUBEVALUE("Cutlass_UK",$A$3,$A6,B$4,"[Status].[Status].[All].[Done] ","[Status].[Status].[All].[Complete] ","[Daily Record].[Daily Record].[All].[Working Day]")Any ideas?Thanks, |
|
|
|
|
|
SSAS with Excel 2007