Hi,

I need to programatically build dimensions and cubes with MSAS 2000. It
would help if i have soime sample code to begin with. Can you please provide
links so that i can download sample code?

Here is what i am trying to do.

-- Build dimensions with source as an SQL SELECT statement.
-- Build various partitons with appropriate time filters.
-- Create aggregations.

Thanks,

Sam.

The best resource for you is to get a copy of the Metadata Scripter
application on the SQL Server 2000 Resource Kit. I believe that as a book
that it is out of print, but many copies were sold. It is also on the
Resource Kit CD/DVD on a Technet subscription.

Using the metadata scripter you can generate your own "sample" from your
actual objects :-)

Here is the info from the CD:
Meta Data Scripter (MetaDataScripter)
The Meta Data Scripter (MetaDataScripter) sample is located in the
ToolsAndSamples\MetaDataScripter folder on this Microsoft SQL Server 2000
Resource Kit CD.

The Meta Data Scripter sample provides an excellent way to exploit the
features of Decision Support Objects (DSO). You can use the Meta Data
Scripter for tasks such as repopulating meta data for objects, copying meta
data for objects to a different database, creating copies of objects on
different servers, in different databases, or with different names.

The Meta Data Scripter consists of a Microsoft® Visual Basic® 6.0 ActiveX®
DLL project used to construct an add-in for Microsoft SQL ServerT 2000
Analysis Services, as well as two Microsoft Visual Basic Scripting Edition
(VBScript) template files. The add-in enables you to script the meta data of
any object, including dependent objects, that can be selected in Analysis
Manager. The add-in generates a VBScript file that uses DSO to re-create the
scripted objects.

The routines that use DSO to re-create the scripted objects are contained in
the Footer.vbs template file included with the sample. The global variables
used by the generated VBScript script file are contained in the Header.vbs
template file, also supplied with the sample. The Analysis Services add-in
copies both files into the generated VBScript file.

--
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.



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

Thanks a lot. It is of great help and already does allmost every thing what i
wanted to achieve.

Will there be a similar add in written for Analysis services 2005 in near
future. Any .Net eqvivalent of this VB module?

Thanks,

Sam.

"Dave Wickert [MSFT]" wrote:

yes...take a look at AMO

Hi,

Can you please eloborate what AMO is? and where i can find more information
on this?

Thanks in advance,

Sam.

"ricocali (AT) hotmail (DOT) com" wrote:

DSO = COM-based API for administrating an AS2K instance
AMO = .NET managed API for administrating an AS2K5 instance

There is no equivalent of the metadata scripter for AS2K5. The best AMO
reference we have is on the SQL Server 2005 Samples MSI
1) AMOBrowser which allows you to browse the various properties and methods
of AMO with a UI -- very cool tool
2) AMOAdventureWorks which re-creates the objects which is very close
(although not *exactly* the same) as the Sample Adventure Works DW objects
using AMO.

--
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.


<ricocali (AT) hotmail (DOT) com> wrote

One of the most important management enhancements in Analysis Services
for SQL Server 2005 is the new Object Definition Language (ODL). ODL
brings the same type of scriptable object creation capabilities to
Analysis Services that the relational SQL Server has always had.
Analysis Services ODL enables you to write scripts that can
automatically create all of your Analysis Services database objects.
You can also use these scripts to control Analysis Services database
versioning.

SQL Server 2005's new Analysis Services DDL is an open specification
that's built on XML for Analysis (XMLA). Based on an open standard,
Analysis Services ODL scripts can be created using any XML-aware
editor.

Can any one let me know whether AMO is programmable in DTS packages
using ActiveX Scriupt task if Yes then how.

AS DSO was Programmable using using VBScripting in ActiveX script task
in DTS and create dynamic partitions in the cube.

Any samples or any links is highly appreciated.

Regards,
Prasanna

Yes it certainly is.
Look at the June or upcoming Sept CTP in the Samples area.
There is an Integration Services sample called "SynAdvWorksPartitions" which
shows you how to sychrnoize partitions (in this case, Adventure Works)
between a source RDBMS and AS. It uses a scripting task with AMO to see if a
partition already exists.
--
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.


"pras" <prasannat (AT) gmail (DOT) com> wrote