Hide Cube Dimensions Browser

Question

Hi, i want to hide Cube Dimensions Browser into Pivot Client with OLAP source mode. How can I do it? There is an official mode to do it or workaround?

Scintilla Arul Jothi Raj · Answer

Hi Simone, 

Thanks for contacting Syncfusion support. 

You can hide Cube Dimension Browser by providing “CollapseCubeBrowserByDefault” (CollapseCubeBrowserByDefault(true)) property of PivotClient.  It will hide the cube dimension browser automatically at the initial rendering itself. Please refer the code snippet below. 

Code Snippet: [cshtml] 
 




@Html.EJ().Pivot().PivotClient("PivotClient1").Title("OLAP Browser").CollapseCubeBrowserByDefault(true).Url(Url.Content("../api/OlapClient")) 

Screenshot: 
  
 
Note: We have confirmed that “isResponsive property is not working properly with CubeBrowserByDefault” is an issue and we have logged a defect report. The fix for the issue will be available in the upcoming Essential Studio Volume 1 SP2 release estimated by the end of April.  
 
Please let us know if you have any concerns. 

Regards, 
Scintilla A.

Simone · Answer

Thank you for your answer. Sorry we did not understand each other. I want to remove Cube Dimensions browser from pivot client and leave three box for filters, measures and slicer. Can I do it? There is a workaround?

Scintilla Arul Jothi Raj · Answer

Hi Simone,

Thanks for the update.

You can hide cube dimension browser (tree view) alone. We have provided a work around solution for your reference. Please refer the code snippet below.

Code Snippet: [CSS]

<style>

.cubeSelect {

float: none !important;

padding-left: 0px !important;

}

.cubeText {

margin-bottom: 0px !important;

padding-left: 0px !important;

}

.cubeTableTD {

width:100% !important;

}

.e-toggleExpandButton {

top: -27px !important;

}

</style>

You should give the width of the “control panel” and “axis builder” in the “renderSuccess” event. Please refer the code snippet below.

$("#PivotClient").ejPivotClient({

//…

renderSuccess: function (args) {

$(".cubeTableTD").first().css("display", "none");

$(".cdbTD").css("display", "none");

$(".e-csHeader").width("312px");

$(".axisBuilderTD").css("width","300px");

$(".e-controlPanel").css("width", "677px");

}

});

Screenshot:

Regards,

Scintilla A

Scintilla Arul Jothi Raj · Answer

Hi Simone, 
We are glad to announce that our Essential Studio Volume 1, SP 2 2018 (v16.1.0.37) is rolled out and is available for download under the following link. 
https://www.syncfusion.com/forums/137209/essential-studio-2018-volume-1-service-pack-release-v16-1-0-37-available-for-download             
The fix for the issue “IsResponsive property is not working properly with CubeBrowserByDefault” is included in this version. 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