data sources for subscriptions, linked reports, how it can all wor

I think I must be missing something here...
I, as the developer, create Report1 and Report2: they use DataSouceA.
DataSourceA is set to use windows integrated security.
My on-demade reports run fine. The username (selected from the db, not from the Globals collection) is used to filter out options on the parameter screen, so users can only see data in their respective division.
Now: I want my USERS to be able to schedule reports.
I am able to schedule reports by taking Report1 and Report2 and either customizing the data source or pointing it to a new data source: BUT I AM DOING THAT FOR ALL USERS who are on the system!!! Now, anyone who goes to run Report1 or Report2 does not need to have any security to access the database, they are all using my id!
If I create a LINKED report, you do not seem to have the option of changing the data source...it is not even on the left menu anymore. '
So: I am confused. If I have to set up all reports to used a saved data source (lets just say it is my username and password), what is the sense of having any security? I must be missing something here.
What I want is the NT integrated security for on-demand. Then if a user has the ability to schedule reports, they would need to make a linked copy of the report, change the data source (and remember there is no way to copy a data source, so my users will have to ALL be trained on creating them - which seems a bit odd) to point to a datasource with stored credentials (preferrably their own login and password), and create a schedule.Unfortunately there is not a good solution for this in V1. Integrated
reports can not be scheduled. We are hoping to change this in a future
version.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"asc_rmc" <asc_rmc@.discussions.microsoft.com> wrote in message
news:9FD821AD-F312-473A-B20F-FD639B3D75FA@.microsoft.com...
> I think I must be missing something here...
> I, as the developer, create Report1 and Report2: they use DataSouceA.
> DataSourceA is set to use windows integrated security.
> My on-demade reports run fine. The username (selected from the db, not
from the Globals collection) is used to filter out options on the parameter
screen, so users can only see data in their respective division.
> Now: I want my USERS to be able to schedule reports.
> I am able to schedule reports by taking Report1 and Report2 and either
customizing the data source or pointing it to a new data source: BUT I AM
DOING THAT FOR ALL USERS who are on the system!!! Now, anyone who goes to
run Report1 or Report2 does not need to have any security to access the
database, they are all using my id!
> If I create a LINKED report, you do not seem to have the option of
changing the data source...it is not even on the left menu anymore. '
> So: I am confused. If I have to set up all reports to used a saved data
source (lets just say it is my username and password), what is the sense of
having any security? I must be missing something here.
> What I want is the NT integrated security for on-demand. Then if a user
has the ability to schedule reports, they would need to make a linked copy
of the report, change the data source (and remember there is no way to copy
a data source, so my users will have to ALL be trained on creating them -
which seems a bit odd) to point to a datasource with stored credentials
(preferrably their own login and password), and create a schedule.
>sql

Data Sources

I have created a report, and would like to use the data contained in that report to create another report. In essence, one report would be the dataset for another report. I can't find any indication that this is possible. Can anyone give me a suggestion?This is possible but not easy. First, you would need to write (or purchase)
a data provider that accepts XML data input from a URL.
Then you would use that data provider to get an export of the report from
the report server in XML format (using URL access).
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"RptSrvQuests" <RptSrvQuests@.discussions.microsoft.com> wrote in message
news:188E428D-4979-4ADE-B1B9-441E47011558@.microsoft.com...
> I have created a report, and would like to use the data contained in that
report to create another report. In essence, one report would be the
dataset for another report. I can't find any indication that this is
possible. Can anyone give me a suggestion?|||The best place to start is the section of the documentation titled
"Implementing a Data Processing Extension".
It is also available in MSDN:
http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5c2q.asp
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"RptSrvQuests" <RptSrvQuests@.discussions.microsoft.com> wrote in message
news:4B5F8B34-B05F-412E-9F19-62791C1CDE00@.microsoft.com...
> Can you provide an example of a data provider or what code it would be
written in? I would also like a more detailed description of how to carry
out the process. I'm still relatively new to RS, and need detailed
instructions on carrying out procedures.
> "Chris Hays [MSFT]" wrote:
> > This is possible but not easy. First, you would need to write (or
purchase)
> > a data provider that accepts XML data input from a URL.
> > Then you would use that data provider to get an export of the report
from
> > the report server in XML format (using URL access).
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "RptSrvQuests" <RptSrvQuests@.discussions.microsoft.com> wrote in message
> > news:188E428D-4979-4ADE-B1B9-441E47011558@.microsoft.com...
> > > I have created a report, and would like to use the data contained in
that
> > report to create another report. In essence, one report would be the
> > dataset for another report. I can't find any indication that this is
> > possible. Can anyone give me a suggestion?
> >
> >
> >

Data Source Problem in SQL server mobile edition

Hi,

I am using SQLCE and VS 2005 to create a database named "student.sdf" (inside my projects folder, of course). When click on the button, it will test for connection of database.
Everytimes I run the program, it will pop up an error message "The database file cannot be found. Check the path to the database. [File name = .\student.sdf]". How do I fix it?

Code Snippet

Imports System.Data.SqlServerCe

Public Class loginForm

Private _conn As SqlCeConnection


Private Sub ButtonLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonLogin.Click

_conn = New SqlCeConnection("Data Source =.\student.sdf")

Try
_conn.Open()

MessageBox.Show("Correct")

Catch ex As SqlCeException

MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1)
Finally

_conn.Close()

End Try

End Sub

End Class

Did you try changing the current directory in debug settings?

Data Source Not Shared

How to create a Not Schared Data Source using Reporting Service Web Service?
ThanksWhat do you mean by "not shared"? A data source used by a report (as long
as it is not a shared data source) is a not shared Data Source. Are you
asking how to create it in the designer?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ale Dori" <AleDori@.discussions.microsoft.com> wrote in message
news:B33C9A19-D026-481B-A669-24BF9EC8FBDF@.microsoft.com...
> How to create a Not Schared Data Source using Reporting Service Web
> Service?
> Thanks
>

Data source for Time Dimension?

Hi;

I have been trying to create Time Dimension for one of the column in the table i.e. EntryDate and I am unable to connect the time dimension which I create using the Wizard using the 2nd option which is Without using data source. It created a dimension but it is not connected to any data source and when I process it gives me error, data source is not specified.

I am very new to Analysis service, I am using SQL Server 2005. I want to create a report where I can show my data by month, by year depending upon the EntryDate column of a table.

Thanks

Have you tried the adventure works dw data base that is part of the samples that you can install with SQL Server 2005 and SSAS2005? In that database you have several dimension tables and a time dimension table.

If you would like to test your skills in building dimensions with a data source I recommend this database.

Regards

Thomas Ivarsson

Data Source access

Hi All,
I'm looking to create an ad-hoc query generator so that I can create a
report on the fly, but I would like to use RS Shared Data Sources for this.
I have run into a problem though, in that I can't retrieve the password for
the Shared Data Source. Is there any way to get the Data Source back as a
connection to the database in ADO?
Thanks in advacne,
CathieNo you cannot get the data source back as connection. But you could try to
implement a custom RS data extension and use it then in the shared data
source.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cathie" <cathie@.somewhere.com> wrote in message
news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I'm looking to create an ad-hoc query generator so that I can create a
> report on the fly, but I would like to use RS Shared Data Sources for
> this. I have run into a problem though, in that I can't retrieve the
> password for the Shared Data Source. Is there any way to get the Data
> Source back as a connection to the database in ADO?
> Thanks in advacne,
> Cathie
>|||Hi Robert,
I'm sorry I don't understand how a custom RS data extension would help me.
I am want to be able to get any datasource's (within RS) tables, views,
stored procedures etc. How would a custom RS data extension help?
Cathie
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OIBjdIgTFHA.1404@.TK2MSFTNGP09.phx.gbl...
> No you cannot get the data source back as connection. But you could try to
> implement a custom RS data extension and use it then in the shared data
> source.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Cathie" <cathie@.somewhere.com> wrote in message
> news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Hi All,
>> I'm looking to create an ad-hoc query generator so that I can create a
>> report on the fly, but I would like to use RS Shared Data Sources for
>> this. I have run into a problem though, in that I can't retrieve the
>> password for the Shared Data Source. Is there any way to get the Data
>> Source back as a connection to the database in ADO?
>> Thanks in advacne,
>> Cathie
>|||If you go through a custom data extension, you would need to implement our
IDBConnection etc. interfaces. Hence, in the custom data extension you would
see the actual connection string etc. used to connect to the data source.
You could use this information to do then some adhoc query generation. What
I'm basically saying is that you cannot easily do the adhoc query generation
from within the report in RS 2000.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cathie" <cathie@.somewhere.com> wrote in message
news:e5GQ9F4TFHA.2712@.TK2MSFTNGP09.phx.gbl...
> Hi Robert,
> I'm sorry I don't understand how a custom RS data extension would help me.
> I am want to be able to get any datasource's (within RS) tables, views,
> stored procedures etc. How would a custom RS data extension help?
> Cathie
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:OIBjdIgTFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> No you cannot get the data source back as connection. But you could try
>> to implement a custom RS data extension and use it then in the shared
>> data source.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Cathie" <cathie@.somewhere.com> wrote in message
>> news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Hi All,
>> I'm looking to create an ad-hoc query generator so that I can create a
>> report on the fly, but I would like to use RS Shared Data Sources for
>> this. I have run into a problem though, in that I can't retrieve the
>> password for the Shared Data Source. Is there any way to get the Data
>> Source back as a connection to the database in ADO?
>> Thanks in advacne,
>> Cathie
>>
>

