Articles in this section
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

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied