improve cube performance when querying for more than one measure
Description
currently in cube, when we query for more than one measure, we use "any" fuzzy key for measures. this is okay when there are less number of measures in an aggregation. however if an aggregation has a lot of measures, this becomes very inefficient and leads to time out when querying multiple measures in a single query.
we can improve this by having adding multiple fuzzy pairs with fixed fuzzy keys for the measures queried.
Release Notes
Improved performance in cube datasets when querying for more than one measure in a query. This will also improve metrics query performance.
currently in cube, when we query for more than one measure, we use "any" fuzzy key for measures. this is okay when there are less number of measures in an aggregation.
however if an aggregation has a lot of measures, this becomes very inefficient and leads to time out when querying multiple measures in a single query.
we can improve this by having adding multiple fuzzy pairs with fixed fuzzy keys for the measures queried.