BI studio

hi,

I have to connect to use a cube that is residing on different machine in order to develop a mining structure using MS associations rules algorithm.

Can anybody tell me the connection type (for Data Source) I should use so that I can use the same to create Data Source View OR Mining Structure?

I tried using OLAP, Analysis Service 9.0, OLAP 8.0, Data Mining - connection types. I could see only data source created using Data Mining connection while i was creating data source view.

Please help me as to which method I should use to connect cube on remote server to create a mining structure.

Thank you.

Aashutosh

SQL Server Data Mining does not allow you to create mining structure on cubes residing on remote servers or in another database on the same server - the source cube for an OLAP mining structure needs to be in the same database as the mining structure.

|||The only option would be to use DMX statements to create and train a mining structure (CREATE MINING STRUCTURE and INSERT INTO statements)|||

Hi,

thank you for your help.

I will try using DMX. One more question:

If I connect to remote server (which has the cube) using SQL server Management Studio to create a mining structure, will it modify the database on the remote server?

Aashutosh

|||

Creating a mining structure on the remote server is modifying the database as you are creating an object.

If you don't want to permanently change the database, you can use CREATE SESSION MINING STRUCTURE.... but you first have to enable session objects on that server (available in server properties).

If you are creating a mining structure on a server and populating from another analysis services database through OPENQUERY, then you do not modify the source database.

|||

Thank you for your help.

Will the same thing happen in case of relational database, i.e.

If I use relational database on remote server and create mining structure using BI development studio installed on local machine, will it modify the database on the remote server?

thank you once again.

Aashutosh Magdum