How to using Chart with CubeDataSource

[Dario]

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)

[Steve]

Hi Dario,

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

Regards,
Steve
the Telerik team

[Asutosh]

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

[Stef]

Hi Asutosh,

Details how to configure your project and connect to an OLAP database are available in the following articles:

• Configuring your project for using Microsoft Analysis Services
• Connecting the CubeDataSource component to an OLAP database

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