IMMEDIATE ATTENTION PLEASE.....

hi all..
hope u guys can help me out here.....
'm new to .net so hope to get all the basic infomr that would b required...

'm on a proj..basically a data mining proj...
'm using sql 2005 enterprise edn's analysis services to perform my data minning tasks...
here is what i'd like to know....
i've been following the sql online tutorial book...
n as per the tutorial on data minning...i have created a data source ... based on the decision tree algorithm i have even obtained some results..
now.....here is the problem..

i'd like to know if i can actually get all these obtained patterns onto a webpage...
i mean can i actually use asp.net n achieve this task of migrating the patterns generated at the bids to a webpage?

please guys if i can do so...then do tell me how to do so...
my proj dline is in 2 weeks....i need desperate help....
'm waitin...

here is how i vusualize my goal..... web pages that display patterns generated after an analysis has performed......

thxxxx... a ton
hanish

AS includes a set of data mining viewer controls intended for this. You can also query the mining models from RS.

See this topics in Books Online.

Using Analysis Services DMX Query Designer

And this link to download the Data Mining controls:

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

The mining controls are halfway down the page.

|||

...umm...alrite thanks...

but the thing is i really don't wan't to open bids n check out the report.....

i am asking if there is any way how i can view the obtained patters at a report on a webpage without having to open

BIDS ....ll explain my problem ...........

my task is to illustrate data minning using asp.net as the front end and SQL server 2005 entp.as back end.....

BIDS will take care of all the data minning operations that i need to perform...and will generate reports corresponding to various data minning models.......

