Re: Running Create global cube Mdx queries in XMLA - Analysis Server 2
- From: "Akshai Mirchandani [MS]" <akshaim@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 23 Jan 2006 11:48:24 -0800
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C406CF52-5CAF-4111-A18C-3FF6E34F8C22@xxxxxxxxxxxxxxxx
> 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
.
- Prev by Date: Re: Object Model for MDX queries?
- Next by Date: Re: XML for analysis services
- Previous by thread: Whats is wrong with this query?
- Next by thread: Re: Implementing ProcessAdd on a Dimension
- Index(es):
Relevant Pages
|
