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!