Re: SSMS: create datasource and datasource view

Yes - use the "Script" button on top of the process dialog in SSMS to
generate the script. There are also processing templates in the template
explorer - they are for dimensions and partitions, but changing them to be
models/structures isn't that hard.

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
<ziga> wrote in message
news:8fcc6813-8449-436c-85f7-16394b16cde9@xxxxxxxxxxxxxxxxxxxxxxx
Is it also possible to train (process) structures and models using XMLA?


You can create objects through the XML using the DDL script. Check out
the
Create Datasource template at
http://www.sqlserverdatamining.com/dmcommunity/_downloads/2124.aspx
(free
login required)

You can also create any other object this way, but the DDL is more
complex.
You can get the DDL of an existing object to inspect it by right clicking
and doing a Script To.. Create

I use this template to easily create more datasources for lower
priviledged
users. If you are using CREATE MINING STRUCTURE and INSERT INTO to
create
and train, you won't need DSV's anyway.

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no
rights.
<ziga> wrote in message
news:1d508056-ac8c-4b4a-a429-9d378266929f@xxxxxxxxxxxxxxxxxxxxxxx
In SQL Managment studio you may create Analysis services database
object
but not Data source, Data source view, Data mining structure, Data
mining
model,...
In Visual Studio 2005 it is a way to create Data Mining objects
directly
on Analysis services. You don't need to create a project.
1.) Run Visual Studio 2005
2.) Go to File->Open->Analysis Services Database
3.) You have two options:
a.) Connect to existing database
b.) Create a new database
In case you already have a database on Analysis services chose the
first
option
5.) Under Server: specify your Analysis services name
6.)Under Database: Chose one of the existing databases you have made on
Analysis services
You also sepcify the solution location...
7.) Click OK

Now you have the same environment that you have if you make Analysis
services project. The difference is that every object you create here
in
the same way is directly reflecting on Analysis server!!! For
example:if
you delete Datasource and deploy solution, the Datasource will be
deleted
on SSAS!

Ziga

How do I create data source and data source view in sql server
management
studio? Currently, I switch to business intelligence studio (Visual
Studio),
create the analysis services database, create data source, create
datasource
view, process the structures and then switch to ssms.

Is there any way to this all in SSMS??

Please help.

TIA..




.