We currently use DSO to process all of our AS2000 cubes.

I've been given the chance to mess with 2005 for a few weeks which means
I'll need to rewrite the code. What do I have to rewrite it in? Any tips in
rewriting it?

I apologize for the basic question!

you can easely schedule XMLA commands using the new SQL Agent.
(I think there is a command line tool to do the same job)

go to your AS2005 server, create some XMLA commands (try to use the
templates (view --> template explorer) or do the operation by saving it into
a script file instead of executing it)
you can save the command as an XMLA file or schedule it directly etc...

its easy and this works fine!
bye bye security, context and other monothread issues!!!
welcome XMLA commands!

good luck!

Jerome.


"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Hi,

Where can I get full list of the possible XMLA commands?

Thanks,
Vladimir

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> schrieb im Newsbeitrag
news:O1HSwbM5FHA.884 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Hi Vladimir,

Here is a very good article from T. K. Anand - Microsoft Corporation that
has great deal of info on XMLA processing commands. Hope you find it helpful.
We can ask T.K for consolidated list of XMLA Commands and how to run these
through Integration Services. Unfortunately i do not have his email address.
Please let me know if you find any further info on this as i am also in the
same boat.

MSAS 2005 Processing Architecture:

http://msdn.microsoft.com/library/en...asprocarch.asp

Thanks,

Prasad.

The XMLA reference can be found at:
http://msdn2.microsoft.com/en-us/lib...S,SQL.90).aspx

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote

As Jerome had noted, if you are referring to the DSO portion to create OLAP
cubes, dimensions, objects, etc. - one of the best routes is to do the XMLA
route.

As well, if you are using DSO more for the processing of OLAP objects, note
that the AMO object model and DSO object model are quite similar. To get a
quick crash course on the AMO model, install the AMOAdventureWorks sample
with Yukon. In the C:\Program Files\Microsoft SQL
Server\90\Samples\Analysis Services\Programmability\AMO\DisplayObjectNames
(default location), there is the DisplayObjectNames sample that shows how
you can go through the AMO object model to view the database, cube,
dimension objects.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Thaks, Denny

It's waht I need.

Vladimir Chtepa

"Denny Lee" <dennyglee (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:efrElXV5FHA.2364 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

How does AMO interact with XMLA?

Basically my DSO code does more than create and process cubes. It pulls data
from status tables, inserts, ect.


"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote

Actually, you can do quite a few things in both XMLA and in AMO. In
general, I find that I will build the OLAP objects via XMLA while process
and deploy the cubes (reading the XMLA file) using the AMO. There are
multiple ways of doing this so its not like you have to do it this way. But
in general, this is probably the easiest way.

A really good explanation is within Project REAL at:
http://www.microsoft.com/technet/pro.../realpart.mspx

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote