The following desrcibes how Web Analysis retrieves data from Essbase and processes it when using multiple filters:
Web Analysis uses Essbase report scripts to query Essbase.
To retrieve top/bottom functionality, Web Analysis uses the Essbase report script commands TOP and/or BOTTOM, so the top/bottom retrievals are passed directly to the Essbase server.
Similar to Essbase Excel Add-In queries, Essbase report scripts do not support multiple dimension members in a filter. Therefore, for Web Analysis to achieve this, multiple Essbase report scripts are executed – one for each member. The results are summed into one grid in Web Analysis.
Therefore, when doing a top/bottom retrieval with multiple member filters, the top/bottom results are retrieved from Essbase, one for each filter member, then summed together in WA