Questions about RadPivot and Olap; RadPivot and Chart Integration

2 posts, 0 answers
  1. Luis Gilbert
    Luis Gilbert avatar
    15 posts
    Member since:
    Jul 2009

    Posted 30 Mar 2013 Link to this post

    Hi, I'm testing Radpivot for silverlight and performance looks great.
    Now, I have some questions:

    1) When working with OLAP Microsoft Analysis Services cubes, RadpivotFieldList  shows default names for dimensions, measures, KPI, etc... is it possible to show cube translations instead of default names? Can I specify the default language?

    2) Is there any way to integrate RadPivot with Radcharts? I'm trying take advantage of radpivot (and xmlaDataProvider) to get cube data and show it on  radpivotgrid, plus radcharts.
    Is there a way for RadCharts to use RadPivot's data as itemsource?

    3) We usually work with WCF services for getting data. We are working on a project where user can upload files to a SQL datatable. Then, after files are uploaded, we want users to be able to see those files in a radpivotgrid.
    As we don't know tables structures in advance, WCF service doesn't contain a method/class to query those newly added tables.
    Is there any way to make radpivotgrid to get data from SQL tables? What's the correct approach for this?

    Thanks for your time!

  2. Milan
    Milan avatar
    1989 posts

    Posted 04 Apr 2013 Link to this post


    Currently there is no way to specify language when using our XmlaDataProvider but we have added such task to our todo list for implementation. I have updated your Telerik points for spotting this limitation.

    I am afraid that currently there is no easy way to visualize pivot data with our chart. As soon as we have something ready we will blog about it.

    Regarding you question about data access, as long as you can provide a list of data elements to our LocalDataSourceProvider you should have no problem display any data that is suitable for pivoting. For example, you can easily connect to an SQL server using RIA Services. If the structure of your data is unknown until you actually get it you could use ICustomTypeProvider to creaate object with properties that are created dynamically. You might want to check out the following blog post which illustrate how ICustomTypeProvider can be used: Using ICustomTypeProvider in Silverlight 5 to Display JSON Data and Using ICustomTypeProvider in Silverlight 5 beta with JSON and ASP.NET MVC 3 .

    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Back to Top