Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
SYMPTOM:
In Strategy 10.9 and 10.10, filtering on a warehouse null values in Dossier created off an In-Memory cube result in 'No data returned for this view. This might be because the applied filter excludes all data'. However, if the data access mode is changed from In-Memory to Live connect, data is returned as shown below:
Dossier behavior with filter applied using In-Memory:
Dossier behavior with filter applied using Live connect:
STEP TO REPRODUCE:
1. Create a simple warehouse table with 4 columns (3 attributes and a metric).
2. Import table into Strategy using data import in web > save as an In-Memory.
3. Add SelfCat id, SelfCat Name, SelfCat Prop attributes and Self Rev metric to template
4. Add filtering condition SelfCat id in list (NULL)
5. Dossier returns 'No data returned for this view. This might be because the applied filter excludes all data' error message.
6. Change the cube access mode from In-Memory to Live connect, data is returned.
CAUSE:
This is a known issue in Strategy 10.9 and 10.10 where filtering on warehouse null values are not correctly handled by the analytical engine.
ACTION:
This issue is fixed in Strategy 10.11, please upgrade to this version to take advantage of the fix.
Strategy reference numbers for this technical note are KB441477 and DE76773.