data set problem in RTM Professional Edition - sql server 2005

Hi,
I create a report with the Report Wizard Designer and are able to pre-view and deploy it (it’s a simple table with an OLAP data source), but if I switch to the "Data" tab the related DataSet seems to be empty and then, if I go back to the "Pre-view" tab, I can't view the Report no more and have this kind of error: "

[rsFieldReference] The Group expression for the table ‘table1’ refers to the field ‘Semestre’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

rsFieldReference] The Value expression for the textbox ‘Valore’ refers to the field ‘Valore’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
..................

Build complete -- 5 errors, 0 warnings
"
As if the DAta Set were empty, in effect. But I didn't make any changes in the "Data" tab, I only switch there to see the Data definition.
Which can be the problem?
Thank you very much.

This is a known problem. It will be fixed in the next Service Pack. The workaround is not to use the Wizard to create the report. Instead use the Data tab to create your query.

Thanks,
Albertsql

data set problem in RTM Professional Edition - sql server 2005

Hi,
I create a report with the Report Wizard Designer and are able to pre-view and deploy it (it’s a simple table with an OLAP data source), but if I switch to the "Data" tab the related DataSet seems to be empty and then, if I go back to the "Pre-view" tab, I can't view the Report no more and have this kind of error: "

[rsFieldReference] The Group expression for the table ‘table1’ refers to the field ‘Semestre’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

rsFieldReference] The Value expression for the textbox ‘Valore’ refers to the field ‘Valore’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
..................

Build complete -- 5 errors, 0 warnings
"
As if the DAta Set were empty, in effect. But I didn't make any changes in the "Data" tab, I only switch there to see the Data definition.
Which can be the problem?
Thank you very much.

This is a known problem. It will be fixed in the next Service Pack. The workaround is not to use the Wizard to create the report. Instead use the Data tab to create your query.

Thanks,
Albert

data processing extension sample

