Silverlight PivotGrid in UI for Silverlight General Discussions - Telerik Forums

Milan

Admin

1989 posts

Posted 09 Jul 2012 Link to this post

Hi,

Small correction - if you would like to simply choose between ascending or descending ordering you could use the SortOrder property of the respective Desciption. For example:

new PropertyGroupDescription() { PropertyName = "MyProperty", SortOrder = SortOrder.Descending };

Implementing custom IGroupComparer should be considered when you need custom ordering that cannot be achieved by simply setting the SortOrder property.

Greetings,
Milan
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Travis

11 posts

Member since:
Jul 2011

Posted 09 Jul 2012 Link to this post

I'm afraid to ask, but do you have an ETA on the OLAP support. This is a critical feature for us. The IQueryable object is interesting, but I have several cubes that I need to use and I need a pivot that can issue MDX to them. Also, we need this support for silverlight. Please advise on when we can have this feature. Or another alternative that lets me connect to cubes/mdx.

Thanks!

Annie

11 posts

Member since:
Mar 2011

Posted 09 Jul 2012 Link to this post

Hi,

The RadPivotGrid very impress to us.
The only thing that we would to add on is the OLAP Cube/SSAS support, does you all have any time frame for this?
Can we know when will be the RadPivotGrid trial & official release?

Thanks.

Andrea Rapuzzi

31 posts

Member since:
Apr 2010

Posted 10 Jul 2012 Link to this post

Hi Milan,

I'm sorry to inform you that I haven't received an email for the CTP and I don't see the link in the trial page ...

Thanks!
Andrea

James

41 posts

Member since:
Jul 2007

Posted 10 Jul 2012 Link to this post

Hi Milan

Thanks for the detailed reply.

1. I think it is quite important. The Pivot Grid allows the user to summarise various datasets, but once areas of interest are identified, then the ability to investigate further is necessary. Whilst my comment is titled Drill Through.. I dont require the control to provide this feature in its complete form. So long as I could click on a cell and receive an event which provided some details on that cell such as column dimensions and row dimensions, then I can use this to access the data directly from the source system.

For me - Priority 1

2. Telerik currently working on short cut menus to enable use of alternative stats fields. Great. I think this would be my 1st or 2nd priority.

3. Calculated fields - I am happy to wait for this. Lower Priority.

4. THanks for the code - we can make that work.

5. clickable headers.. For example, one data source I have would contain data with dimensions for Job Number, Supplier, Tasks. So one (simplified) use of the Pivot Table would have Job Numbers as Row Headings, Suppliers as Column Headers and Count(Tasks) as the data values. It would be useful to be able to allow the user to click on the Job Number and then navigate to another screen which shows details for that specific Job Number.

6. 7. 8. All about accessing the summarised data. I dont need built in PDF, built in export, or built in charting.. access to the data will meet our requirements, as most of the implementation will be fairly customised.

For me - I think this is the 3rd most important after items 1 and 2 above.

Thanks - as asked by other users - any details on expected beta version, and then full release would be much appreciated.

Milan

Admin

1989 posts

Posted 10 Jul 2012 Link to this post

Hello,

@James - Thank you once again for the wonderful feedback. We will consider all requests and suggestions.

Since there is a huge demand for cube support we have updated our priorities and we will put more effort into this feature and also try to give you bits with cube support as soon as possible. Currently, I cannot commit to a certain date but we will try to have this working in a month or so. We will post more details when we are ready.

Regarding the release cycle of RadPivotGrid, we plan to have an official CTP (which will include additional features and bug fixes) in 2-3 weeks, after that we will have an official Beta. Most probably the Beta will be released with Q3. V1 will be released after the beta phase.

We believe that having CTP and Beta phases is crucial for matching your expectations and providing you with the best pivot control on the market. As you can see, we are pretty flexible about the features that will make it into the official release and we want to make sure that those features are the ones that you really need.

All the best,
Milan
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

carlos

14 posts

Member since:
Sep 2010

Posted 10 Jul 2012 Link to this post

Hi Milan.

Thanks for keeping us updated.

As for the export feature I agree with James, it's not necessary at this point to have a built in - all good looking - export xls,pdf, etc.
A simple datatable (or list of objects of some class of yours) would be fine.
The component we are currently using has an export to file feature but we still create our own exports based on the data that it has because of specific layout needs.

Personally our company has this priorities:
1 - OLAP MDX support
2 - Export data
3 - Possibility to group (merge) selected rows into a single one (our clients have specific needs for this - for example when viewing thousands of rows of products they sometimes see products that are similiar (only colors differ for example) and they want to group all those colors into one single row of that product grouping all those rows to better compare the results along with the other products)
4 - [very low priority]
4.1 public events like:
cell selected
row selected
cell mouse over
4.2 allow adding aditional options to context-menu for a specific cell or set it's custom tooltip
4.3 for debugging purposes - some way of viewing the mdx query being executed

