We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Hide the dimensions present in Cube Dimension Browser

Platform: WPF |
Control: OlapClient
Tags: wpf, olap, olapclient

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

2X faster development

The ultimate WPF UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile