KB221930: The report cache generated by a subscription with text name of prompt is not hit in MicroStrategy Analytics Command Manager

SYMPTOM:
In Strategy Analytics Enterprise Command Manager 9.4.1, when using a script to create a subscription, if text name is applied to identify a prompt, the report cache generated in this way is not hit when there are other prompts with same text name in the project.
 
STEPS TO REPRODUCE:

1. Create a report with an embedded prompt. The prompt name is “Elements of Year”, as shown below:

1. Run following script in Command Manager to create a subscription, as shown below:

CREATE CACHEUPDATESUBSCRIPTION "My FIRST CACHE SUBSCRIPTION" SCHEDULE "ON DATABASE LOAD" USER "administrator" CONTENT "Test" IN FOLDER "\Public Objects\REPORTS\741845" IN PROJECT "Strategy Tutorial" PROMPT "Elements of Year" ANSWER "8D679D5111D3E4981000E787EC6DE8A4:1";

TRIGGER SUBSCRIPTION GUID C4C8EAB045DBF8DD2301FCBBFE2EC56B FOR PROJECT "Strategy Tutorial";

1. Report cache is generated successfully as shown below:

Note: In the script, the first element is used to answer the report prompt.
 

1. Run the report and answer the prompt with the first element. Notice that the cache is not hit.

1. Using attribute “Status” instead of “Year”, repeat all the steps. Since the prompt name “Elements of Status” is a unique text name across the project, the cache can be hit.

 
CAUSE:
There are multiple prompts named “Elements of Year” in Tutorial Project, so the cache is not hit. This is a known issue in Strategy Analytics Enterprise Command Manager 9.4.1.
 
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
 
Strategy Internal Reference Number for the issue discussed in this technical note is 1001386.