We are noticing performance issues when selecting filter values from a dimension hierarchy and retrieving the data from Essbase, and every time a change is made to the filter options, multiple queries are sent back to Essbase.
1)This is slowing down the overall report load time and we can notice the delay for Spotfire. Would love to see TIBCO Spotfire let users make selections and apply all changes at one time without unchecking all the filters first.
2) Also, instead of sending one query to Essbase is it possible to send one query per visualization?
3) Adding scripting features like a "submit" button that will send queries to Essbase once filters have been all checked/unchecked.