Data not getting plotted in line graph

Hi,
I have a LINE chart with 2 data fields, and 1 category field.
I havent included any series field in the chart.
If the query returns more than 1 records then both the data field values are
getting plotted in the graph.
If the query returns only one record then only the first data point is
plotted. I dont know why the value for second data field is not plotted...
Is it a bug in reporting services?
Please any one reply me asap... I have to fix it for the client by today...
Thanks for help...
Regards,
RanjithTo add more information,
if i change the chart type to any other chart other then LINE graph, it is
getting plotted. Only for Line graph its not working...
Thanks,
Ranjith
"Ranjith Prakash" wrote:
> Hi,
> I have a LINE chart with 2 data fields, and 1 category field.
> I havent included any series field in the chart.
> If the query returns more than 1 records then both the data field values are
> getting plotted in the graph.
> If the query returns only one record then only the first data point is
> plotted. I dont know why the value for second data field is not plotted...
> Is it a bug in reporting services?
> Please any one reply me asap... I have to fix it for the client by today...
> Thanks for help...
> Regards,
> Ranjith
>
>|||Please read this recent thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=a3bce317-0626-47f4-9ec2-aebe559a41b3&sloc=en-us
It sounds like you have a very similar situation. You can either request the
SP1-based hotfix or use SP2 Beta (http://support.microsoft.com/kb/842440) or
wait till the official release of SP2.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ranjith Prakash" <Ranjith Prakash@.discussions.microsoft.com> wrote in
message news:158BA878-86E5-4D17-93F1-E19F79350E92@.microsoft.com...
> To add more information,
> if i change the chart type to any other chart other then LINE graph, it is
> getting plotted. Only for Line graph its not working...
> Thanks,
> Ranjith
> "Ranjith Prakash" wrote:
> > Hi,
> >
> > I have a LINE chart with 2 data fields, and 1 category field.
> > I havent included any series field in the chart.
> >
> > If the query returns more than 1 records then both the data field values
are
> > getting plotted in the graph.
> >
> > If the query returns only one record then only the first data point is
> > plotted. I dont know why the value for second data field is not
plotted...
> >
> > Is it a bug in reporting services?
> > Please any one reply me asap... I have to fix it for the client by
today...
> >
> > Thanks for help...
> >
> > Regards,
> > Ranjith
> >
> >
> >|||Hi Robert,
Thanks a lot for helping me. That did fix my bug.
Thanks again,
Ranjith
"Robert Bruckner [MSFT]" wrote:
> Please read this recent thread:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=a3bce317-0626-47f4-9ec2-aebe559a41b3&sloc=en-us
> It sounds like you have a very similar situation. You can either request the
> SP1-based hotfix or use SP2 Beta (http://support.microsoft.com/kb/842440) or
> wait till the official release of SP2.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ranjith Prakash" <Ranjith Prakash@.discussions.microsoft.com> wrote in
> message news:158BA878-86E5-4D17-93F1-E19F79350E92@.microsoft.com...
> > To add more information,
> >
> > if i change the chart type to any other chart other then LINE graph, it is
> > getting plotted. Only for Line graph its not working...
> >
> > Thanks,
> > Ranjith
> >
> > "Ranjith Prakash" wrote:
> >
> > > Hi,
> > >
> > > I have a LINE chart with 2 data fields, and 1 category field.
> > > I havent included any series field in the chart.
> > >
> > > If the query returns more than 1 records then both the data field values
> are
> > > getting plotted in the graph.
> > >
> > > If the query returns only one record then only the first data point is
> > > plotted. I dont know why the value for second data field is not
> plotted...
> > >
> > > Is it a bug in reporting services?
> > > Please any one reply me asap... I have to fix it for the client by
> today...
> > >
> > > Thanks for help...
> > >
> > > Regards,
> > > Ranjith
> > >
> > >
> > >
>
>

data mining viwer

i want to ask how i can deal with data mining viewr to viwe result

on excel file or on application (get just the chart dynimaclly )

( export or import it )

thanks

Can you please clarify your question?

When browsing existing model using DM Excel add-in you can copy data from viewer to Excel spreadsheet by clicking "Copy to Excel" button. Is this what you are looking for?

(Without add-ins, you can copy viewer data to the clipboard and paste it to other applications such as Excel, Word, notepad etc).

Tatyana

|||first thanks in know after i put the Q about add ins
but without add-ins how i can copy viewer data to the clipboard in dynamic way
not manual

my regards
|||

I will be able to help you better if you tell me more about your scenario and what you are trying to achieve.

Do you have viewer hosted inside your application and you want to get information from the viewer to present it differently?

May be you can call the same store procedures viewers are calling to get the information?

Tatyana

data mining viwer

i want to ask how i can deal with data mining viewr to viwe result

on excel file or on application (get just the chart dynimaclly )

( export or import it )

thanks

Can you please clarify your question?

When browsing existing model using DM Excel add-in you can copy data from viewer to Excel spreadsheet by clicking "Copy to Excel" button. Is this what you are looking for?

(Without add-ins, you can copy viewer data to the clipboard and paste it to other applications such as Excel, Word, notepad etc).

Tatyana

|||first thanks in know after i put the Q about add ins
but without add-ins how i can copy viewer data to the clipboard in dynamic way
not manual

my regards
|||

I will be able to help you better if you tell me more about your scenario and what you are trying to achieve.

Do you have viewer hosted inside your application and you want to get information from the viewer to present it differently?

May be you can call the same store procedures viewers are calling to get the information?

Tatyana

data mining lift chart problem on vs2005

Hello . Because of my graduation project , I interested in data mining application , Adventureworks DW on MS VS 2005 . I opened File->Open->project/solution ->Enterprise -> AdventureworksDW .then I successfully deployed the algorithms decision tree and Clustering . Then I opened tab Mining Accuracy Chart then selected input table "testing" , which I had created before , from vTargetMail . After that , mining structure table and target mail table has automaticaly linked each other .Next , I selected predictive input as 1 , of the predictable row "BikeBuyer" . But , when I clicked "Lift Chart ", I only got a 45 degree line , everytime .. How can I fix it ?

It depends - how many rows are in your test set? What do the threes and clusters look like - do they make sense? Maybe there's something wrong with your test data? What shows up in the chart legend - the models you created? What shows up in the floating/docked mining legend when you click on the chart?

I'll need some more information to help you with the issue.

Thanks

-Jamie

|||

I have table LG_131_01 having 2500 rows and I am using algorithms as shown below .

Clustering Algorithm:

Decision Tree Algorithm:

Naive Bayes Algorithm:

and Association Rules Algorithm:

But when I click to "Lift Chart"

I got the following error ..

Failed to execute the query due to the following error:

XML for Analysis parser: The XML for Analysis request timed out before it was completed.
Execution of the managed stored procedure GenerateLiftTableUsingDatasource failed with the following error:

Exception has been thrown by the target of an

invocation.Microsoft::AnalysisServices::AdomdServer::AdomdException.

Please help ..

|||I am still waiting , please help ..|||

The timeout exception issues can be fixed by changing the query execution timeout.

In BI Dev Studio, the Tools menu, select Options, then Business Intelligence Designers. There, change the Query Timeout property. The value should be specified in seconds. A value of 3600 (one hour) should be enough even for the most complex models

Hope this helps

|||

Sir I did your suggestion , it suceed . But now I only got the 45 degree line , comparing Decision trees alg and clustering algorithms . Is it strange ? Why do I get ideal model line like as two algs ? As seen above , testing results were fine .. And I have got table having enough rows of data 2591 rows of data ... Or does the program has a bug ?

|||

The only time I've seen this happen is with using a bad testing set (e.g. using the predicted results as a testing set).

What happens when you use the training set as the testing set? Or try the other form of the lift chart (using a specific state)?