This is a migrated thread and some comments may be shown as answers.

How to using Chart with CubeDataSource

3 Answers 34 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Dario
Top achievements
Rank 2
Dario asked on 18 Jun 2012, 10:00 AM
Hi to all,
I've this problem, I created a CubdeDataSource, my MDX query replay me 4 columns:
  1. Activities
  2. All
  3. Customer
  4. Contact

The first is a dimension that aggregate the visit of salesperson by a particular tipology called Activities (a simple category),
moreover the other dimension is "Type" that has 2 values: Customer and Contact, that aggregates the visits of salespersone based if is customer or contact.
And then the level "All" of dimension "Type" but I'm not interessed.

Now on telerik report I put a char, set a CubeDataSource and specify 2 Series that link to Customer and Contact. Ok!

But now I would show label using Actitivites column. What can I do?

PS: I've attached: result set of MDX query, and chart (evidence in blue)

3 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 21 Jun 2012, 12:29 PM
Hi Dario,

You can use the PlotArea -> XAxis -> DataLabelsColumn property to specify the Activities column for the XAxis labels.

Regards,
Steve
the Telerik team

FREE WEBINAR ON THE NEW REPORT DESIGNER! Join us on Friday, June 29 at 10:00 AM for a comprehensive demo of the official version of the standalone Report Designer and find out how easy it is to empower your users with creating, editing and sharing ad-hoc reports. The webinar will go through a real-world scenario of creating reports, embedding them in your application(s), and distributing them within your organization. We will also cover the newly added support for sub-reports, navigation actions (such as drill-down and drill-through), and report sources. Register here and bring your questions with you. We’ll try to address them during the webinar! You may even win a Telerik Ultimate Collection license! Register today >>

0
Asutosh
Top achievements
Rank 1
answered on 30 May 2014, 06:38 AM
hi
i am using following code for to bind cube datasource to chart bt its not working

 cubeDataSource.ConnectionString = " Data Source=localhost;Initial Catalog=SSASTest;Persist Security Info=False";
  cubeDataSource.SelectCommand = "select non empty {[Measures].[Measure_AvgMonthlyCost]} on columns,non empty {[Beneficiary Aco Physician Rel].[TIN Legal Business Name].children} on rowsfrom [ACODW2045]";
       
        radhtmldemo.DataSource = cubeDataSource;
        radhtmldemo.PlotArea.XAxis.DataLabelsField = "Gender";
        radhtmldemo.PlotArea.Series[0].DataFieldY = "CountbeneHicNo";

help me to bind chart using cube datasource
0
Stef
Telerik team
answered on 02 Jun 2014, 01:43 PM
Hi Asutosh,

Details how to configure your project and connect to an OLAP database are available in the following articles:
Then you can add a series to the Chart item and set the corresponding  DataXColumn and DataYColumn properties - Data Binding Chart.

All above steps can be done using the Report Designers of older Telerik Reporting versions where the Chart item is not yet obsolete and is available in the Toolbox. Of course you can use Copy/Paste operation from the Report Designers' Context Menu and copy a Chart item from an older report.

Regards,
Stef
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
General Discussions
Asked by
Dario
Top achievements
Rank 2
Answers by
Steve
Telerik team
Asutosh
Top achievements
Rank 1
Stef
Telerik team
Share this question
or