Luis Gilbert
Top achievements
Rank 1
Rank 1
Luis Gilbert
asked on 30 Mar 2013, 06:53 AM
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!
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!
1 Answer, 1 is accepted
0
Hello,
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 .
Greetings,
Milan
the Telerik team
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 .
Greetings,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.