Has anyone been successful in creating a cube file using XMLA?

In Management Studio I ran an MDX query that completed successfully:

CREATE GLOBAL CUBE [Test]
STORAGE 'c:\cube\test3'
FROM [Adventure Works DW]
(MEASURE [Adventure Works DW].[Average Rate],DIMENSION [Adventure Works
DW].[Dim Currency],DIMENSION [Adventure Works DW].[Dim Time])

I then tried the same query in XMLA, and received errors:

<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
<Command>
<Statement>
CREATE GLOBAL CUBE [Test]
STORAGE 'c:\cube\test3'
FROM [Adventure Works DW]
(MEASURE [Adventure Works DW].[Average Rate],DIMENSION [Adventure
Works DW].[Dim Currency],DIMENSION [Adventure Works DW].[Dim Time])
</Statement>
</Command>
<Properties>
<PropertyList>
</PropertyList>
</Properties>
</Execute>

Response was:

Executing the query ...
CREATE GLOBAL CUBE statement. FILENAME|c:\cube\test4|DDL|
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance

......

Execution complete

I would like to create cube files using XMLA, but looks like I'm going to
have to resort to msolap.3

You can't do this with XMLA. Creating a local cube requires local machine
activity which obviously an XMLA request cannot handle. The error raised
below is handled by OLE DB or ADOMD.NET to actually create the local cube.

Thanks,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Lance A" <Lance A (AT) discussions (DOT) microsoft.com> wrote