<div>
I can get now the results I require in Management Studio using this :-<br />
with member [Date].[date time].[wibble] as <br />
&nbsp;aggregate({[date].[date time].&amp;[2009-03-11T00:00:0<wbr />0]:[date].<wbr />[date time].&amp;[2009-03-11T00:00:0<wbr />0]}) <br />
&nbsp;select [date].[date time].[wibble] on columns,<br />
&nbsp;[measures].[consignment count] &nbsp;on rows<br />
from [MyCube]<br />
<br />
but I can't find a way to get an aggregate function into the Cubevalue parameters in Excel.
</div>


I can get now the results I require in Management Studio using this :-
with member [Date].[date time].[wibble] as
 aggregate({[date].[date time].&[2009-03-11T00:00:00]:[date].[date time].&[2009-03-11T00:00:00]})
 select [date].[date time].[wibble] on columns,
 [measures].[consignment count]  on rows
from [MyCube]

but I can't find a way to get an aggregate function into the Cubevalue parameters in Excel.

<div>
Thanks for the response, although it wasn't the one I was hoping for!<br />
I suspect that this requirement wont go away, and that I'll be looking for a solution again soon.<br />

</div>


Thanks for the response, although it wasn't the one I was hoping for!
I suspect that this requirement wont go away, and that I'll be looking for a solution again soon.


<div>
<div class="content wysiwyg-content">
Hi Everyone,<br />
I'm using the CUBE functions in Excel to query my SSAS cube.<br />
I have a CUBEVALUE function and I'm trying to get the value of a measure for a specific date range, like this:-<br />
<br />
=CUBEVALUE(&quot;jago&quot;,&quot;({[date<wbr />].[date time].&amp;[2009-03-12T00:00:0<wbr />0]:[date].<wbr />[date time].&amp;[2009-03-13T00:00:0<wbr />0]})&quot;,&quot;[Me<wbr />asures].[C<wbr />onsignment<wbr /> Count]&quot;)<br />
<br />
but all I get is N/A.<br />
<br />
However, if I change the second date to be the same as the first, the query returns the correct answer for 2009-03-12.<br />
Any Ideas? I'm quite new to MDX, so I guess I've made a newbie error!
</div>
</div>


Hi Everyone,
I'm using the CUBE functions in Excel to query my SSAS cube.
I have a CUBEVALUE function and I'm trying to get the value of a measure for a specific date range, like this:-

=CUBEVALUE("jago","({[date].[date time].&[2009-03-12T00:00:00]:[date].[date time].&[2009-03-13T00:00:00]})","[Measures].[Consignment Count]")

but all I get is N/A.

However, if I change the second date to be the same as the first, the query returns the correct answer for 2009-03-12.
Any Ideas? I'm quite new to MDX, so I guess I've made a newbie error!

MDX Date Range in Excel

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.