or
4 answers
279 views
We are using the Kendo Pivot grid wrapped in Angular2 component. We are able to populate the pivot grid, but we are facing some issues in the following items
1. How do I change the background-color of the columnheader or grouping header in Pivot grid. I tried applying the following css in the custom.css but it is not getting affected with the grid.
.k-grouping-header k-grid-header th.k-header{
background-color: #F7F7F7 !important;
}
2. How do I get the Subtotals at the group level and Grand total at the overall level?
3. how to include the Grouped column name along with "All" in the group by RowHeaders (please refer the snapshot attached for more details)
Can anyone help me with these issues?
Dimiter Topalov
Telerik team
answered
on
28 Oct 2016
1 answer
192 views
How do I change the background-color of the columnheader/rowHeader or grouping header in Kendo Pivot grid. I tried applying the following css in the custom.css but it is not getting affected with the grid. These classes are originally present in the kendo.common.min.css and I want to override it my custom CSS class.
how do I change or override it?
.k-grouping-header k-grid-header th.k-header{ background-color: #F7F7F7 !important;}
Eduardo Serra
Telerik team
answered
on
28 Oct 2016
1 answer
74 views
Is it possible to connect kendo ui pivotgrid to our SSAS service in SQL 2012 Ent ? I configured HTTP XMLA on IIS and it works with Excel, Visual Studio or Management studio. I am sure in my configurations. your demo example works but it is obviously SSAS 2008R2.
$("#pivotgrid").kendoPivotGrid({ configurator: "#pivotconfigurator", height: 550, dataSource: { type: "xmla", transport: { connection: { catalog: "AdventureWorksDW2012Multidimensional-EE", cube: "Adventure Works" }, read: { url: "http://test.cz/olap/msmdpump.dll", } }, error: function (e) { alert("error: " + kendo.stringify(e)); }, schema: { type: "xmla" } } });
Stefan
Telerik team
answered
on
07 Sep 2016
5 answers
210 views
how do i set the datasource in the pivotgrid to the correct data generate in the pivotgrid in the paging?
for example: in my datasource i have 500 rows which generate into 250 rows and 250 colums in the pivot grid.
how to i take the new data size which was created in the pivotgrid and not from the datasource for calculation the paging for the pivotgrid?
i use this:
$("#pager").kendoPager({
dataSource: result.data, /* not correct*/
pageSizes: [10, 25, 50]
});
when the result.data is the 500 rows that was arrived from the original datasource.
for example: in my datasource i have 500 rows which generate into 250 rows and 250 colums in the pivot grid.
how to i take the new data size which was created in the pivotgrid and not from the datasource for calculation the paging for the pivotgrid?
i use this:
$("#pager").kendoPager({
dataSource: result.data, /* not correct*/
pageSizes: [10, 25, 50]
});
when the result.data is the 500 rows that was arrived from the original datasource.
Alex Hajigeorgieva
Telerik team
answered
on
02 Sep 2016
1 answer
73 views
I need to fill background of cell based on it's value. For example, value of cell is 10%. I need left part of this cell to be blue and it part should be 10% of cell width. I also need to have same background after export to excel. It is possible to do this with kendo pivotgrid?
Georgi Krustev
Telerik team
answered
on
23 Aug 2016
1 answer
149 views
With a remote data source, I can't get sortable working. In the UI the user can choose "Sort Ascending" or "Sort Descending", but the expanded values remain unsorted. Filter and all other features do work. Below the code. What am I doing wrong here? Thanks in advance.
$(document).ready(function () { // prefilter posted from main page var postedCriteria = {{ json_encode($criteria) }}; // used for pivot/chart integration var collapsed = { columns: [], rows: [] }; var dataSource = new kendo.data.PivotDataSource({ transport: { read: { url: '{{ url("rapport/query") }}', type: "get", dataType: "json", data: { criteria: postedCriteria } } }, schema: { data: "clients", cube: { dimensions: { Client_geslacht: { caption: "Geslacht" }, Client_redenAfwijzing: { caption: "Reden voor afwijzing" }, Client_aanmelderSoort: { caption: "Aanmeldersoort" }, Client_landHerkomst: { caption: "Land van herkomst" }, Status_status: { caption: "Status" }, }, measures: { "Aantal clienten": { field: "Client_id", aggregate: CountDistinctAggregate }, "Aantal resultaten": { field: "Resultaat_id", aggregate: CountDistinctAggregate }, "Totaalbedrag leefgeld": { field: "Leefgeld_bedragLeefgeld", format: "{0:c}", aggregate: "sum" }, } } }, columns: [{ name: "Client_geslacht", expand: true }], rows: [{ name: "Status_status", expand: true }], measures: ["Aantal clienten"] }); var pivotgrid = $("#pivotgrid").kendoPivotGrid({ filterable: true, sortable: true, columnWidth: 120, height: 570, dataSource: dataSource, // chart integration: dataBound: function () { initChart(convertData(this.dataSource, collapsed)); }, // chart integration: gather the collapsed members collapseMember: function (e) { var axis = collapsed[e.axis]; var path = e.path[0]; if (axis.indexOf(path) === -1) { axis.push(path); } }, // chart integration: gather the expanded members expandMember: function (e) { var axis = collapsed[e.axis]; var index = axis.indexOf(e.path[0]); if (index !== -1) { axis.splice(index, 1); } }, }).data("kendoPivotGrid"); $("#configurator").kendoPivotConfigurator({ dataSource: pivotgrid.dataSource, filterable: true, height: 570 }); $("#exportToExcel").click(function() { pivotgrid.saveAsExcel(); });});function CountDistinctAggregate(value, state, context){ if (!state.distinctList) { state.distinctList = new Array(); } if (value == null || $.inArray(value, state.distinctList) > -1) { return (state.accumulator || 0); } else { state.distinctList.push(value); return (state.accumulator || 0) + 1; }}
Georgi Krustev
Telerik team
answered
on
14 Jul 2016
3 answers
184 views
Hello,
We have list of flat POJO objects, where objects are dynamic, we don’t know their list of fields/properties at design time. In Silverlight version of telerik Pivot grid we were able to populate list of fields and provide list of objects so that users can create columns, rows and measures at run time.Is this approach feasible with Kendo UI Pivot? Or do we have to define model and cube with dimensions and measures in advance? An example would be very useful.
Thank you, Sergey
4 answers
353 views
Does the count measure count the itens using DISTINCT?
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. If the COUNT measure does not use DISTINCT, Is there any workaround for this?
1 answer
114 views
OK, we can control columns size by ColumnWidth property. but can limit width of part of the grid where dimension data is shown? Can we force dimension members test wrap up and grow down and not pushing columns size to the right? Looks like AJAX grid can do the triclk
Georgi Krustev
Telerik team
answered
on
30 May 2016
3 answers
100 views
Hi
I use PivotGrid v2016.1) with MS
SSAS (v2014) cube.
In my cube I created several calculated members, (one named EAC)
on dimension named Category.
When I’m using this dimension in PivotGrid as a column PivotGrid doesn’t
show any calculated members, but only dimension child members.
PivotGrid generates this MDX query:
SELECT NON EMPTY {[Category].[Category].[All],[Category].[Category].[All].Children} DIMENSION PROPERTIESCHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS FROM [SDCOE] WHERE ([Measures].[Value Cost])<br>Filter in PivotConfigurator is able to see all dimension members, children and calculated as wel. But when I explicitly specify Category members in filter to include in query than PivotGrid returns all members but NOT calculated.
PivotGrid generates this MDX query:
<p>SELECT NON EMPTY {[Category].[Category].[All],[Category].[Category].[All].Children} DIMENSION PROPERTIESCHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS FROM (SELECT ({[Category].[Category].&[1],[Category].[Category].[All].[EAC]}) ON 0 FROM [SDCOE]) WHERE ([Measures].[Value Cost])</p><p></p>Does it mean PivotGrid does't support dimension calculated members?
Rosen
Telerik team
answered
on
27 May 2016
