Re: SSMS: create datasource and datasource view

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 ... Connect to existing database ...
    (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: Deployment of Analysis Services 2000 database
    ... You cannot actually change the data source for a database, ... This can seem slightly counter intuitive as the datasource will retain ... What a lot of people do is to set up the data source with a generic name ... Right click your server and hit 'Paste'. ...
    (microsoft.public.sqlserver.olap)
Loading