Using a XMLA to generate reports

hi,

I am trying to join a cube that is deployed to XMLA using Deployment Wizard with a report template i created using reporting services 2005 but could not figure how to join the XMLA query (SSMS 2005) of a cube and the report template (SSRS 2005) made. I am hoping the readers could provide some info or some link to where the procedure is explained?

The results obtained wen i executed the XMLA query using SSMS 2005 object explorer:

<return xmlns="urn:schemas-microsoft-com:xml-analysis">
<results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">
<root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" />
<root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" />
</results>
</return>

Thanks,

Somu

[1046 byte] By [SomuThomas] at [2007-12-25]

SQL Server

Site Classified