List of data mining techniques not populated - BI Studio hangs

From within the Business Intelligence Studio, I've created a data source and a data source view. Next, when I try to build a mining structure from a relational database, the studio hangs when it goes to the screen which lists the data mining techniques.

Has anybody come across this issue? What needs to be done to get further?

I'm using the June CTP of SQL Server 2005.

Thanks,
-GB.

In http://www.sqlserverdatamining.com I found a post talking about the same problem; the suggested fix was that a previous installation of Analysis Services be removed.

In my case, there was no previous installation of Analysis Services. However, there was an installation of SQL Server 2005 Express Edition, which the install program for SQL Server 2005 CTP detected, and asked me to remove (including a Beta of .NET version 2.0).

-GB.|||

A few questions:

Can you connect to your AS instance from SQL Mgmt Studio or another client?

Are you running a named instance? If yes, make sure that the SQL Server Browser service is functioning correctly.

Do you have network connectivity? There is a known issue with client-server connectivity when you're off the network.

|||Thank you for your reply, Raman.

I can connect to the AS instance from within SQL Management Studio. I can see the data source and data source views that I've already saved before starting with the data mining structure creation. I do not use any other client to connect to this instance.

I am using a default non-named instance.

About network connectivity: I have the TCP / IP stack running, but it is not (always) connected to a network. I also have the ZoneAlaram personal software firewall running. I've turned this off, but it still does not work.

Thanks,
-GB.|||This might be the result of a configuration/install bug. I would suggest uninstalling your June CTP version and moving to the RTM build.

List of data mining techniques not populated - BI Studio hangs

From within the Business Intelligence Studio, I've created a data source and a data source view. Next, when I try to build a mining structure from a relational database, the studio hangs when it goes to the screen which lists the data mining techniques.

Has anybody come across this issue? What needs to be done to get further?

I'm using the June CTP of SQL Server 2005.

Thanks,
-GB.

In http://www.sqlserverdatamining.com I found a post talking about the same problem; the suggested fix was that a previous installation of Analysis Services be removed.

In my case, there was no previous installation of Analysis Services. However, there was an installation of SQL Server 2005 Express Edition, which the install program for SQL Server 2005 CTP detected, and asked me to remove (including a Beta of .NET version 2.0).

-GB.|||

A few questions:

Can you connect to your AS instance from SQL Mgmt Studio or another client?

Are you running a named instance? If yes, make sure that the SQL Server Browser service is functioning correctly.

Do you have network connectivity? There is a known issue with client-server connectivity when you're off the network.

|||Thank you for your reply, Raman.

I can connect to the AS instance from within SQL Management Studio. I can see the data source and data source views that I've already saved before starting with the data mining structure creation. I do not use any other client to connect to this instance.

I am using a default non-named instance.

About network connectivity: I have the TCP / IP stack running, but it is not (always) connected to a network. I also have the ZoneAlaram personal software firewall running. I've turned this off, but it still does not work.

Thanks,
-GB.|||This might be the result of a configuration/install bug. I would suggest uninstalling your June CTP version and moving to the RTM build.

List as report parameter

Any hint how to build a report that prompts user to select multiple values
from a lookup table and uses the multiple values in WHRERE myfield IN
(<user-selected-list>) to select the data?
ThanksReporting Services does not provide this functionality ... supposedly coming
in a future release.
For now, you can just make the parameter a text box so the user can type in
a comma separated list ... then parse the parameter in the filter.
--
Shaun Beane, MCT, MCDBA, MCDST
http://dbageek.blogspot.com
"TheTechie" <TheTechie@.discussions.microsoft.com> wrote in message
news:5398BCA1-4839-46FC-8D40-1C4B81EE8B9E@.microsoft.com...
> Any hint how to build a report that prompts user to select multiple values
> from a lookup table and uses the multiple values in WHRERE myfield IN
> (<user-selected-list>) to select the data?
> Thanks|||Basically you can't - multi value lists are not natively support in the
current version.
You can however roll it yourself, either by dynamically building the sql
string to use JobID In (@.somecommadelimitedlist) or if you have some SQL
skills you can create a function in SQL Server to take a comma separated
list and return a table for use in a query.
Check this out:
http://www.windowsitpro.com/Article/ArticleID/26244/26244.html?Ad=1
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"TheTechie" <TheTechie@.discussions.microsoft.com> wrote in message
news:5398BCA1-4839-46FC-8D40-1C4B81EE8B9E@.microsoft.com...
> Any hint how to build a report that prompts user to select multiple values
> from a lookup table and uses the multiple values in WHRERE myfield IN
> (<user-selected-list>) to select the data?
> Thanks|||Chapter 11 of the book "Hitchhiker's Guide to SQL Server 2000 Reporting
Services" provides a work-round to have a multi-select pick list in the
parameter area.
It is quite well explained, starting out with a comma-separated textbox, but
involves some careful editing...
HTH