Category / Section
Hide the dimensions present in Cube Dimension Browser
1 min read
You can hide the dimensions present in the Cube Dimension Browser by using the following code example. In this example, the dimension Date is hidden that is available in Adventure Works cube.
C#
public MainWindow() { ……… ……… InitializeComponent(); this.olapClient1.OlapDataManager.BeforeMdxQueryExecute += OlapDataManager_BeforeMdxQueryExecute; } void olapClient1_Loaded(object sender, RoutedEventArgs e) { if (this.olapClient1!=null && this.olapClient1.OlapDataManager != null) { CubeSchema cubeSchema = this.olapClient1.OlapDataManager.CurrentCubeSchema; for (int i = 0; i < cubeSchema.Dimensions.Count; i++) { if (cubeSchema.Dimensions[i].Name == "Date") { cubeSchema.Dimensions[i].Visible = false; } } this.olapClient1.CubeDimensionBrowser.RefreshNodes(cubeSchema); } }
VB
Public Sub New() …….. …….. InitializeComponent() Me.olapClient1.OlapDataManager.BeforeMdxQueryExecute += OlapDataManager_BeforeMdxQueryExecute End Sub Private Sub olapClient1_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs) If Me.olapClient1 IsNot Nothing AndAlso Me.olapClient1.OlapDataManager IsNot Nothing Then Dim cubeSchema As CubeSchema = Me.olapClient1.OlapDataManager.CurrentCubeSchema For i As Integer = 0 To cubeSchema.Dimensions.Count - 1 If cubeSchema.Dimensions(i).Name = "Date" Then cubeSchema.Dimensions(i).Visible = False End If Next i Me.olapClient1.CubeDimensionBrowser.RefreshNodes(cubeSchema) End If End Sub