asked 8 hours ago
Good morning. We have the pivot table connected to analysis services. We have a doubt regarding filtering.
We have a list of companies and the clients for them. We filter to retrieve one company. However, we see the data being loaded is the count of clients for ALL companies:
So we believe that all data is loaded and the filtering is done in the frontend? can this be done in backend? filtering first and then retrieving data? (we are using accelerator)
thanks!
⋅ 8 mins ago
Hello, Jesica!
Thank you for reaching out to us.
Your observation is partially correct - Flexmonster loads all members of the hierarchy in the slice. However, the numeric values are still filtered on the server side. Fetching all members is an intentional behavior that lets users see the full list of members in the filter popup and allows dynamic filter changes without making additional backend requests for unloaded members. On the other hand, numeric values are filtered and returned only for visible members.
To optimize the performance for this case and prevent loading all members, we recommend using the subquery property in the dataSource object. This property sets a server-side filter to decrease the size of the response from the server. However, loading members not present in a subset of data filtered with a subquery would require changing it.
Please let us know if using the subquery property would work for you.
Best Regards,
Maksym