When the new update with olap support becomes available, please let me know and we will start more intensive tests to give you a more accurate and detailed report.

SC

9 posts

Member since:
Nov 2008

Posted 10 Jul 2012 Link to this post

Add me to list please. I would like to evaluate the CTP.
TIA

Hristo

Admin

832 posts

Posted 11 Jul 2012 Link to this post

Hello,

@Andrea and @Peter

You should have received an email with instruction on how to download the CTP bits.
Any feedback is much appreciated.

All the best,
Hristo
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

DerekAlfonso

17 posts

Member since:
Feb 2010

Posted 11 Jul 2012 Link to this post

Hello,

We are very interested in evaluating the PivotGrid - we are currently using the DevExpress version of a PivotGrid but are not particularly happy with it. Can we please get the instructions for installing the CTP?

Thanks!
Bill Vanderpol
Anterra Technology

carlos

14 posts

Member since:
Sep 2010

Posted 11 Jul 2012 Link to this post

@Milan

I forgot to mention another very important - high priority - feature for us:
Ability to export the current "configuration/view" - preferably a xml.

Our clients like to create "views" for repetitive (monthly, etc) analysis, basically they select the measures, dimensions, do the groupings,etc and then they save to their user area on the db the xml that the control we are currently using allows to export. That configuration state (xml) will be loaded each time the user want's to use that view (obviously the xml only contains the settings... the data is fetched from the database uppon loading the xml)

James

41 posts

Member since:
Jul 2007

Posted 11 Jul 2012 Link to this post

Hi

I agree with Carlos about the need to allow the user to make configurations and save them and reuse them. This was my number 9 from our first list.

Thanks

Hristo

Admin

832 posts

Posted 16 Jul 2012 Link to this post

Hello,

We will consider all requested features.
If you think of something else, please let us know.

Kind regards,
Hristo
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Balaji

8 posts

Member since:
Aug 2011

Posted 16 Jul 2012 Link to this post

I would like to evaluate the CTP release of radpivotgrid please.

Regards,
C.Balaji

Milan

Admin

1989 posts

Posted 19 Jul 2012 Link to this post

Hi,

You should receive an email shortly. Thanks you for evaluating the CTP.

Regards,
Milan
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Gopi

4 posts

Member since:
Sep 2012

Posted 19 Jul 2012 Link to this post

Can you please send me the evaluation version of the CTP. I would like to evaluate the RadPivotGrid

Milan

Admin

1989 posts

Posted 20 Jul 2012 Link to this post

Hello,

Thank you for your interest. You should receive an email with more details shortly.

All the best,
Milan
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Travis

11 posts

Member since:
Jul 2011

Posted 30 Jul 2012 Link to this post

Greetings Telerik - I have some questions and requests....

#1 - Need OLAP support

#2 - Need OLAP support ... (didn't copy paste that - very much need this :) ..

#3 - How come none of the demo/examples online shows a user defined filter criteria? When I add some dimension to as a to the "filter" box, it seems to have no effect - i.e., I get no ability to apply my filter. You have some filter example pages, but they are just hard coded button pushes.

#4 – Does this (or will this) pivot control have multi-select hierarchy controls that are similar to excel?

#5 – How much control do developers have over the style of individual parts of the “PivotFieldList”. So for example:

5.1: suppose I have a dimension that I want to show in RED font – Is that possible?

5.2: suppose I want to apply special business logic that removes dimension ‘Y’ from “Row Labels” automatically whenever dimension ‘X’ is added as a filter. Is that possible?

#6 – You point out that this control scales well with large datasets in one of your examples. But what about a massive dimension? For example, suppose I have a dimension with a million members. If I drop this on the Y-Axis, will this control break? If I drop it as a filter, and then uncheck just one item, will this control generate an exclusionary WHERE clause with just that one member? Or will it generate an inclusion list with the other 999,999 members?

#7, #8, #9 #10…. NEED OLAP Support J

Thanks!

toto rto

17 posts

Member since:
Apr 2010

Posted 30 Jul 2012 Link to this post

hello,

please add me to the list so that we can also evaluate this CTP.

thanks

Hristo

Admin

832 posts

Posted 31 Jul 2012 Link to this post

Hello All,

RadPivotGrid is public CTP now (available for ASP.Net, WinForms, WPF and Silverlight) and you can download it from "My Account" by downloading the lastest release (2012 Q2 SP1).

Demos are available here (for SL & ASP.Net):
http://demos.telerik.com/silverlight/#PivotGrid/Layouts
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/firstlook/defaultcs.aspx