I'm trying to write some code to retrieve a reports list from a report folder.
Is it possible to create data processing extension in old asp? Either yes
or no, could someone post a link to some sample code, aspx samples would be
just fine?I forgot to mention that I only know VB. So please provide the samples in
VB. Thx a mil!
"JL" wrote:
> I'm trying to write some code to retrieve a reports list from a report folder.
> Is it possible to create data processing extension in old asp? Either yes
> or no, could someone post a link to some sample code, aspx samples would be
> just fine?|||http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
try this one. the best i have found.
[]s
Renato
"JL" <JL@.discussions.microsoft.com> escreveu na mensagem
news:1E1F4C39-7C3E-4263-B883-D2865507C968@.microsoft.com...
> I forgot to mention that I only know VB. So please provide the samples in
> VB. Thx a mil!
> "JL" wrote:
> > I'm trying to write some code to retrieve a reports list from a report
folder.
> >
> > Is it possible to create data processing extension in old asp? Either
yes
> > or no, could someone post a link to some sample code, aspx samples would
be
> > just fine?|||Thx a lot. But I only want to retrieve the reports list from a report
folder. Do I need to use the same extension? Or is there an alternative
(easier) way? Thx.
"Renato Aloi" wrote:
> http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
> try this one. the best i have found.
> []s
> Renato
> "JL" <JL@.discussions.microsoft.com> escreveu na mensagem
> news:1E1F4C39-7C3E-4263-B883-D2865507C968@.microsoft.com...
> > I forgot to mention that I only know VB. So please provide the samples in
> > VB. Thx a mil!
> >
> > "JL" wrote:
> >
> > > I'm trying to write some code to retrieve a reports list from a report
> folder.
> > >
> > > Is it possible to create data processing extension in old asp? Either
> yes
> > > or no, could someone post a link to some sample code, aspx samples would
> be
> > > just fine?
>
>|||I saw a sample that demonstrate this... But I don't remmember where... What
I remmember is that you can write some code to do that, using ListChildren
method of Reporting Service Web Server, like this:
dim items() as CatalogItem
items = (new ReportingService).ListChildren("/", True)
then populate a list:
for each item as CatalogItem in items
cboWhatever.Items.Add(new ReportItem(item.name, item.Path))
next
That is it. Do not forget to reference the RS web service...
[]s
Renato
"JL" <JL@.discussions.microsoft.com> escreveu na mensagem
news:F408C4D6-DB48-40F1-A6A5-22BE8E958114@.microsoft.com...
> Thx a lot. But I only want to retrieve the reports list from a report
> folder. Do I need to use the same extension? Or is there an alternative
> (easier) way? Thx.
> "Renato Aloi" wrote:
> >
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
> >
> > try this one. the best i have found.
> >
> > []s
> > Renato
> >
> > "JL" <JL@.discussions.microsoft.com> escreveu na mensagem
> > news:1E1F4C39-7C3E-4263-B883-D2865507C968@.microsoft.com...
> > > I forgot to mention that I only know VB. So please provide the
samples in
> > > VB. Thx a mil!
> > >
> > > "JL" wrote:
> > >
> > > > I'm trying to write some code to retrieve a reports list from a
report
> > folder.
> > > >
> > > > Is it possible to create data processing extension in old asp?
Either
> > yes
> > > > or no, could someone post a link to some sample code, aspx samples
would
> > be
> > > > just fine?
> >
> >
> >

Data Proc Ext - Dynamic Connect String

