Extract query from cube

#1

Hi,

Is there a way to extract the query out of a cube, just like when you are
right clicking on a table/view in SQL Server and with menu "All
Tasks\Generate SQL Script" you can create the sql script which you can run an
it creates the table/view for you.
If not, anyone can provide me a sample script or point me to a resource of
how to create a cube in code?

Thnx

Stanley

#2

Creating a cube in code is done using Decision Support Objects (DSO) - an API
for administering Analysis Services.

Regards
Jamie Thomson
http://www.conchango.com

"Stanley" wrote:

Quote:

Hi,

Is there a way to extract the query out of a cube, just like when you are
right clicking on a table/view in SQL Server and with menu "All
Tasks\Generate SQL Script" you can create the sql script which you can run an
it creates the table/view for you.
If not, anyone can provide me a sample script or point me to a resource of
how to create a cube in code?

Thnx

Stanley

#3

Use meta scripter utility from sql server resource kit.

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

Quote:

Hi,

Is there a way to extract the query out of a cube, just like when you are
right clicking on a table/view in SQL Server and with menu "All
Tasks\Generate SQL Script" you can create the sql script which you can run
an
it creates the table/view for you.
If not, anyone can provide me a sample script or point me to a resource of
how to create a cube in code?

Thnx

Stanley

#4

You can use the DSO/XML utility:

http://www.microsoft.com/downloads/d...DisplayLang=en

HTh,
Brian
www.geocities.com/brianaltmann/olap.html

"Stanley" wrote:

Quote:

Hi,

Is there a way to extract the query out of a cube, just like when you are
right clicking on a table/view in SQL Server and with menu "All
Tasks\Generate SQL Script" you can create the sql script which you can run an
it creates the table/view for you.
If not, anyone can provide me a sample script or point me to a resource of
how to create a cube in code?

Thnx

Stanley

#5

Ok, thnx people!

"Brian Altmann" wrote:

Quote:

You can use the DSO/XML utility:

http://www.microsoft.com/downloads/d...DisplayLang=en

HTh,
Brian
www.geocities.com/brianaltmann/olap.html

"Stanley" wrote:

Hi,

Is there a way to extract the query out of a cube, just like when you are
right clicking on a table/view in SQL Server and with menu "All
Tasks\Generate SQL Script" you can create the sql script which you can run an
it creates the table/view for you.
If not, anyone can provide me a sample script or point me to a resource of
how to create a cube in code?

Thnx

Stanley

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

Extract query from cube

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

Extract query from cube - 10-15-2004 , 04:35 AM

RE: Extract query from cube - 10-15-2004 , 04:39 AM

Re: Extract query from cube - 10-15-2004 , 06:14 AM

RE: Extract query from cube - 10-15-2004 , 08:17 AM

RE: Extract query from cube - 10-15-2004 , 08:33 AM