How to using Chart with CubeDataSource

4 posts, 0 answers
  1. Dario
    Dario avatar
    61 posts
    Member since:
    Apr 2011

    Posted 18 Jun 2012 Link to this post

    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)
  2. Steve
    Steve avatar
    10940 posts

    Posted 21 Jun 2012 Link to this post

    Hi Dario,

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

    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 >>

  3. Asutosh
    Asutosh avatar
    130 posts
    Member since:
    Sep 2013

    Posted 30 May 2014 in reply to Steve Link to this post

    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
  4. Stef
    Stef avatar
    3610 posts

    Posted 02 Jun 2014 Link to this post

    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.


    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.

Back to Top