I'm trying to create multiple dimensions in an SSAS 2005 database through one
XMLA script file in an XMLA Query window in Management Studio. I have
generated the <Create>...</Create> commands and confirmed that each one
executes correctly individually. However, when I paste them into the query
window one right after the other and attempt to run the file, I get an error
that claims only one <Create> command can appear:

"The 'Create' element at line 58, column 76
('http://schemas.microsoft.com/analysisservices/2003/engine' namespace)
appears more than once under Envelope/Body/Execute/Command."

If I understand the documentation on the Create element correctly, you can
have more than one such element within the <Command> </Command> element:

"0-n: Optional element that can occur more than once."

Anyone have an ideas on how to make this work? I'm trying to create 790+
dimensions, so I'd sure like to avoid executing each script manually.

You need to use a Batch element to "batch" the commands together.

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.

"Bob H." <BobH (AT) discussions (DOT) microsoft.com> wrote

Wrap all of them in a
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

......

</Batch>

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights


"Bob H." <BobH (AT) discussions (DOT) microsoft.com> wrote

Thanks, Akshai! Unfortunately I've already tried wrapping my create elements
in the <Batch>...</Batch> tags but it still did not work. It complained that
I could not nest a <Batch> element inside <Command>...</Command> elements.

I wonder if this is a bug?
--
Bob Hodgman


"Akshai Mirchandani [MS]" wrote:

No, this most definitely works -- we use this all the time

Can you post the exact snippet of DDL and the error message you got back.
Perhaps you didn't use the correct namespace or something like that...

Take a look at
http://msdn.microsoft.com/library/de...asprocarch.asp
for examples on the usage of the Batch element (although its all about
Process operations it works the same for Create).

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.

"Bob H." <BobH (AT) discussions (DOT) microsoft.com> wrote

I did not include the namespace! When I included the namespace, it worked
like a charm. Thanks!
--
Bob Hodgman


"Akshai Mirchandani [MS]" wrote:

Bingo! Adding the namespace did the trick. Thanks, Edward!
--
Bob Hodgman


"Edward Melomed [MSFT]" wrote: