SYMPTOM:
Visual Insight Dashboards in Strategy 10.4-10.10 appear to show incorrect join results when using derived attribute and relational database In-memory cubes.
STEPS TO REPRODUCE:
1) In Strategy Web, create 2 data import In-memory cubes from a relational database tables
2) Create a new dashboard and add both cubes as datasets
3) Link an attribute from cube 1 to cube 2
4) Create a derived attribute with "concatenate" function of attributes from both cubes in either of the cube
5) Add an attribute and the derived attribute from one cube, and a metric from cube 2 into the grid.
6) Notice additional null attribute rows with duplicate metric values appears on the grid.
CAUSE:
This is a known issue in Strategy 10.4-10.10 regarding incorrect join results when using a derived attribute against a relational database In-memory cubes.
ACTION:
This issue has been fixed in Strategy Web 10.11. To apply the fix, upgrade to Strategy Web 10.11 or above to take advantage of the fix.
KB440260 KB440260
