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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to filter the members in the dimension using OlapReport?

You can filter the members in the dimension using OlapReport which is described below.

Rules:

  1. To achieve this we need to specify “Excluded Elements” and “Included Elements” in OlapReport. If the dimension is in Row/Column region, it is enough to specify “Excluded Elements” alone and for slicer region we need to specify both “Excluded elements” and “Included elements” in OlapReport.
  2. Also we need to specify level name, member name and unique name of the desired members in-order to exclude or include.

 

The code sample below illustrates on how to filter the members in a dimension which is in column. NOTE: This format is applicable for row as well but not for slicer.

C#

 

VB.NET

 

The code sample below illustrates on how to filter the members in a dimension which is in slicer.

C#

 

 

VB.NET

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
6486 03/07/2016 03/07/2016 JavaScript ejPivotChart
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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