Pending Review
Last Updated: 25 Apr 2017 16:23 by ADMIN
Created by: Rajan
Comments: 2
Category: PivotGrid
Type: Feature Request
10
Kendo pivotgrid does not allow us to hide 'All' row/column.'All' row/column is not always needed in a OLAP report.  Excel would allow us to hide/eliminate subtotall rows/columns. pivotgrid needs similar functionality. In general emulate Excel pivotgrid functionality in kendo  pivotgrid
Pending Review
Last Updated: 11 Apr 2017 22:39 by ADMIN
Created by: Imported User
Comments: 0
Category: PivotGrid
Type: Feature Request
3
In the .NET for Ajax PivotGrid, you can set a caption for all fields, row and column. This does not seem possible in the kendo based version (MVC). The only property I see on a column or row is if we want it expanded by default or not.

Here is how it is done on the Webforms version of the control

 <Fields>
                <telerik:PivotGridRowField DataField="Rep" ZoneIndex="1" Caption="Rep" 
                </telerik:PivotGridRowField>
Pending Review
Last Updated: 28 Feb 2017 22:07 by ADMIN
In SSAS world you can often see mega cubes with many measures and dimensions. Currently Kendo pivot grid configurator does not show measure groups and therefore there is no way to filter dimensions and filters that belong to a specific measure group.
Pending Review
Last Updated: 24 Feb 2017 09:45 by ADMIN
Now if you set filterable true for KendoPivotGrid you get two options - Include Fields and Fields Filter.
In some cases you need only one of this options and it is not good to be with one option - filterable. 
Completed
Last Updated: 15 Feb 2017 09:14 by ADMIN
Created by: n/a
Comments: 0
Category: PivotGrid
Type: Feature Request
3
Completed
Last Updated: 15 Feb 2017 09:12 by ADMIN
Created by: Alexandru
Comments: 2
Category: PivotGrid
Type: Feature Request
5
Currently the Kendo PivotGrid always starts out with one tuple for each dimension on rows and columns, and you can recursively expand members to get to their children. However, even with a moderately deep hierarchy, this quickly consumes a lot of screen real estate.

It would be useful to have the option to drill-down in addition to expand. I understand that it's not an easy feature to design and implement, mainly due to the merging of cells that occurs when expanding, which is also the reason why the grid must always have one single member on the first level of a dimension on rows/columns; but I'm hoping someone can come up with an idea that would make it easier.

Cheers!
Pending Review
Last Updated: 26 Jan 2017 13:08 by ADMIN
In some applications one may not want  aggregation on some or all dimenions on the pivot grid and jut show the raw data.
Pending Review
Last Updated: 31 Aug 2016 17:12 by ADMIN
An OData feed that supports 'OData Extension for Data Aggregation Version 4.0'
can be queried for all of the information required to populate a PivotGrid
with rows and columns that are paged, sortable (including by different aggregates
of the measures), and filterable, and have all calculations performed on the server.

The pivot grid can be popualted using data obtained from a couple of requests
to a suitable feed -- or feeds.

Suppose we have an OData feed that we'd like to display in a pivot grid. Some of the 
columns in the feed will become dimensions, and some will become measures.
(We may display the same measure more than once, with different aggregates applied.)

In order to display the row/column headings for the pivotGrid we need to select the 
distinct values from the 'dimension' columns. The filtering provided by OData 
allows the row/column headings to be filtered, and even
paged (in both directions). Sorting is more difficult because we want to sort not only 
by the row/column heading values themselves, but also by (aggregates of) the measures.
However, that's a problem for the server side!

In order to populate the body of the table we need to calculate a load of aggregates
from the measure columns in the base dataset for the rows that correspond to visible
row/column headers. We can write a rather long OData $filter expression to obtain 
the required rows from the original OData feed, and then aggregate them.

All of this functionality is available in 'OData Extension for Data Aggregation Version 4.0'.
However, as an interim solution we may establish two 'helper' OData feeds associated
with the original feed: one for the dimensions for populating the row and column headers,
and one for the measures to populate the body of the table. The grid has already
established a convention for asking for aggregates computed on the server,
although this can be overridden using parameterMap anyway.
Pending Review
Last Updated: 03 Aug 2016 04:46 by ADMIN
As per this post: http://www.telerik.com/forums/pivotgrid-bug

