Unplanned
Last Updated: 29 Sep 2021 17:04 by ADMIN
Created by: Vishwas
Comments: 0
Category: PivotGrid
Type: Feature Request
2

Hi Team,

I would like to request Selection/multi-cell drag selection for the Kendo UI PivotGrid. 

Thank you!

Declined
Last Updated: 18 Jun 2021 08:30 by ADMIN
Created by: Defense Me
Comments: 1
Category: PivotGrid
Type: Feature Request
1
Provide support for virtual scrolling.
Unplanned
Last Updated: 17 Dec 2018 12:22 by ADMIN
Created by: Miron
Comments: 1
Category: PivotGrid
Type: Feature Request
2

Setting dimensions in pivot grid with fields of data type "number" or "date" the filter menu opens with conditions and input component as if the fields are of "string" type,  how do I configure the filter menu to act according it's data type. 

In case of date/number data type, in the Include fields filter the selected  items are not persistent - when a user selects some of the values and reenters the include fields the selected values are not saved.

 

Regards

Miron Konrad

Unplanned
Last Updated: 16 Mar 2022 15:21 by ADMIN
Created by: Markus
Comments: 0
Category: PivotGrid
Type: Feature Request
2

I've bound the PivotGrid to a XMLA-WebService (with Mondrian as Backend).

In the Datasource I've defined the error-Function.

When PivotGrid requests Data and Mondrian runs an Exception, following XMLA is transferred:

<?xml version="1.0" encoding="ISO-8859-1"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
<SOAP-ENV:Header>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
  <faultcode>SOAP-ENV:Server.00HSBE02</faultcode>
  <faultstring>XMLA Discover unparse results error</faultstring>
  <faultactor>Mondrian</faultactor>
  <detail>
    <XA:error xmlns:XA="http://mondrian.sourceforge.net">
      <code>00HSBE02</code>
      <desc>The Mondrian XML: Error in executeQuery. Stackdump follows. See SQL logfile for more info.&#13;&#10;Error Stack Dump, time : 22.11.2018 13:19:16&#13;&#10;   com.microsoft.sqlserver.jdbc.SQLServerException: Die Sachbearbeiter-Spalte wurde für &#39;Beschluss&#39; mehrmals angegeben.&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:1879)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:766)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)&#13;&#10;&#9;at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616)&#13;&#10;&#9;at net.abit.base.support.StatementImpl.executeQuery(StatementImpl.java:504)&#13;&#10;&#9;at mondrian.rolap.SqlStatement.execute(SqlStatement.java:201)&#13;&#10;&#9;at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350)&#13;&#10;&#9;at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:303)&#13;&#10;&#9;at mondrian.rolap.SqlMemberSource.getMemberCount(SqlMemberSource.java:149)&#13;&#10;&#9;at mondrian.rolap.SqlMemberSource.getLevelMemberCount(SqlMemberSource.java:142)&#13;&#10;&#9;at mondrian.rolap.SmartMemberReader.getLevelMemberCount(SmartMemberReader.java:158)&#13;&#10;&#9;at mondrian.rolap.RolapSchemaReader.getLevelCardinality(RolapSchemaReader.java:320)&#13;&#10;&#9;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&#13;&#10;&#9;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)&#13;&#10;&#9;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)&#13;&#10;&#9;at java.lang.reflect.Method.invoke(Method.java:498)&#13;&#10;&#9;at mondrian.rolap.RolapUtil$2.invoke(RolapUtil.java:111)&#13;&#10;&#9;at com.sun.proxy.$Proxy33.getLevelCardinality(Unknown Source)&#13;&#10;&#9;at mondrian.olap4j.MondrianOlap4jExtra.getLevelCardinality(MondrianOlap4jExtra.java:74)&#13;&#10;&#9;at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populateDimension(RowsetDefinition.java:3970)&#13;&#10;&#9;at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populateCube(RowsetDefinition.java:3915)&#13;&#10;&#9;at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populateCatalog(RowsetDefinition.java:3897)&#13;&#10;&#9;at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populateImpl(RowsetDefinition.java:3885)&#13;&#10;&#9;at mondrian.xmla.Rowset.populate(Rowset.java:201)&#13;&#10;&#9;at mondrian.xmla.Rowset.unparse(Rowset.java:173)&#13;&#10;&#9;at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2903)&#13;&#10;&#9;at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:676)&#13;&#10;&#9;at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:517)&#13;&#10;&#9;at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318)&#13;&#10;&#9;at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)&#13;&#10;&#9;at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)&#13;&#10;&#9;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)&#13;&#10;&#9;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)&#13;&#10;&#9;at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)&#13;&#10;&#9;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)&#13;&#10;&#9;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)&#13;&#10;&#9;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)&#13;&#10;&#9;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)&#13;&#10;&#9;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)&#13;&#10;&#9;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)&#13;&#10;&#9;at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)&#13;&#10;&#9;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)&#13;&#10;&#9;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)&#13;&#10;&#9;at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)&#13;&#10;&#9;at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)&#13;&#10;&#9;at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)&#13;&#10;&#9;at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1374)&#13;&#10;&#9;at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)&#13;&#10;&#9;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)&#13;&#10;&#9;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)&#13;&#10;&#9;at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)&#13;&#10;&#9;at java.lang.Thread.run(Thread.java:748)&#13;&#10;&#13;&#10;</desc>
    </XA:error>
  </detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

in Result the error-Parameter contains:

As you can see, the Details are missing. This wouldn't be worse - but additional xhr is away (null) - so manually parsing the result is impossible.

It should be possible to use message details - or having access to the complete Response (but xhr is not present).

Unplanned
Last Updated: 08 Jul 2021 11:25 by ADMIN
As of August 2018, the PivotConfigurator can show a list of dimensions and measures.  However, the control could be improved by optionally adding the members of dimension attributes to the control.   By allowing users to drag-and-drop members, they can add a dimension and instantly filter by the selected member.   This would speed up the process of designing sophisticated queries.  Thanks!
Declined
Last Updated: 02 Feb 2022 10:49 by ADMIN
Created by: Jean-Pierre
Comments: 2
Category: PivotGrid
Type: Feature Request
2
Connection with Azure Analysis Services not work.
Completed
Last Updated: 18 Mar 2022 09:49 by ADMIN
Hi Team,

I am working on one of client application and we are using pivot grid control jQuery version to connect and pull data from cube but one things which we are missing is getting the cellset properties(back_color) from cube data. 

There are certain business rules applied on the cube to show data with different color schemes. Now based on the cube data color properties , We want to get that as a part of kendo UI pivot grid for the cells.

 

We saw excel supports that feature, where it can understand the cell set (back color) properties and render the back color. I am also attaching snapshots from excel.

Below is the sample mdx query and highlighted underlined holds cell properties

 

 

SELECT NON EMPTY { [Measures].[QCV to Deploy], [Measures].[Initial Calculated Quota], [Measures].[Quota Deployed], [Measures].[Remaining QCV] }

ON COLUMNS, NON EMPTY { ([SalesMetric].[Sales Metric Key].[Sales Metric Key].ALLMEMBERS * [SalesMetric].[Sales Metric Name].[Sales Metric Name].ALLMEMBERS ) }

DIMENSION PROPERTIES MEMBER_CAPTION ON ROWS FROM (

SELECT ( { [SalesOrganization].[SalesOrganization].[All], [SalesOrganization].[SalesOrganization].&[108]} )

ON COLUMNS FROM [QuotaAllocation]) WHERE ( [SalesOrganization].[SalesOrganization].CurrentMember )

CELLPROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS 
Unplanned
Last Updated: 06 Apr 2022 13:56 by ADMIN
Currently the Pivot Grid have both Column and Row that will be used to be on display for Jquery type.

Please add in additional Filter like others software givers on pivotgrid. 
This additional Filter is not used for display, as it is used for filter only.


Unplanned
Last Updated: 16 Sep 2021 11:05 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: 18 Nov 2020 10:53 by ADMIN
Release 2020.R3
Created by: Robert
Comments: 5
Category: PivotGrid
Type: Feature Request
29
You really need to add sorting to your Kendo UI pivotgrid for flat/local data sources.  The entire point of a pivot grid is to analyze data.  We did a POC with it for our salesmen.  The feedback was:  "It's almost useless if I can't sort it and see my top and bottom sellers, etc...".    So, we're swapping out the pivotgrid for Infragistics Ignite UI.  It's a shame too, cause most everything else is there. 
Declined
Last Updated: 21 Sep 2021 07:13 by ADMIN
Created by: Fernando
Comments: 1
Category: PivotGrid
Type: Feature Request
7
In some applications data will be so huge to load on PivotGrid, and the manipulation of filtering, reordering and changing dimensions between rows and columns take a long time, freezering the browser for a moment. With data paging this frozen time is avoided.
Completed
Last Updated: 17 Sep 2021 10:46 by ADMIN
Created by: Imported User
Comments: 1
Category: PivotGrid
Type: Feature Request
3
Add the option to connect to Microsoft SSAS Tabular mode using Kendo UI PivotGrid
Completed
Last Updated: 15 Feb 2017 09:14 by ADMIN
Created by: n/a
Comments: 0
Category: PivotGrid
Type: Feature Request
3
Declined
Last Updated: 05 Jul 2021 13:38 by ADMIN
Created by: michael
Comments: 1
Category: PivotGrid
Type: Feature Request
17
We have an existing application that was developed with ExtJS, that we'd like to move to AngularJS+KendoUI. The only thing that's holding us back is that you don't have the ability to created editable PivotGrids. That feature is available in Sencha's product, and our users use it extensively. 
Ex: http://examples.sencha.com/extjs/6.0.2/examples/kitchensink/#rangeeditor-pivot-grid
Declined
Last Updated: 02 Feb 2022 09:12 by ADMIN
Created by: Sebastian
Comments: 2
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.
Unplanned
Last Updated: 22 Jan 2020 11:05 by ADMIN
Created by: Erik
Comments: 2
Category: PivotGrid
Type: Feature Request
24
I would like to see a persist state feature like in the grid control applied to the pivot grid.  A complex cube state is difficult for our users to set up each time the page is loaded.  It would be great to save the current state of the pivotgrid and restore it on future visit.
Unplanned
Last Updated: 11 Nov 2021 11:55 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.
Unplanned
Last Updated: 02 Dec 2021 11:53 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>
Declined
Last Updated: 22 Mar 2021 13:58 by ADMIN
Advanced functionality in xml/a binding should be available to local binding. Also ability to define new binding protocols.
Unplanned
Last Updated: 17 Sep 2021 10:57 by ADMIN
Expanding programmatically all paths in a level in a pivot grid is coumbersome. One should be able to expand all itlems in a level. Also when one row.expand and column.expand configuration should work for all levels.
1 2 3