Now is the time for feedback so please let us know what you think and what you need.

You can use this corresponding forum:
http://www.telerik.com/community/forums/wpf/pivotgrid.aspx
http://www.telerik.com/community/forums/silverlight/pivotgrid.aspx
http://www.telerik.com/community/forums/aspnet-ajax/pivotgrid.aspx
http://www.telerik.com/community/forums/winforms/pivotgrid.aspx

Regards,
Hristo
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Anan

31 posts

Member since:
Oct 2009

Posted 08 Aug 2012 Link to this post

Hello Hristo

Thanks for the PivotGrid. Is there any plan to include the ability to edit/save/design mdx queries?
Also, we are planning to use Pivot grid in ipads. Do you think we would have pivot grids for html too?

Thanks

Rosen Vladimirov

Admin

648 posts

Posted 10 Aug 2012 Link to this post

Hi,

Currently it is not in our plans to include working with mdx queries. In the moment we are working very hard to provide support for cubes, but we will not have mdx expression editor or render user generated mdx queries. In fact could you share some details why do you need such queries and how do you plan to use them? Maybe we'll find a way to help you with the current planned features. Please share the details and we'll do our best to help you for this problem.
For your second question - the pivot will be available for ASP.NET and it will have support for ipad. Current version is not tested with it, but when we release the official one you shouldn't have any problems using it on ipads.

Thanks for evaluating RadPivotGrid! You can contact us if you have any other questions or suggestions.

Regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Michael Lau

1 posts

Member since:
Aug 2012

Posted 24 Aug 2012 Link to this post

Hi Hristo

"RadPivotGrid is public CTP now (available for ASP.Net, WinForms, WPF and Silverlight) and you can download it from "My Account" by downloading the lastest release (2012 Q2 SP1)."

I can't seem to find any RadPivotGrid related information inside "My Account" nore any download link to the latest release of the RadPivotGrid 2012 Q2 SP1 :(

I did download the TelerikControlPanelSetup_2012_2_809.exe but the RadPivotGrid is not a part of the updates it provides.

Do I need glasses or just some kind of super ninja power access?

Kind Regards
Wolfsberg

Jakub Wilk

32 posts

Member since:
Nov 2003

Posted 24 Aug 2012 Link to this post

asp.net pivotgrid when we can expect example like you already already have in Silverlight version RadPivotFieldList?
when we can expect version of asp.net control that will be able to connect to analysis services cube?

great job and i wait for more;

Rosen Vladimirov

Admin

648 posts

Posted 24 Aug 2012 Link to this post

Hi Michael,

I noticed you have downloaded RadControls for WPF and Silverlight. The RadPivotGrid is part of them so you are able to use them. For more information how to do it you can check our online demos here. Currently we don't have online help so if you face any problems you can contact us directly.

All the best,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Rosen Vladimirov

Admin

648 posts

Posted 27 Aug 2012 Link to this post

Hi Jakub,

You can find examples for asp.net PivotGrid here. The RadPivotFieldList will be ready for Q3 and you'll be able to use it.
Currently we are working on the cube support but we are still not ready to give you exact date when it will be ready.

Thanks for evaluating RadPivotGrid and using RadControls.

Regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Sean

13 posts

Member since:
Sep 2010

Posted 06 Sep 2012 Link to this post

I am interested in any Beta, CTP, or release of any charting or grid components you are working on that will work with Analysis Services.
How can I subscribe for that?

Rosen Vladimirov

Admin

648 posts

Posted 10 Sep 2012 Link to this post

Hi,

Our RadPivotGrid will have OLAP support. In fact it is currently in development and hopefully it will be ready for our Q3 release (in October). You don't have to subscribe for that, you should download our official releases. As the RadPivotGrid is currently in development you can download our latest internal builds as well and use them, because we are trying to include all new features in these builds. You may follow our discussion in this forum and send us your feedback and suggestions how we could improve the RadPivotGrid.

Hopefully this helps.

Kind regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

sv

1 posts

Member since:
Sep 2012

Posted 11 Sep 2012 Link to this post

Hi,
Is there a silverlight version of the RadPivotGrid control?
Thanks.

Rosen Vladimirov

Admin

648 posts

Posted 12 Sep 2012 Link to this post

Hello,

Yes, there is such version. It is still CTP version, but I'm sure you'll find it very interesting and useful. The RadPivotGrid is part of our RadControls for Silverlight package, so if you have it you are able to use the Pivot. You can check our online demos here for more information and some help how to use it. Don't hesitate to contact us if you have any questions or suggestions.

Kind regards,
Rosen Vladimirov
the Telerik team

Time to cast your vote for Telerik! Tell DevPro Connections and Windows IT Pro why Telerik is your choice. Telerik is nominated in a total of 25 categories.