I am using CubeValue function to generate a report in Excel 2010.
The syntax is like -
G16 is =CUBESET(ConnectionName,CurrentYearYTDMonthSpan,Current_year)
Based on the user input, CurrentYearYTDMonthSpan is calculated based on the user parameter 'Last Month'.
[Date].[Broadcast Month].[All].[JAN 2013 (B)]:[Date].[Broadcast Month].[All].[APR 2013 (B)]
and the cube value function return #N/A.
Any inputs on this please, thanks in advance.
Sunny, is this still an issue?
Ed Price, SQL Server Customer Program Manager (Blog,
Answer an interesting question?
Create a wiki article about it!
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?