How to: Apply Master Filtering in Code in OLAP Mode

• Mar 31, 2018
• 2 minutes to read

The following example demonstrates how to apply filtering for dashboard items that act as a master filter in OLAP mode.

In this example, the DashboardViewer.SetMasterFilter method is used to select the required cards in the Card dashboard item. Note that unique names of OLAP members are used instead of values.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-apply-master-filtering-in-code-in-olap-mode-e5098.

Form1.cs

using System.Collections.Generic;
using System.Windows.Forms;
using System.Collections;

namespace Dashboard_SetMasterFilter_OLAP {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();
            // Loads a dashboard from an XML file.
            dashboardViewer1.LoadDashboard(@"..\..\Data\Dashboard.xml");

            // Creates two sets of OLAP members' unique names to select corresponding cards 
            // in the Card dashboard item.
            List<object> cardValues1 = new List<object>();
            cardValues1.AddRange(new[] { "[Date].[Calendar Year].&[2001]",
                "[Date].[Calendar Quarter of Year].&[CY Q4]" });
            List<object> cardValues2 = new List<object>();
            cardValues2.AddRange(new[] { "[Date].[Calendar Year].&[2002]",
                "[Date].[Calendar Quarter of Year].&[CY Q1]" });
            List<IList> selectedCards = new List<IList>(new[] { cardValues1, cardValues2 } );

            // Selects specified cards in the Card dashboard item.
            dashboardViewer1.SetMasterFilter("cardDashboardItem1", selectedCards);
        }      
    }
}

Form1.vb

Imports Microsoft.VisualBasic
Imports System.Collections.Generic
Imports System.Windows.Forms
Imports System.Collections

Namespace Dashboard_SetMasterFilter_OLAP
    Partial Public Class Form1
        Inherits Form
        Public Sub New()
            InitializeComponent()
            ' Loads a dashboard from an XML file.
            dashboardViewer1.LoadDashboard("..\..\Data\Dashboard.xml")

            ' Creates two sets of OLAP members' unique names to select corresponding cards 
            ' in the Card dashboard item.
            Dim cardValues1 As New List(Of Object)()
            cardValues1.AddRange(New String() {"[Date].[Calendar Year].&[2001]", _
                                               "[Date].[Calendar Quarter of Year].&[CY Q4]"})
            Dim cardValues2 As New List(Of Object)()
            cardValues2.AddRange(New String() {"[Date].[Calendar Year].&[2002]", _
                                               "[Date].[Calendar Quarter of Year].&[CY Q1]"})
            Dim selectedCards As New List(Of IList)(New IList() {cardValues1, cardValues2})

            ' Selects specified cards in the Card dashboard item.
            dashboardViewer1.SetMasterFilter("cardDashboardItem1", selectedCards)
        End Sub
    End Class
End Namespace