KB35122: Order of prompts updated unexpectedly with IncludingPromptOnReport plugin used to display prompt and report on the same page with MicroStrategy SDK

SYMPTOM:
Prompt Order is not preserved for nested prompts when the IncludingPromptOnReport plugin is used with the Strategy SDK 9.0.x and the report is refreshed. Notice that the report which is supposed to show Category first to limit the number of element of Subcategory to be displayed is now showing Subcategory before Category.
 

 
STEPS TO REPRODUCE:
Execute the following in Strategy Tutorial:

1. Create an attribute element prompt with Category.
2. Create a filter with the prompt.
3. Create an attribute element prompt with Subcategory -- use the filter created at step2 to limit the number of Subcategory to be returned in the list of element.
4. Create a filter with the prompt defined at step3.
5. Create a report with Category and Subcategory in the grid and the filter created at step4.
6. Save IncludingPromptOnReport plugin folder to add this customization.
7. Restart IIS.
8. Execute the report created at step5 and ansewer the prompt = Category Electronics.
9. In the second prompt, select TV's and Video Equipment as the answer for Subcategory.
10. Confirm the result. Report Details shows Subcategory = TV's, Video Equipment only. (No reference to Category because it is a nested prompt.)
11. Replace the Category prompt answer of Electronics with Books. (Keep Subcategory answer).
12. Click "Run" report option. Notice nothing changed in grid result and filter details while "Books" is now selected as the prompt answer.  (Note: Though it is a misleading display, this is an expected behavior because prompt to Category is not supposed to be applied directly to the report, but should only control the elements to be returned for Subcategory prompt. )
13. Go to "Format" > "Report Details Properties" > General > and check "Prompt Details," and "Filter Details", click "OK"
14. Check the report display again and noticed that the prompt order swapped. Originally, it was 1 Category 2 Subcategory, but now, 1 Subcategory 2 Category.

CAUSE:
This is a known issue with Strategy SDK 9.0.x.
 
 
ACTION:
 
Contact Strategy Technical Support for an update regarding this issue.