Re: SSMS: create datasource and datasource view

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

Relevant Pages

  • Re: HELP I am about to quit on AS2005
    ... Create an Analysis Services Project Based on an Existing ... Analysis Services Database ... Working with Diagrams in a Data Source View ...
    (microsoft.public.sqlserver.olap)
  • Re: HELP I am about to quit on AS2005
    ... Create an Analysis Services Project Based on an Existing ... Analysis Services Database ... Working with Diagrams in a Data Source View ...
    (microsoft.public.sqlserver.olap)
  • Re: SSMS: create datasource and datasource view
    ... > In SQL Managment studio you may create Analysis services database object ... > but not Data source, Data source view, Data mining structure, Data mining ... Go to File->Open->Analysis Services Database ... > you delete Datasource and deploy solution, ...
    (microsoft.public.sqlserver.datamining)
  • Re: SSMS: create datasource and datasource view
    ... >> In SQL Managment studio you may create Analysis services database object ... >> but not Data source, Data source view, Data mining structure, Data mining ... Connect to existing database ...
    (microsoft.public.sqlserver.datamining)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
Loading