Add header to dimensions in PivotGrid

Question

Hi,I'd like to know how can I add headers to the dimensions in the PivotGrid object. Currently I can see headers only on the measures.See attached.Thanks,LironAttachment: headers_54f40c8f.rar

Vinoth Krishnamoorthy · Answer

Hi Liron, 
 
Thanks for contacting Syncfusion support. 
 
From your screenshot, we found that you need this requirement in EJ1 Pivot Grid control. In EJ1 Pivot Grid control, you can add headers for dimensions by enabling “headerSettings” property to true. Please find the documentation, code snippet and reference screenshot from below. 

Documentation Link: 
 https://help.syncfusion.com/js/pivotgrid/pivotgrid-elements#header-settings 

Code Snippet: 
 
$("#PivotGrid1").ejPivotGrid( 
                    { 
                            url: "/Olap", 
                            headerSettings: { 
                            showRowItems: true, 
                            showColumnItems: true 
                        },  
                       
                    }); 
 
Reference Screenshot: 
 
  
 
Please let us know if you need any further assistance on this. 
 
Regards, 
Vinoth K.

Liron Marcus · Answer

Thanks,I have followed your instructions but it didn't work. I can't see the headers for the dimensions.Below is my code:$("#PivotGrid").ejPivotGrid(        {            url: parent.m_serviceUrl,            customObject: { mdx: setParameters() },            layout: m_sum,            beforeExport: "exporting",            isResponsive: true,            enableColumnResizing : true,            headerSettings: {                 showRowItems: true,                 showColumnItems: true             },            renderSuccess: "renderSuccess"         });Please advise,Liron

Suriya · Answer

Hi Liron, 

Sorry for the inconvenience caused. 

We confirmed that “Headers are not updated properly for PivotGrid which is rendered through MDX Query” is an issue and this will be fixed in our Essential Studio Volume 4 release which is estimated to be available by mid of December.  
Please let us know if your Custom object binded in different mode. 
Regards, 
Suriya

Liron Marcus · Answer

How can I get the fix before December?Liron

Suriya · Answer

Hi Liron, 

Can you please share your current Essential Studio Version, and we will get back to you with patch details. 

Regards, 
Suriya

Liron Marcus · Answer

14.4460.0.20

Suriya · Answer

Hi Liron,As per our validation, we are unable to share patch for your mentioned ES version (14.4460.0.20) since we have provided Column header name support from the ES version 15.2.0.40. Hence, we kindly request to you use our latest version for the latest updates in our product and please let us know, if you need the patch for this issue in our current version (16.3.0.29).Regards,Suriya

Scintilla Arul Jothi Raj · Answer

Hi Liron, 
  
We are glad to announce that our Essential Studio Volume  4 Beta (16.4.0.40) is rolled out and is available for download under the following link. 
  
https://www.syncfusion.com/forums/141399/essential-studio-2018-volume-4-beta-release-v16-4-0-40-is-available-for-download 
  
We have included the fix for the issue- Headers are not updated properly for PivotGrid which is rendered through MDX Query in this release. 
  
We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 
  
Regards, 
Scintilla A