SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

Hi,

I am new with MDX and new some help ...

I have 3 integer fields that represent a date (day , month , year).
I need to return on the query a single result with datetime type.

eg, SQL syntax:

y=2012
m=10
d=15

select cast(rtrim(y*10000+m*100+d) as datetime)

Hi IdoD,

You can reference the excel vba reference like this

with
member [measures].[defined_date] as vba.dateserial(2010, 11, 13)
select
[measures].[defined_date] on 0
from [adventure works]

HTH

Paul
www.paultebraak.wordpress.com