Datamining for ntext

Is there any way to datamine using ntext? I'm trying to run some BI on some email messages -- seeing if it can accurately classify email into the proper folder. Currently, I get complains that ntext isn't comparable.

Is this scenario supported?

You will need to use Integration Services to preprocess the messages into terms and phrases using the Term Extraction and Term Lookup transforms. From there, you can use the algorithms to perform classification. FYI, Logistic Regression tends to have good results for these types of problems.|||Thanks.

Say I have extracted terms from both subject and body. Thus, I have two sets of terms. Lets also say that I have a table with data conetaining all the header information.

How do I feed all three of these sets (subject terms, body terms, and header data) into a datamining transform?|||

It depends on what you really want to do. You can merge them using merge transforms in Integration Services to do term extraction. On the term lookup side, you can do the same. However, you may want to output the results of the different sets to different tables so you can seperate their inputs as input to a mining algorithm.

For example, the phrase "Data Mining" in the subject may have different predictive power than "Data Mining" in the body.

Note that Integration Services does not support nested tables. To implement such a process, your SSIS pipeline will have to put the data into tables that you mine using the Analysis Services project user interface.

Data-Driven Subscription Link

Hi,
I'm setting up a data driven subscription for a report. I'm using email as
the delivery option, am NOT including the report in the email, instead using
the hyperlink feature to bring the user to the report on the server. I
tested it out and I received the email with the link but the link displays
the full address of the server, report path and parameters to the recipient.
We designed the system to use URL access and hidden parameters to hide all
paths and parameter options from the user, how can we have the link in the
email display something like: "Click here to view report" instead of:
http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
It is very important to my company that we hide this string from the user.
thank you
JerryI'm not sure how you could accomplish this. Even if we put just the text
you suggest and make it a hyperlink, the url would still be visible to the
user. You could always modify the comments section to include html and put
the hyperlink in yourself, but this would not hide the parameter.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry" <idroppeddabomb@.hotmail.com> wrote in message
news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm setting up a data driven subscription for a report. I'm using email as
> the delivery option, am NOT including the report in the email, instead
using
> the hyperlink feature to bring the user to the report on the server. I
> tested it out and I received the email with the link but the link displays
> the full address of the server, report path and parameters to the
recipient.
> We designed the system to use URL access and hidden parameters to hide all
> paths and parameter options from the user, how can we have the link in the
> email display something like: "Click here to view report" instead of:
>
http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> It is very important to my company that we hide this string from the user.
> thank you
> Jerry
>|||We worked around this by displaying the report within a pop-up window that we
instanciated via Javascript. That allowed us to turn off the address bar and
hide the URL. The user could still access it by right-clicking on the page
and going to properties, but at least it's not obvious.
sebring1130
"Daniel Reib [MSFT]" wrote:
> I'm not sure how you could accomplish this. Even if we put just the text
> you suggest and make it a hyperlink, the url would still be visible to the
> user. You could always modify the comments section to include html and put
> the hyperlink in yourself, but this would not hide the parameter.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jerry" <idroppeddabomb@.hotmail.com> wrote in message
> news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I'm setting up a data driven subscription for a report. I'm using email as
> > the delivery option, am NOT including the report in the email, instead
> using
> > the hyperlink feature to bring the user to the report on the server. I
> > tested it out and I received the email with the link but the link displays
> > the full address of the server, report path and parameters to the
> recipient.
> > We designed the system to use URL access and hidden parameters to hide all
> > paths and parameter options from the user, how can we have the link in the
> > email display something like: "Click here to view report" instead of:
> >
> http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> > It is very important to my company that we hide this string from the user.
> >
> > thank you
> >
> > Jerry
> >
> >
>
>|||In another situation, I didn't care that the URL was visible, I just had one
particular parameter that I couldn't allow the users to see (the username).
I solved this problem by "encrypting" that parameter. I created a simple SQL
function where I pass in the username, it manipulates the string a little and
then returns the SOUNDEX of the manipulated string. I used the function when
creating the data for the report and then again when selecting the parameters
for the data-driven subscription. I published the report, then went to
Report Manager and checked the "Prompt User" checkbox then set the "Prompt
String" to null. That allows me to send out the URL in the subscription
e-mails that are generated because the parameter value is meaningless to the
user (they see 'S165' instead of 'sebring', for example). They can click on
the URL link and the report comes up for them, but because the "Prompt
String" is set to null in the subscription, they cannot change that
parameter. It worked perfectly for what we needed.
sebring1130
"sebring1130" wrote:
> We worked around this by displaying the report within a pop-up window that we
> instanciated via Javascript. That allowed us to turn off the address bar and
> hide the URL. The user could still access it by right-clicking on the page
> and going to properties, but at least it's not obvious.
> sebring1130
>
> "Daniel Reib [MSFT]" wrote:
> > I'm not sure how you could accomplish this. Even if we put just the text
> > you suggest and make it a hyperlink, the url would still be visible to the
> > user. You could always modify the comments section to include html and put
> > the hyperlink in yourself, but this would not hide the parameter.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Jerry" <idroppeddabomb@.hotmail.com> wrote in message
> > news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> > > Hi,
> > >
> > > I'm setting up a data driven subscription for a report. I'm using email as
> > > the delivery option, am NOT including the report in the email, instead
> > using
> > > the hyperlink feature to bring the user to the report on the server. I
> > > tested it out and I received the email with the link but the link displays
> > > the full address of the server, report path and parameters to the
> > recipient.
> > > We designed the system to use URL access and hidden parameters to hide all
> > > paths and parameter options from the user, how can we have the link in the
> > > email display something like: "Click here to view report" instead of:
> > >
> > http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> > > It is very important to my company that we hide this string from the user.
> > >
> > > thank you
> > >
> > > Jerry
> > >
> > >
> >
> >
> >

Datadriven Subscription - Web Archive Improper formatting

Hi All,

I have a data driven subscription with Web Archive rendering format.

(SQL Reporting Service 2000). When a user gets this email, the format is not alligned properly, even, lines are missing in the report.

What could be the problem, is this a known issue? if yes, any patches available?

Please help me.

Thanks,

Nagesh

There are no replies to this query since one week...

Is this a silly query or tough one...