I am trying to create a data processing extension that will allow me to
dynamically set the connect string. I have been able to successfully
register a sample data processing extension (from Teo Lachev's book), but I'm
not sure if I need to implement all of the classes included - can I just
implement the IDbConnection, IDbConnectionExtension, and IExtension much like
DsConnectionWrapper, but then use OleDbCommand rather than writing DsCommand,
etc.?
I really just need the ability to override the connection string based on
the user that authenticates to the report server. I have a security
extension in place for Forms authentication. I need to be able to switch
dev/test/prod connect strings in addition to changing databases based on who
connected.
BTW, I am using OLEDB and the OLAP provider to connect to an Analysis
Services database so I'm not sure I can just dynamically change my MDX like
some have suggested changing SQL.This is coming in SQL 2005 but I'm not sure it is possible in SQL2K. The
only thing I could think of is to pass the user ID and the query in on the
command and then connect and query at the same time.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"danb" <danb@.discussions.microsoft.com> wrote in message
news:9E9697FD-86A2-45E4-9652-62CE1BCFCFC1@.microsoft.com...
>I am trying to create a data processing extension that will allow me to
> dynamically set the connect string. I have been able to successfully
> register a sample data processing extension (from Teo Lachev's book), but
> I'm
> not sure if I need to implement all of the classes included - can I just
> implement the IDbConnection, IDbConnectionExtension, and IExtension much
> like
> DsConnectionWrapper, but then use OleDbCommand rather than writing
> DsCommand,
> etc.?
> I really just need the ability to override the connection string based on
> the user that authenticates to the report server. I have a security
> extension in place for Forms authentication. I need to be able to switch
> dev/test/prod connect strings in addition to changing databases based on
> who
> connected.
> BTW, I am using OLEDB and the OLAP provider to connect to an Analysis
> Services database so I'm not sure I can just dynamically change my MDX
> like
> some have suggested changing SQL.

Data not appearing in report at runtime

Hi all,

I am attempting to create and view a simple Crystal Report in VB.net and am running into some difficulty.

- First of all I add my Microsoft Access database as a datasource.
- Then I create a Crystal Report within VB.Net using the fields from my datasource e.g. MyReport.rpt
- Finally I create a form with a Crystal ReportViewer control on it and set the ReportSource to my new report, MyReport.rpt

However when I run my project the report appears but the data does not display.

I have tried looking at a couple of tutorials but haven't been able to figure it out, I'm guessing that I need to run a piece of code at runtime or something for the data to display?

Can anyone please help?

Many thanks in advance.

LeeDid you refresh the report source using your program?|||Hi there,

How do I carry that out?

Many thanks
Lee|||Hi there,

How do I carry that out?

Many thanks
Lee
Just call the method of CrystalReportViewer;
i.e.
CrystalReportViewer CR
CR.RefreshReport()

Data Model Relationships

I am trying to create a data source view that includes a Fact table and
several related dimension tables. One of my dimension tables is quite small
and uses a tinyint PK. For some reason when I bring this table into the
model it thinks the PK is a System.Int32 datatype and won't allow a
relationship to the fact table FK which it sees as a System.Byte datatype.
In the database both fields are tinyint datatypes and there is a
relationship between the two.
My question is: Do I have to increase the field to a smallint in order to
create a relationship in the model or is there a workaround. This is my
first attempt at creating a data model for the Report Builder and any tips
would be appreciated. Thanks.I've noticed that if a key is an IDENTITY field then, regardless, it is seen
as an Int32. The behavior seems consistent in reporting services and in
analysis services. What we've decided to do is to make all primary and
foreign keys standard Ints (Int32) instead of tiny and small ints - even when
the smaller values were appropriate. The other thing you could do is to make
the table a named query and cast the key as a smaller int so the relationship
works.
"Elmer Miller" wrote:
> I am trying to create a data source view that includes a Fact table and
> several related dimension tables. One of my dimension tables is quite small
> and uses a tinyint PK. For some reason when I bring this table into the
> model it thinks the PK is a System.Int32 datatype and won't allow a
> relationship to the fact table FK which it sees as a System.Byte datatype.
> In the database both fields are tinyint datatypes and there is a
> relationship between the two.
> My question is: Do I have to increase the field to a smallint in order to
> create a relationship in the model or is there a workaround. This is my
> first attempt at creating a data model for the Report Builder and any tips
> would be appreciated. Thanks.
>
>|||sounds correct to me.
I had an identity on a TinyInt and I think that it just blatantly
friggin crashed SSAS or something ridiculous
-Aaron
Aaron wrote:
> I've noticed that if a key is an IDENTITY field then, regardless, it is seen
> as an Int32. The behavior seems consistent in reporting services and in
> analysis services. What we've decided to do is to make all primary and
> foreign keys standard Ints (Int32) instead of tiny and small ints - even when
> the smaller values were appropriate. The other thing you could do is to make
> the table a named query and cast the key as a smaller int so the relationship
> works.
> "Elmer Miller" wrote:
> > I am trying to create a data source view that includes a Fact table and
> > several related dimension tables. One of my dimension tables is quite small
> > and uses a tinyint PK. For some reason when I bring this table into the
> > model it thinks the PK is a System.Int32 datatype and won't allow a
> > relationship to the fact table FK which it sees as a System.Byte datatype.
> > In the database both fields are tinyint datatypes and there is a
> > relationship between the two.
> > My question is: Do I have to increase the field to a smallint in order to
> > create a relationship in the model or is there a workaround. This is my
> > first attempt at creating a data model for the Report Builder and any tips
> > would be appreciated. Thanks.
> >
> >
> >

Data Mining Wizard (Not Responding)

I am trying to create a new mining structure, but when launching the wizard the "Data Mining Wizard" stops responding where the dropdownlist with the algorithms should appear.

The bizarre thing is that I can access the cube and the datawarehouse just fine using the same setup, it's just the mining wizard that doesn't work.

I am using SQL 2005 standard & Visual Studio 2005 Team Suite (and yes I have reinstalled SQL 2005) - no change.

Are there any logs that might shed some light on this strange behavior, or is this a known issue?

The main difference with the DM wizard is that, unlike other wizards, it actually connects to the server to determine the list of available algorithms. However, it is supposed to provide a default list of algorithms if it cannot connect.

You might try looking at the project settings to make sure that the deployment server is set up correctly.

Have you succesfully deployed any AS projects to an AS server?

|||

Hi Chris

The behavior of the algorithm selection wizard page is to retrieve the list of algorithm from the deployment server. If the query times out, it reverts to a list of cached algorithms. The value of the timeout depends on whether:

1. The server is a nonexistent machine (in this case, the timeout is equal to the time it takes to determine from DNS that the machine name is nonexistent and is usually fast)

2. The server is offline. In this case, the timeout is longer (usually 30 seconds, but can be configured under network settings).

3. The server is online, but Analysis Service is not started. This timeout is the TCP timeout, usually 30 seconds.

The first step is to determine your deployment server. For that, right click on the project select properties and look under Configuration Properties -> Deployment. The server name is available in the property grid. Next, please ensure that the server is reachable and is running Analysis Services. If it's an offline server, that you should get a list of default algorithms after 30 seconds or the timeout configured for your machine

Let me know if you have any further questions

Thanks

Shuvro

|||

I have the exact same issue, I have deleted and removed every thing and reinstalled SQl 2005 standard and Visual Studio 2005 and every time I get an unresposive screen when trying to pick a mining model.

I had created a mining model before and worked fine but know just stops responding.

|||

If possible, please work with tech support - we haven't seen these issues outside of what we've already commented on, and it's difficult to debug through the forum.

Thanks

Data Mining Wizard (Not Responding)

I am trying to create a new mining structure, but when launching the wizard the "Data Mining Wizard" stops responding where the dropdownlist with the algorithms should appear.

The bizarre thing is that I can access the cube and the datawarehouse just fine using the same setup, it's just the mining wizard that doesn't work.

I am using SQL 2005 standard & Visual Studio 2005 Team Suite (and yes I have reinstalled SQL 2005) - no change.

Are there any logs that might shed some light on this strange behavior, or is this a known issue?

The main difference with the DM wizard is that, unlike other wizards, it actually connects to the server to determine the list of available algorithms. However, it is supposed to provide a default list of algorithms if it cannot connect.

You might try looking at the project settings to make sure that the deployment server is set up correctly.

Have you succesfully deployed any AS projects to an AS server?

|||

Hi Chris

The behavior of the algorithm selection wizard page is to retrieve the list of algorithm from the deployment server. If the query times out, it reverts to a list of cached algorithms. The value of the timeout depends on whether:

1. The server is a nonexistent machine (in this case, the timeout is equal to the time it takes to determine from DNS that the machine name is nonexistent and is usually fast)

2. The server is offline. In this case, the timeout is longer (usually 30 seconds, but can be configured under network settings).

3. The server is online, but Analysis Service is not started. This timeout is the TCP timeout, usually 30 seconds.

The first step is to determine your deployment server. For that, right click on the project select properties and look under Configuration Properties -> Deployment. The server name is available in the property grid. Next, please ensure that the server is reachable and is running Analysis Services. If it's an offline server, that you should get a list of default algorithms after 30 seconds or the timeout configured for your machine

Let me know if you have any further questions

Thanks

Shuvro

|||

I have the exact same issue, I have deleted and removed every thing and reinstalled SQl 2005 standard and Visual Studio 2005 and every time I get an unresposive screen when trying to pick a mining model.

I had created a mining model before and worked fine but know just stops responding.

|||

If possible, please work with tech support - we haven't seen these issues outside of what we've already commented on, and it's difficult to debug through the forum.

Thanks

data mining viewer controls.....

i'd like to add the data mining viewer controls into visual c# 's toolkit....is it possible...

is there a way how i could create forms and import the minned pattern into these forms using the data mining viewer controls?

infact i am trying to make use of the data mining viewer controls to migrate the minned results from BIDS to a form or to a web page......so what would the first step be? i have already installed the data mining viewer controls...but then i don't see any of these web controls in my toolkit...

what is my next step? is it adding these installed contrls onto the visual c# web developer toolbar?(toolkit) please correct me if i am wrong......and what would b my next step in achieving this?

data mining 2000

i want show other products when somebody choose a product,

ect:

product1 product2

A B, C ,D

B C,D,E

C F, G

.......

i create model:

I create a mining model:

CREATE MINING MODEL [bh'S]

([Cusid] LONGKEY,

[Products] TABLE PREDICT ([Productid] LONGKEY

)) USING Microsoft_Decision_Trees

INSERT INTO [bh'S]

(SKIP, [Products] (SKIP, [Productid]))

SHAPE

{OPENROWSET(…, 'SELECT DISTINCT "dbo"."customers"."cusid" AS "Cusid" FROM "dbo"."customers" ORDER BY "dbo"."customers"."cusid"')}

APPEND

( {OPENROWSET(…, 'SELECT DISTINCT "dbo"."orderdata"."cusid" AS "UI_GENERATED_PARENT_KEY_COLUMN", "dbo"."products"."productid" AS "Productid" FROM "dbo"."orderdata", "dbo"."orderdetails", "dbo"."products" WHERE (("dbo"."orderdata"."orderid"="dbo"."orderdetails"."orderid") AND ("dbo"."orderdetails"."productid"="dbo"."products"."productid")) ORDER BY "dbo"."orderdata"."cusid"')}

RELATE [Cusid] TO [UI_GENERATED_PARENT_KEY_COLUMN]) AS [Products]

I use DTS to select data:

SELECT FLATTENED

[T1].[Cusid] AS PRODUCTID ,topcount(PREDICT ( [bh].[Products],INCLUDE_STATISTICS),$probability,5) AS ReProductid

FROM

[bh]

PREDICTION JOIN

SHAPE

{

OPENROWSET

(

…,'SELECT "productid" AS "Cusid" FROM "products" ORDER BY "productid"'

)

}

APPEND

(

{

OPENROWSET

(

…,'SELECT "productid" AS "Cusid_1", "productid" AS "Productid" FROM "products" ORDER BY "productid"'

)

}

RELATE [Cusid] TO [Cusid_1]

)

AS [Products]

AS [T1]

ON

[bh].[Cusid] = [T1].[Cusid] AND

[bh].[Products].[Productid] = [T1].[Products].[Productid]

My result

productid1 productid2

1 2372

1 5422

1 1223

...

2 2372

2 5422

2 1223

.....

3 2372

3 5422

3 1223

...

how can i do ?

i can't write predicts(products,5) or predicts([model name].[products],5) . when i run -> error

If you are useing SQL Server 2000, you cannot use the syntax Predict(Products, 5) as that syntax was introduced in SQL Server 2005.

Your query is correct - I would only say that you don't need to bind "cusid" in the prediction query - you don't really need to alias it to "cusid" either.

Is there something else needed? If you want product names rather than ID's, simply build the models using names

|||

i don't need name products . but productid to recomend is loop and almost it only recomend 5 products when you choose any products in market. ( same set in productid_2, when i use predict(....,5) ).

|||

Here's a few things to try:

1: Look at the trees generated by the model - do they show any patterns? It may be the case that the patterns aren't there to examine.

2: Use $AdjustedProbability instead of $Probability. This will favor products that are less likely to occur. For example, if Milk occurs in 99% of all baskets, it will be the #1 item regardless of what is actually in the basket. $AdjustedProbability takes this into account

3: Increase the values of MAXIMUM_INPUT_ATTRIBUTES and MAXIMUM_OUTPUT_ATTRIBUTES to include all the products in your catalog

|||

first:

i can see patterns. but it doesn't predict productid equal 1 to 150 and some other productid. so when i choose productid in (1,....,150) it show same set.

second:

how i increase the values of maximum _ input and output attributes ( i use wizar to create).

data mining 2000

i want show other products when somebody choose a product,

ect:

product1 product2

A B, C ,D

B C,D,E

C F, G

.......

i create model:

I create a mining model:

CREATE MINING MODEL [bh'S]

([Cusid] LONGKEY,

[Products] TABLE PREDICT ([Productid] LONGKEY

)) USING Microsoft_Decision_Trees

INSERT INTO [bh'S]

(SKIP, [Products] (SKIP, [Productid]))

SHAPE

{OPENROWSET(…, 'SELECT DISTINCT "dbo"."customers"."cusid" AS "Cusid" FROM "dbo"."customers" ORDER BY "dbo"."customers"."cusid"')}

APPEND

( {OPENROWSET(…, 'SELECT DISTINCT "dbo"."orderdata"."cusid" AS "UI_GENERATED_PARENT_KEY_COLUMN", "dbo"."products"."productid" AS "Productid" FROM "dbo"."orderdata", "dbo"."orderdetails", "dbo"."products" WHERE (("dbo"."orderdata"."orderid"="dbo"."orderdetails"."orderid") AND ("dbo"."orderdetails"."productid"="dbo"."products"."productid")) ORDER BY "dbo"."orderdata"."cusid"')}

RELATE [Cusid] TO [UI_GENERATED_PARENT_KEY_COLUMN]) AS [Products]

I use DTS to select data:

SELECT FLATTENED

[T1].[Cusid] AS PRODUCTID ,topcount(PREDICT ( [bh].[Products],INCLUDE_STATISTICS),$probability,5) AS ReProductid

FROM

[bh]

PREDICTION JOIN

SHAPE

{

OPENROWSET

(

…,'SELECT "productid" AS "Cusid" FROM "products" ORDER BY "productid"'

)

}

APPEND

(

{

OPENROWSET

(

…,'SELECT "productid" AS "Cusid_1", "productid" AS "Productid" FROM "products" ORDER BY "productid"'

)

}

RELATE [Cusid] TO [Cusid_1]

)

AS [Products]

AS [T1]

ON

[bh].[Cusid] = [T1].[Cusid] AND

[bh].[Products].[Productid] = [T1].[Products].[Productid]

My result

productid1 productid2

1 2372

1 5422

1 1223

...

2 2372

2 5422

2 1223

.....

3 2372

3 5422

3 1223

...

how can i do ?

i can't write predicts(products,5) or predicts([model name].[products],5) . when i run -> error

If you are useing SQL Server 2000, you cannot use the syntax Predict(Products, 5) as that syntax was introduced in SQL Server 2005.

Your query is correct - I would only say that you don't need to bind "cusid" in the prediction query - you don't really need to alias it to "cusid" either.

Is there something else needed? If you want product names rather than ID's, simply build the models using names

|||

i don't need name products . but productid to recomend is loop and almost it only recomend 5 products when you choose any products in market. ( same set in productid_2, when i use predict(....,5) ).

|||

Here's a few things to try:

1: Look at the trees generated by the model - do they show any patterns? It may be the case that the patterns aren't there to examine.

2: Use $AdjustedProbability instead of $Probability. This will favor products that are less likely to occur. For example, if Milk occurs in 99% of all baskets, it will be the #1 item regardless of what is actually in the basket. $AdjustedProbability takes this into account

3: Increase the values of MAXIMUM_INPUT_ATTRIBUTES and MAXIMUM_OUTPUT_ATTRIBUTES to include all the products in your catalog

|||

first:

i can see patterns. but it doesn't predict productid equal 1 to 150 and some other productid. so when i choose productid in (1,....,150) it show same set.

second:

how i increase the values of maximum _ input and output attributes ( i use wizar to create).

data mining : associate rules

i begin for Data mining ( analysis manager - sql server 2000)
i create some mining model with Microsoft_decision_ trees or Clustering. it's oK
but now i want to create a model to know "If customer 1 has product A in their basket, what products should I recommend ".

i read and see that "Microsoft analysis manager sp1" have support association rules.
i install pack 4. but i don't see anything else . how i create a model with association rules.

SQL Server 2005 provides the Microsoft Association Rules algorithm, which is veryu scalable and designed specifically for this kind of tasks.

However, you can still generate recommendations using SQL Server 2000 by using Decision Trees and a model with a nested table containing the products. An example of such model:

( CustomerID LONG KEY,

Products TABLE PREDICT

(

Product TEXT KEY

)

)

In the model, the Products nested table is used both as input and as output.

The prediction query will look like below:

select FLATTENED

TopCount( Predict([Products], INCLUDE_STATISTICS, EXCLUSIVE), $ADJUSTEDPROBABILITY, 5) FROM MyModel PREDICTION JOIN

(select

(SELECT 'Beer' AS Product UNION

SELECT 'Coke' AS Product) AS Products) as t

ON MyMOdel.Products.Product= t.Products.Product

Please post here any questions you might have

|||thanks, i will try now.

Data mining

Maybe this question has been asked before but I still haven't found the answer.

Is it possible to create a Report with Reporting Services which would be similar to the Cube browser in Analysis Services?

With dynamic data mining directly in the report. I don't want a static report based on a cube. Otherwise it won't be useful to have a cube in my situation.

Thanks

Moving to Reporting Services forum

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Take a look at Report Builder in SQL Server 2005 Reporting Services. This isn't quite the same a a cube browser, but I think you'll find it does address many of the issues you'd be looking at.

Using Report Builder with a Report Model built on top of an Analysis Services cube is pretty easy.

http://msdn2.microsoft.com/en-us/library/ms155933.aspx

-Lukasz

data mining

i want to create a model to predict and show products that customers like when customer visit my website

can i know which product that customer like than other products?

can i list products with order by percent (%) customer like for that product?

The "Create a Web Cross-sell Application" article contains details about implementing such a model (http://www.aspnetpro.com/newsletterarticle/2004/10/asp200410ri_l/asp200410ri_l.asp)

You can use the adjusted probability as a percentage. The predictions are ordered by default