Unplanned
Last Updated: 15 Oct 2020 15:27 by Guilherme
Created by: Guilherme
Comments: 0
Category: PivotGrid
Type: Bug Report
1

Bug report

The pivot grid does not display the correct value after a series of expand and collapse actions.

Reproduction of the problem

Here are the steps for reproduction:

"Expand column "Mês/Ano"

Expand line "N1"

Expand line "N2" of N1 - "CUSTOS PRODUÇÃO"

Expand line "N3" of N2 - "MATERIA PRIMA"

Please, verify the value of the line N3 "PAPEL OFF SET", at column "09/2020" = ($27,184.00)

Expand line "N3" of N2 - "COMPRA DE IMOBILIZADO"
Expand line "N3" of N2 - "MERCADORIAS"
Expand line "N3" of N2 - "PESSOAL"
Expand line "N3" of N2 - "SERVICOS"
Expand line "N3" of N2 - "MANUTENÇÃO DE MAQUINAS"

Expand line "N2" of N1 - "DESPESAS"
Expand line "N3" of N2 - "PESSOAL"
Expand line "N3" of N2 - "DEDUCOES DA RECEITA"
Expand line "N3" of N2 - "DESPESAS GERAIS"
Expand line "N3" of N2 - "VEICULO"
Expand line "N3" of N2 - "COMPRA DE IMOBILIZADO"

Expand line "N2" of N1 - "CUSTOS VENDA"
Expand line "N3" of N2 - "COMISSOES VENDEDORES"
Expand line "N3" of N2 - "REEMBOLSO"

Expand line "N2" of N1 - "SOCIOS"
Expand line "N3" of N2 - "REEMBOLSO GASTOS SOCIOS"
Expand line "N3" of N2 - "RETIRADA"

Retract line "N1" (with sub-lines "N2" and "N3" still expanded)
Expand line "N2" (with lines "N1" and "N3" still retracted)
Expand line "N3" of N2 - "MATERIA PRIMA"
Expand line "N3" of N2 - "FRETE"
Expand line "N3" of N2 - "PESSOAL"
Expand line "N3" of N2 - "COMPRA DE IMOBILIZADO"
Expand line "N3" of N2 - "DEDUCOES DA RECEITA"
Expand line "N3" of N2 - "DESPESAS GERAIS"

Retract line "N2" (with sub-lines "N3" still expanded)

Expand line "N1"
Retract line "N2" - "SOCIOS" (with sub-lines "N3" still expanded)
Retract line "N2" - "CUSTOS VENDA" (with sub-lines "N3" still expanded)

Retract line "N1" (with sub-lines "N2" and "N3" still expanded)

Expand line "N3" (with lines "N1" and "N2" still retracted)
Retract line "N3"

Expand line "N1"
Expand line "N3" of N2 - "FRETE"
Expand line "N3" of N1 - "CUSTOS VENDA" (with sub-lines "N2" still retracted)
Expand line "N3" of N1 - "SOCIOS" (with sub-lines "N2" still retracted)

Retract line "N1" (with sub-lines "N2" and "N3" still expanded)

Expand line "N3" (with lines "N1" and "N2" still retracted)

Please, verify the value of the line N3 - "PAPEL OFF SET" = ($9,069.50) - That's incorrect. It still should be ($27,184.00)"

Unplanned
Last Updated: 01 Oct 2020 10:58 by ADMIN
Created by: Andrii
Comments: 1
Category: PivotGrid
Type: Bug Report
0

Hello, 

I have a problem with KendoPivotGrid auto height while using jQuery 3.5.5.

See Dojo

The same issue was previously in KendoGrid, but now it's solved.

 

Unplanned
Last Updated: 22 Jul 2020 07:28 by ADMIN
Created by: Rajan
Comments: 3
Category: PivotGrid
Type: Feature Request
12
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: 17 Jul 2020 04:27 by Defense Me
Created by: Defense Me
Comments: 0
Category: PivotGrid
Type: Feature Request
1
Provide support for virtual scrolling.
Unplanned
Last Updated: 25 May 2020 07:37 by ADMIN
Created by: Robert
Comments: 2
Category: PivotGrid
Type: Feature Request
28
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. 
Unplanned
Last Updated: 18 Feb 2020 14:52 by ADMIN
Created by: unTill
Comments: 7
Category: PivotGrid
Type: Bug Report
1
When i add tow dimensions in row and two dimensions in columns and expand data in cell gets shiftet to wrong places but totals are correct.