now i intend to create a UI using asp.net(c# codin.) and then link these web-pages to the already obtained reports.....can i do it without having the user open BIDS?

plzzzzzz plzzzz guys help me.....

thx.....

|||

That functionality is exactly what the data mining controls provide. The user doesn't have to use BIDS to see the results. For that matter, if you develop a report in Reporting Services and deploy it, the user doesn't need BIDS.

For your task, you need to look at the data mining controls. Or you could query directly through ADOMD (an OLEDB provider), but the mining controls handle the visual display for you.

|||

hi jwelch

thx for ur instructions for my problem.......

as per u instructed i d/loaded Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider which i suppose helps provide the data mining controls....... here is an honest appeal...after having installed it i havn't really seen any change or havn't really been able to discover the data mining controls...

i am certain that it is because i am totally new to sql server, i am getting a little nervous if i can really do this task, please would u mind helping me in achieving my task......

i've done minning on the adventure datawarehouse and now have obtained the patterns which i can view in BIDS......i would now like to know the steps i should follow to make use of the data mining controls by which i can migrate these results onto a browser.......you have told me this is possible ...please i have no other option but to take your help do consider my request ......

waiting for your reply..

|||

any body here ...

plzzzzzz help me in figurin my way out.....

mr.john u der?

|||

No, it's not the OLE DB provider. It's the data mining viewer controls. They are about 4 items below the OLE DB provider.

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

Microsoft SQL Server 2005 Datamining Viewer Controls

The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models.
|||

hj wrote:

any body here ...

plzzzzzz help me in figurin my way out.....

mr.john u der?

hanish,

you really need a course on forum ettiquette: don't demand things, don't write all in capitals (your subject line), and don't expect people to do your work for you.

What exactly are you wanting? It seems to me that you want to know how to run or request reports from within a standard ASP.Net page?

|||

i do apologize ,

yup sluggy u got my prob rite......im tryin to run the results i got after the minin operation from within a std asp.net page..

hey..n thx ...mr.john....

|||

hi ...'m back again with my nt so good doubts..

;m stuck on thiz one thing mr.john...........

after havning installed the data mining viewer controls what is my next step....i mean i don't even see these contrls in my web dvlpr toolbar....

after going tro some threads here..i figured out that the nxt step is to add the viewer contrls into the toolkit of visual c# web dvplr.....

but ;m not succesful in doing so.....

jus like i told u before ...my task is to bring out these patters onto a web page.........

one more doubt......

is there any tutorial about what each of these web contrl does? whr can i learn more bout these controls......are there any sample videos i could get access to, to actually know more about how to use these controls....

please help me ....thx a lot

hanish|||

hj wrote:

hi ...'m back again with my nt so good doubts..

;m stuck on thiz one thing mr.john...........

after havning installed the data mining viewer controls what is my next step....i mean i don't even see these contrls in my web dvlpr toolbar....

after going tro some threads here..i figured out that the nxt step is to add the viewer contrls into the toolkit of visual c# web dvplr.....

but ;m not succesful in doing so.....

jus like i told u before ...my task is to bring out these patters onto a web page.........

one more doubt......

is there any tutorial about what each of these web contrl does? whr can i learn more bout these controls......are there any sample videos i could get access to, to actually know more about how to use these controls....

please help me ....thx a lot

hanish

Have you looked in your C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder? You may need to install the SQL Server Samples to use this.

|||

yup...dat is de exact prob....i did install dm viewer controls but den din find a samples folder under \Program Files\Microsoft SQL Server\90.......

now i did install all the samples that came with the sql cd..could u tell me whr i could download these samples from the net.....

my sincere thanks mr john..

feel like ur the only one replyin to my posts here..

thx again.......

hanish

|||one more question...'m working with sql server 2005 enterprise edn........do i hav to install sp2 for sql server to achieve my tasks...|||

hj wrote:

yup...dat is de exact prob....i did install dm viewer controls but den din find a samples folder under \Program Files\Microsoft SQL Server\90.......

now i did install all the samples that came with the sql cd..could u tell me whr i could download these samples from the net.....

my sincere thanks mr john..

feel like ur the only one replyin to my posts here..

thx again.......

hanish

This link has the lastest sample applications for SQL Server.

http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

|||

hj wrote:

one more question...'m working with sql server 2005 enterprise edn........do i hav to install sp2 for sql server to achieve my tasks...

I don't think it is required. However, the samples I referenced above have been updated for SP2.

IMMEDIATE ATTENTION PLEASE!!!

hi all..
hope u guys can help me out here.....
'm new to .net so hope to get all the basic infomr that would b required...

'm on a proj..basically a data mining proj...
'm using sql 2005 enterprise edn's analysis services to perform my data minning tasks...
here is what i'd like to know....
i've been following the sql online tutorial book...
n as per the tutorial on data minning...i have created a data source ... based on the decision tree algorithm i have even obtained some results..
now.....here is the problem..

i'd like to know if i can actually get all these obtained patterns onto a webpage...
i mean can i actually use asp.net n achieve this task of migrating the patterns generated at the bids to a webpage?

please guys if i can do so...then do tell me how to do so...
my proj dline is in 2 weeks....i need desperate help....
'm waitin...
thxxxx... a ton
hanish

i'd like to code in c#...so plzz tell me a way out of this prob.....|||

if you dump your results into a table you can report against it using .net tools like OWC (i. e. FrontPage, Excel, RS).

Also, here is the link to the article on how to build a model dynamically:

http://www.aspnetpro.com/newsletterarticle/2004/10/asp200410ri_l/asp200410ri_l.asp

|||

my task is to illustrate data minning using asp.net as the front end and SQL server 2005 entp.as back end.....

BIDS will take care of all the data minning operations that i need to perform...and will generate reports corresponding to various data minning models.......

now i intend to create a UI using asp.net(c# codin.) and then link these web-pages to the already obtained reports.....can i do it without having the user open BIDS?

plzzzzzz plzzzz guys help me.....

thx.....

|||

Included with SQL Server as a sample are the sample Data Mining web viewers - I think this should give you what you need. You can see them in action by launching the sample from here http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/52.aspx

Also you can render your results as a report using the example here:

http://blogs.msdn.com/jamiemac/archive/2006/06/22/642541.aspx

|||hello Hanish,,,
i need decision tree code in c#,if u have plz help me.........
nd reply me at innocent_desire_89@.hotmail.com,waitng 4 ur reply
tcsql

Image data read from SQL Server does not show up

Hi Guys,

I've been strugling with this problem all morning today.

Basically I store images in SQL Server 2000 database and then whould like to show them with

<img src="http://pics.10026.com/?src=viewImage.aspx?image_id=10" border=1>

My table structure is setup this way

TABLE [userImages] (
[imageFilename] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[imageContentType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[imageFileSize] [bigint] NULL ,
[imageFileImage] [image] NULL )

and in viewImage.aspx I have:

if (dr.Read())
{
Response.ContentType = dr.GetString(dr.GetOrdinal("imageContentType"));
Response.BinaryWrite( (byte[]) dr["imageFileImage"] );
}

I have no prolems retrieving the data from DB. But the image does not display(in IE it shows a broken link image)

What's even more puzzling is I CAN display the same image from HDD like so:

FileStream fs = File.OpenRead("D:\\my_image.png");
byte[] buffer = new byte[fs.Length];
fs.Read(buffer, 0, buffer.Length);
fs.Close();
Response.ContentType = "application/octet-stream";
Response.BinaryWrite(buffer);

Am I missing something very obvious. I tried playing around with different ContentType's same result.

In my case I am forced to store images in the DB.

I've seen other examples on the net and theirs work. Please help.

Sincerely,
Vlad OrlovskyI found code very similar to yours in an article written by Dave Wanta:Retrieving Images from a Database ( C# ) - Part II

I adapted the code slightly to display the logo from the pub_info table in the Pubs database, and it worked fine for me (code below).

My gut feeling is that the ContentType you are using might not be correct?

using System;
using System.Collections;
using System.Configuration;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace CSharpTest
{
public class ViewImage : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
//build our query statement
string sqlText = "SELECT logo, 'image/gif' AS contenttype FROM pub_info WHERE pub_id = @.pub_id ";
SqlConnection connection = new SqlConnection( "server=(local);database=pubs;Trusted_Connection=yes");
SqlCommand command = new SqlCommand( sqlText, connection);
command.Parameters.Add(new SqlParameter("@.pub_id", SqlDbType.Char,4)).Value=Request.QueryString["img"];
//open the database and get a datareader
connection.Open();
SqlDataReader dr = command.ExecuteReader();
if ( dr.Read()) //yup we found our image
{
Response.ContentType = dr["contenttype"].ToString();
Response.BinaryWrite( (byte[]) dr["logo"] );
}
connection.Close();
}
}
}

Terri

IIS crash and format

Hi

due to big problems (basically since a couple of month iis service crash
several times a day) i need to format a web server (win2k, sp4, iis5.0)
where all our sites are hosted .
To avoid downtime i would like to transfer them all on the new server.
Do i have to recreate every single web (with a lot of virtual folders ) or
there is an automatic (semiautomatic) way to migrate them all?
Many thanks in advance
Marco"Marco M. Danni" <mmdanni@.netbrokers.it> wrote in message
news:WAgfb.6952$e6.211030@.twister2.libero.it...
> Hi
> due to big problems (basically since a couple of month iis service crash
> several times a day) i need to format a web server (win2k, sp4, iis5.0)
> where all our sites are hosted .
> To avoid downtime i would like to transfer them all on the new server.
> Do i have to recreate every single web (with a lot of virtual folders ) or
> there is an automatic (semiautomatic) way to migrate them all?
> Many thanks in advance

This has nothing to do that I can see with SQL Server, but in theory if you
back them up in the ISS Enterprise Manager and find the file (I can't recall
exactly where it is, but it's like %systemroot%\system32\inetsrv\backup),
copy that to the new machine and load it, you'll get your metabase intact.
DLLs will not necessarily be loaded though (say Cold Fusion, etc.)

> Marco|||sorry...my fault

"Greg D. Moore (Strider)" <mooregr@.greenms.com> ha scritto nel messaggio
news:Othfb.10709$LI.8014@.twister.nyroc.rr.com...
> "Marco M. Danni" <mmdanni@.netbrokers.it> wrote in message
> news:WAgfb.6952$e6.211030@.twister2.libero.it...
> > Hi
> > due to big problems (basically since a couple of month iis service crash
> > several times a day) i need to format a web server (win2k, sp4, iis5.0)
> > where all our sites are hosted .
> > To avoid downtime i would like to transfer them all on the new server.
> > Do i have to recreate every single web (with a lot of virtual folders )
or
> > there is an automatic (semiautomatic) way to migrate them all?
> > Many thanks in advance
> This has nothing to do that I can see with SQL Server, but in theory if
you
> back them up in the ISS Enterprise Manager and find the file (I can't
recall
> exactly where it is, but it's like %systemroot%\system32\inetsrv\backup),
> copy that to the new machine and load it, you'll get your metabase intact.
> DLLs will not necessarily be loaded though (say Cold Fusion, etc.)
>
> > Marco

IIF and multi-valued parameters

Hi

i have a report that can show upto 8 charts, dependant on the selection(s) made in a multi-valued parameter.

basically, the report gets loads of data back from DataCube.

if the user has selected (for example) 2 categories in the multi-valued parameter (e.g. "beverages" & "confectionary") , the the first chart will show the results filtered for "beverages" and the second chart will show the results for the "confectionary" category.

but

i want to hide any charts that are not used - i.e. the user only selects 3 categories, i want to show 3 and hide 5 charts and am trying to do this with IIF in the FILTER properties of the chart

so for each chart, i am checking to see if a Category selection has been made for that chart - and if it has, filter the results and display the chart. if no selection has been made, then filter the results for "XXXXX" (no data with this category)

am doing this by trying to get the selected value or "xxxxx" if noting selected

to hide the second chart when only one category has been selected, tried

e.g. for the third chart

=iif(

Parameters!LOOKUPITEMCategoryDescription.count>2,

Parameters!LOOKUPITEMCategoryDescription.Label(2),

"xxxxx")

doesnt work - gives an #Error as a reult

But it works fine when there are > 2 categories selected

also

this works fine when there is 2 or >2 category selected

=iif(

Parameters!LOOKUPITEMCategoryDescription.count>2,

"more than 2",

"not more than 2")

it would appear that IIF is trying to evaluate the TRUE condition(Parameters!HydraCORELOOKUPITEMCategoryDescription.Label(2)) even though the condition is false !!!

help please

thx

IIf evaluates everything in the expression and does not employ shortcutting. This means the expression Parameters!LOOKUPITEMCategoryDescription.Label(2) will cause a problem if there are less than two items selected, because it is evaluated regardless. This means that you will need to change the way you check if a parameter option has been selected, maybe by doing an InStr() on Parameters!LOOKUPITEMCategoryDescription, or by calling a function with the parameter and looping safely through it in the function.

Also, i would think it is better to hide you chart with an expression in the Visibility|Hidden property rather than trying to use the Filters property.

|||

You have to use your report code to achieve this. Have a global variable of type object array in your code and write a function in the code which will receive an object array and store it in the global variable. Then have an invisible textbox at the top of your report and call this function from the textbox expression like Code.YourFunction(Parameters!LOOKUPITEMCategoryDescription.Value).

Then write another function in the code which will receive the index and check if the count of the items in the object array is greater than the received index and return the appropriate item from the object array. Call this function in your Filter expression of the chart.

If you need example about how to do it, please let me know.

Shyam

|||

sluugy & Shyam

thx for this - should have posted an answer as i had already realised about vb evaluating the whole expression in IIF and written the function as described

thx

m