SYMPTOM:
In-Memory Intelligent Cube returns a different number of rows when switched to Connect Live mode.
STEPS TO REPRODUCE:
This discrepancy is only seen when the the Data Engine Version is set to 11. For more details on enabling the setting, refer to Change Data Engine Version.
1. Create a new dashboard in Strategy Tutorial Project with Web.
2. Create Dataset #1 with table CITY_CTR_SLS and choose Connect Live mode
3. Create M1 as Sum([Tot Cost]){~+}
4. Apply 2 filters to the metric
4a. Rank of “Tot Cost” Highest 15.

4b. Rank of “Tot Dollar Sales” Highest 5.
4c. The 2 filter should be in “AND NOT” relationship.

5. Save the metric
6. Add both Cust City Id and M1 to the grid; there are only 5 rows on the grid.

7. Switch the Data Access Mode to In-Memory; notice there are 10 rows.

CAUSE:
The metric qualification was incorrectly put in both view filter and metric condition when Live mode is used.
ACTION/RESOLUTION:
This defect is addressed in Strategy 11.1 or above.
Strategy reference numbers for this technical note are KB442263 and DE116995.