Category / Section
How to hide the measures and dimensions in the CubeDimensionBrowser
1 min read
In OlapClient, the Dimension and Measure on Cube Dimension Browser (Left side tree view with Cube schema information) can be made hidden by setting ‘Visible’ property for corresponding Dimension object and Measure object on Server side and using ‘ExcludedElements’ with the type “List<String>” on Client side
Please refer the below code snippet for server side.
C#
/// <summary> /// Gets the cube schema. /// </summary> /// <param name="cubeName">Name of the cube.</param> /// <returns></returns> public CubeSchema GetCubeSchema(string cubeName) { CubeSchema cubeSchema = _dataManager.GetCubeSchema(cubeName); foreach (var item in cubeSchema.Dimensions) { if (item.Name == "Date") { item.Visible = false; } if (item.Name == "Customer") { item.Visible = false; } } foreach (var item in cubeSchema.Measures) { if (item.Name == "Internet Sales Amount") { item.Visible = false; } if (item.Name == "Order Quantity") { item.Visible = false; } } _dataManager.DataProvider.CloseConnection(); return cubeSchema; }
Please refer the below code snippet for client side.
C#
List<String> hideElements = new List<string>(); hideElements.Add("Employee");//Dimension to be hidden hideElements.Add("Geography");//Dimension to be hidden hideElements.Add("Internet Sales Amount");//Measure to be hidden hideElements.Add("Internet Gross Profit");//Measure to be hidden hideElements.Add("Reseller Sales Amount");//Measure to be hidden hideElements.Add("Promotion");//Dimension to be hidden hideElements.Add("Date");//Dimension to be hidden hideElements.Add("Order Quantity");//Measure to be hidden this.olapClient.CubeDimensionBrowser.ExcludedElements = hideElements;
Figure: OlapClient’s CubeDimensionBrowser with hidden measures and dimensions
Figure: OlapClient’s CubeDimensionBrowser without hidden measures and dimensions