can OLAP object be scripted?

#1

Hello,

I am just starting out using Analysis services and have been following along
with the tutorial that comes with Sql Server. In an effort to learn how to
create OLAP objects from script (from Query Analyzer), I would like to script
my OLAP objects, like cubes, dimensions, etc. Is it possible to do this the
way you can script tables, stored procedures, user defined functions, etc
from Enterprise Manager?

While I am at it, I need to learn the MDX query language. I have already
ordered a book from Microsoft on Analysis Services Step By Step (don't have
it yet). May I request if someone could share a sample script (a simple
one) agains tables from a sql Server DB? The tutorial uses the MS Access
Foodmart2000.mdb file. I need to create a cube from a Sql Server DB. Any
assistance greatly appreciated.

Thanks,

Rich

#2

AS2005 provides some wizards and this job can be done using it.
AS2005 scan the relationships of your objects and recommands measures &
dimensions.

in AS2000, you have to do the job by your self.
you can also create scripting commands (DSO commands) but this is a huge
work, do it by yourself using the MMC interface is recommanded.

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

Quote:

Hello,

I am just starting out using Analysis services and have been following
along
with the tutorial that comes with Sql Server. In an effort to learn how
to
create OLAP objects from script (from Query Analyzer), I would like to
script
my OLAP objects, like cubes, dimensions, etc. Is it possible to do this
the
way you can script tables, stored procedures, user defined functions, etc
from Enterprise Manager?

While I am at it, I need to learn the MDX query language. I have already
ordered a book from Microsoft on Analysis Services Step By Step (don't
have
it yet). May I request if someone could share a sample script (a simple
one) agains tables from a sql Server DB? The tutorial uses the MS Access
Foodmart2000.mdb file. I need to create a cube from a Sql Server DB. Any
assistance greatly appreciated.

Thanks,

Rich

#3

In article <uoAGbQ#5FHA.3136 (AT) TK2MSFTNGP09 (DOT) phx.gbl>,
willgart (AT) BBBhotmailAAA (DOT) com says...

Quote:

in AS2000, you have to do the job by your self.
you can also create scripting commands (DSO commands) but this is a huge
work, do it by yourself using the MMC interface is recommanded.

There are some third party tools that will do this for you, but I
believe their scripts is proprietary and are not interchangeable between
the tools. AS2k does not support native XML/A scripting like AS2k5
does.

There is a list of some of those tools here
http://www.mosha.com/msolap/util.htm#Metadata

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

#4

Thanks for the links. Very useful.

Rich

"Darren Gosbell" wrote:

Quote:

In article <uoAGbQ#5FHA.3136 (AT) TK2MSFTNGP09 (DOT) phx.gbl>,
willgart (AT) BBBhotmailAAA (DOT) com says...

in AS2000, you have to do the job by your self.
you can also create scripting commands (DSO commands) but this is a huge
work, do it by yourself using the MMC interface is recommanded.

There are some third party tools that will do this for you, but I
believe their scripts is proprietary and are not interchangeable between
the tools. AS2k does not support native XML/A scripting like AS2k5
does.

There is a list of some of those tools here
http://www.mosha.com/msolap/util.htm#Metadata

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

#5

For AS2K, we shipped this unsupported utility called DSO/XML
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Quote:

AS2005 provides some wizards and this job can be done using it.
AS2005 scan the relationships of your objects and recommands measures &
dimensions.

in AS2000, you have to do the job by your self.
you can also create scripting commands (DSO commands) but this is a huge
work, do it by yourself using the MMC interface is recommanded.

"Rich" <Rich (AT) discussions (DOT) microsoft.com> wrote in message
news:B4FDB990-8E0F-436C-AF1B-FC1534D9EE43 (AT) microsoft (DOT) com...
Hello,

I am just starting out using Analysis services and have been following
along
with the tutorial that comes with Sql Server. In an effort to learn how
to
create OLAP objects from script (from Query Analyzer), I would like to
script
my OLAP objects, like cubes, dimensions, etc. Is it possible to do this
the
way you can script tables, stored procedures, user defined functions, etc
from Enterprise Manager?

While I am at it, I need to learn the MDX query language. I have already
ordered a book from Microsoft on Analysis Services Step By Step (don't
have
it yet). May I request if someone could share a sample script (a simple
one) agains tables from a sql Server DB? The tutorial uses the MS Access
Foodmart2000.mdb file. I need to create a cube from a Sql Server DB.
Any
assistance greatly appreciated.

Thanks,

Rich

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

can OLAP object be scripted?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

can OLAP object be scripted? - 11-12-2005 , 03:05 PM

Re: can OLAP object be scripted? - 11-12-2005 , 05:52 PM

Re: can OLAP object be scripted? - 11-13-2005 , 05:34 PM

Re: can OLAP object be scripted? - 11-14-2005 , 03:51 AM

Re: can OLAP object be scripted? - 11-19-2005 , 10:00 PM