I'm currently working on a project where there's a requirement to have a large number (20) of cascading filters working together to filter ~10 data sources. Filters are applied using dropdown boxes, with all dropdown boxes data bound to different dimensions of the same data source. Some of the dropdowns will be populated with large amounts of data - >20,000 items.
Data binding all the dropdowns appears to have had a massive negative impact on performance to the point that the dashboard is unusable.
I've checked BO and BW server utilisation, neither are being overworked. Backend is BW on Hana so I would have expected good performance.
Any tips or ideas on how to improve performance?
Thanks a million,