When using PivotGrid with a flat data source the handles for dragging the dimensions are labelled with a different string to the dimension headers.

The dimension headers are labelled with the dataSource.schema.cube.dimensions.[name].caption.

The dimension drag handles are labelled with the dataSource.rows.name (or dataSource.columns.name).

Now, the dataSource.rows.name must be the key in the dataSource.schema.cube.dimensions of the dimension and this must also be a key in each item in the data array -- the field that stores the value of the dimension -- and therefore is in general not suitable for showing to users.

In any case, it seems to me to be a bug that the drag handle is labelled with a different string to the dimension caption.
Pending Review
Last Updated: 22 Jul 2016 14:04 by Sebastian
Created by: Sebastian
Comments: 0
Category: PivotGrid
Type: Feature Request
2
If i have a hierarchy location, for example country, city and postal code, i can only use location as field and can't use country, city or postal code. If i want to use them indiviually i would have to configure them as extra attributes in the olap schema.

It would be nice, if these hierarchies could be used as fields.
Pending Review
Last Updated: 11 May 2016 14:53 by ADMIN
Add format configuration for Pivot schema rows and columns. Like aggregates config.
Pending Review
Last Updated: 11 May 2016 13:23 by ADMIN
Created by: Juliana
Comments: 0
Category: PivotGrid
Type: Feature Request
2
Make the COUNT measure count only distinct itens on PivotGrid. For instance, let's say we have a dataSource like this:

var dados = [{ PersonID: 2958, Address: "5h St"},{ PersonID: 2958, Address: "​Lexington Ave"},{ PersonID: 2958, ​Address: "76th Street"}]

Note that it is only 1 person, which has 3 address.. if I wanted to use the COUNT measure on the Address, it is correct (it counts 3 itens). But when I use the COUNT measure on the PersonID, it also counts 3 itens, but there is only one personID. I think it should count distinct values for the data in the measure.
Pending Review
Last Updated: 11 May 2016 13:10 by ADMIN
On a screen, showing the totals to the left and bottom of the data it summarizes makes no sense.

When a user drills through a data set, the totals are the deciding factors for which nodes to expand.
Pending Review
Last Updated: 11 May 2016 12:55 by ADMIN
Created by: Sebastian
Comments: 1
Category: PivotGrid
Type: Feature Request
3
It would be nice to have a chart chooser for the PivotGrid build in (a dropdown that i can place anywhere). At the moment it is really difficult to display a PivotGrid in a chart or even change the chart type on the fly. This and the convertion to a chart could be build in so every developer don't need to worry about this.

What i visualize is a dropdown menu which shows all posible chart types. If i choose one, the pivot grid disapears and on it's position the choosen chart apears (optional with the PivotConfigurator in the side). From a chart i can switch back to the pivot grid or choose another chart type.
Pending Review
Last Updated: 11 May 2016 12:51 by ADMIN
Currently measures are displayed as dimensions and there is no visual difference  between them.
I suggest you showing measures as a very first item in the pivot grid configurator. Also please use a  meaningful icon for this item.
Pending Review
Last Updated: 11 May 2016 10:09 by ADMIN
Created by: Rajan
Comments: 1
Category: PivotGrid
Type: Feature Request
2
Kendo pivotgrid should show non-empty members in filters - currently when we open the row or column filter to see the members in the dimension all the members in the dimension seem to be shown. At least we need a field to let us indicate that the filter entries should be filtered out using 'non empty' clause.
Pending Review
Last Updated: 11 May 2016 09:24 by ADMIN
Created by: Rajan
Comments: 4
Category: PivotGrid
Type: Feature Request
2
Kendo pivotgrid - clicking on a data cell should produce correct row/column/filter items info so that the info can be used for custom drilldowns and drillthroughs.  Currently the info produce by cells defined by All row/column is incorrect in the interior of the pivotgrid
Pending Review
Last Updated: 11 May 2016 07:34 by ADMIN
Created by: Sebastian
Comments: 3
Category: PivotGrid
Type: Feature Request
6
At the moment it's possible to drag & drop fields into the grid. But it's not possible to set the field at a specific position. That is very unusual.

I would expect to see a position marker while hovering with a fields over the drop area. When ein drop the field it goes there where the marker was.
Pending Review
Last Updated: 10 May 2016 17:09 by ADMIN
Advanced functionality in xml/a binding should be available to local binding. Also ability to define new binding protocols.
1 2