How to Show all Values in Filter Controls in OLAP Cube

There is an option of filtering for the values in OLAP Cube. When we pull a level to filter, then it shows a filter control where around first 200 values of the level are listed in enterprise edition of Pentaho. Consider the below example.

This blog helps you in understanding how can we increase the number of values in the filter box.

Steps to follow:

1. Stop the BA Server.
2. Open the file ‘analyzer.properties’
3. Path of the file: Server/Pentaho solutions/system/analyzer



4. Change the value of the property ‘filter.members.max.count’ from 200 to 500(Required Value) in an analyzer.properties file.



5. Start the server.
6. Drag the field in the report and try to filter now.



7. Since the values are shown in the combo box, try to keep the value of the property ‘filter.members.max.count’ less than 1000. If it is more than 1000, the performance of the cube gets affected.

In case if you have any queries please get us at support@helicaltech.com

Thank You
Mounika
Helical IT Solutions Pvt Ltd

Best Open Source Business Intelligence Software Helical Insight Here

A Business Intelligence Framework

Free
Download