Try to deploy using just the Database and not the instance.

So in other words, try this

Server = 'CFDB1

Database = 'ReportCube'

Let me know if this works.

~S

Can you post what your Target properties are, found under Project --> Pages. For eample mine shows

Server =

Database = ......

I believe if you are Local Admin on the machine itself, then you would be a server admin with SSAS.

If you are not in the server's Administrator group,...

Hmmm, I went to PASS last year and thought that SQLServerCentral already "owned" it ...;-) 😉

I tried your example - thanks for posting it! 🙂 However, my output is in the XML in the email sent and I understood the query results to be included...

I was able to get this working through the sample/help posted on MS forums here:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2042582&SiteID=17

HTH,

Shari

Can you share a sample of how you made this work using a function? I too am getting a date type conversion error and have to use a Date...