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.

Filtering Elemts on specific level

Thread ID:

Created:

Updated:

Platform:

Replies:

119968 Aug 19,2015 08:57 AM Aug 20,2015 03:08 AM ASP.NET Web Forms 1
loading
Tags: PivotClient
Sven Grundmann
Asked On August 19, 2015 08:57 AM

Hello,

in the built in filter function of the OlapClient filtering is done on all entries that are currently shown. What we want to provide in our project is to perform filtering on a specific level of the hierarchy, e.g. in the adventure works database, show all years thats total Internet Sales Amount is greater than ...$. Is it possible to (programmatically) filter according to a specific level. Additionally the OlapClient looses all its drill functionality after filtering. Is it possible to show drillable cells after filtering?

To make clear my intention i send you a screenshot of a pivot table in Microsoft Excel. In the surrounded drop down list you can select a specific level. If you then go to "Value filter" -> "Grater than", all values of that level not fitting to the selected condition will be removed from the table. After that the pivot table remains in the same structure as before. Hence I can drill down the remaining cells in the normal behavior to see, which values exactly are behind the remaining values. Is it possible to provide filtered olap grids with exactly that behavior with the OlapClient?

If all this or parts of my request are possible, can you give me an example how to implement this? 

Best regards

Thomas Gramer


Attachment: Excel_Pivot_Table__level_specific_filter_5f50c8c.zip

Alagarsamy D [Syncfusion]
Replied On August 20, 2015 03:08 AM

Hi Sven,

Yes, we can programmatically filter the records besides each hierarchy and please find the UG link pointing the same. This would be close to your requirement.
http://help.syncfusion.com/ug/asp.net/index.html#!Documents/reportwithfilter.htm

Meanwhile we currently don’t have support to drill our OLAP Grid further after filtering and will let you know once the feature in implemented.

Please let us know if you require any further assistance.

Thanks,
Alagarsamy D.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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.

;