SYMPTOM:
A Strategy prompted document has two dataset reports that are each based on a different Intelligent Cube. Both the Intelligent Cubes have a common attribute between them and each of the cubes have their own filter on that attribute. The prompt in the document is an attribute qualification prompt on the same attribute that is common to both Intelligent Cubes. When the document is executed, the prompt's element answer list is only populated based on one of the Intelligent Cubes, bringing back a subset of the elements based on that cube's particular filter instead of bringing back the full list of elements from the warehouse.
STEPS TO REPRODUCE:
CAUSE:
This is a known issue in Strategy 9.3.x.
ACTION:
This issue has been fixed in Strategy 9.4.0 and newer versions. Upgrade to 9.4.0 or newer version to take advantage of the fix.