Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to create dbs Programmatically, then open in BIDS?

 
   Database Forums (Home) -> Datamining RSS
Next:  Multiple IP's (from 2 different networks) on a si..  
Author Message
Bill Nicholson

External


Since: Dec 06, 2007
Posts: 1



(Msg. 1) Posted: Thu Dec 06, 2007 9:58 am
Post subject: How to create dbs Programmatically, then open in BIDS?
Archived from groups: microsoft>public>sqlserver>datamining (more info?)

Hi,

I have C# code that uses the Microsoft.AnalysisServices namespace to
create OLAP databases. I can see the databases in C:\Program Files
\Microsoft SQL Server\MSSQL.2\OLAP\Data. How do I open them with BIDS?
Since I don't have a VS project, I can create a new one in BIDS but
then I can't see how to add these databases that I created via code.

Thanks,

Bill
Cincinnati, OH USA

I'm sorry if this is posted in a wrong place. I have been tying to find help on this and I have had no success. Perhaps someone can suggest a different place. I tried microsoft.public.sqlserver.olap and no one responded.

From http://www.developmentnow.com/g/101_2006_1_0_0_0/sql-server-data-mining.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

 >> Stay informed about: How to create dbs Programmatically, then open in BIDS? 
Back to top
Login to vote
Bogdan Crivat MSFT

External


Since: Feb 20, 2004
Posts: 73



(Msg. 2) Posted: Fri Dec 07, 2007 1:39 pm
Post subject: Re: How to create dbs Programmatically, then open in BIDS? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You can try:

File\Open\Analysis Services Database -- it allows you to have the BIDS
experience on a Live database.
Note that any saved change goes directly to the server


--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

"Bill Nicholson" wrote in
message
> Hi,
>
> I have C# code that uses the Microsoft.AnalysisServices namespace to
> create OLAP databases. I can see the databases in C:\Program Files
> \Microsoft SQL Server\MSSQL.2\OLAP\Data. How do I open them with BIDS?
> Since I don't have a VS project, I can create a new one in BIDS but
> then I can't see how to add these databases that I created via code.
>
> Thanks,
>
> Bill
> Cincinnati, OH USA
>
> I'm sorry if this is posted in a wrong place. I have been tying to find
> help on this and I have had no success. Perhaps someone can suggest a
> different place. I tried microsoft.public.sqlserver.olap and no one
> responded.
>
> From
> http://www.developmentnow.com/g/101_2006_1_0_0_0/sql-server-data-mining.htm
>
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

 >> Stay informed about: How to create dbs Programmatically, then open in BIDS? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to use OPEN QUERY with cube? - hi, I am using DMX to train my mining model with the INSERT INTO statement. And I want to use cube as my data source for the OPENQUERY statement. However, I can only find the OPENQUERY with relational data source in the SQL Books Online. I..

create dimensions programmatically - I am trying to create dimensions to an analysis services programmatically This is the code I am using DimensionAttribute attr; attr = dim.Attributes.Add("KEYCOLUMN"); attr.Usage = AttributeUsage.Key; attr.Type =..

SSMS: create datasource and datasource view - 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..

create mining structure from tsql? - Hi! I want to execute dynamic generated dmx-ddl from tsql. How to do that? Openquery doesn't work, because "create mining structure..." does not return result set. Thanks Bjorn

Sample or best practices to create a "quality" predictive .. - Hi, I'm using SQL 2005 I want to do some tests regarding the datamining feature of SQL 2005. I have a supply chain data warehouse where I store production information around some step in the chain. we have 10 steps; at steps 3, 6 and 10 we do a..
   Database Forums (Home) -> Datamining All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]