Need More Info
Last Updated: 23 Jan 2020 16:09 by ADMIN
Advanced functionality in xml/a binding should be available to local binding. Also ability to define new binding protocols.
Unplanned
Last Updated: 22 Jan 2020 11:05 by ADMIN
Created by: Erik
Comments: 2
Category: PivotGrid
Type: Feature Request
20
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.
Need More Info
Last Updated: 21 Jan 2020 12:30 by ADMIN
Currently there is no way to select database and cube in the analyzer.

http://demos.telerik.com/kendo-ui/pivotgrid/index

Please consider this functionality.
Unplanned
Last Updated: 03 Jan 2020 15:14 by ADMIN
Created by: Sebastian
Comments: 0
Category: PivotGrid
Type: Feature Request
27
Problem:
The values and fieldnames can be very long or very short. Based on that, values and fieldnames are often truncated or lost in a way to wide column. That behavior has many downsides:
- The PivotGrid need much more space then it should
- Long values and fieldnames can't be read
- It's totally not responsive and looks bad

Competitors solution:
- http://www.igniteui.com/pivot-grid/all-grid-features
- http://webix.com/pivot/

Problem-solving approach:
- Show resize icon when hovering over a the bar between two columns
- Resize this column to it's min. width (value or fieldname) after a double click on this bar
- Manual resizing of the column by drag and drop of this bar
- Automatically size columns to there min. width on initialisation
Unplanned
Last Updated: 03 Jan 2020 15:09 by ADMIN
Created by: Sebastian
Comments: 5
Category: PivotGrid
Type: Feature Request
35
I want to sort rows and columns by values (not fieldnames).

One way to do that is like it's done by DevExpress (https://demos.devexpress.com/ASPxPivotGridDemos/OLAP/Browser.aspx). By right clicking a field i can choose for with field, row, column and measurement i want to sort. But even this solution could be more userfriendly.

Another more direct solution would be to sort by clicking on a measurement field or if there is only one, on a fieldname.

Both are just suggestions. But the functionality of sorting by values is really relevant.

http://www.telerik.com/forums/sort-rows-and-columns-by-values
Unplanned
Last Updated: 26 Nov 2019 12:36 by ADMIN
Created by: andrew
Comments: 3
Category: PivotGrid
Type: Feature Request
28
Your friend  devexpress have very nice compact pivot grid layout
https://demos.devexpress.com/MVCxPivotGridDemos/Layout/CompactLayout

Can we also have it on kendo ui ?
Pending Review
Last Updated: 29 Jul 2019 04:58 by ADMIN
Created by: Somesh
Comments: 1
Category: PivotGrid
Type: Bug Report
1
when data present inside the array which are binding to pivotgrid read method then not an any issue BUT  When if one of the empty array binding to pivot grid read method after that wherever we try to bind the array with data it causing problem 'Cannot read property 'value' of undefined'.
Unplanned
Last Updated: 17 Dec 2018 12:22 by ADMIN
Created by: Miron
Comments: 1
Category: PivotGrid
Type: Feature Request
1

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

Pending Review
Last Updated: 30 Nov 2018 10:51 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).

Pending Review
Last Updated: 14 Nov 2018 14:31 by ADMIN
Created by: Rajan
Comments: 3
Category: PivotGrid
Type: Feature Request
7
Kendo pivotgrid currently has only row and column filters. Filters and Filter area are also important. See other pivotgrid implementations - especially DevExpress ASPxPivotgrid and Excel pivot table
Pending Review
Last Updated: 08 Oct 2018 11:54 by ADMIN
Created by: michael
Comments: 0
Category: PivotGrid
Type: Feature Request
15
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
Pending Review
Last Updated: 10 Sep 2018 20:27 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.
Pending Review
Last Updated: 14 Aug 2018 14:37 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!
Pending Review
Last Updated: 09 Aug 2018 09:28 by ADMIN
Created by: Jean-Pierre
Comments: 0
Category: PivotGrid
Type: Feature Request
2
Connection with Azure Analysis Services not work.
1 2 3