Below is the syntax to be used when answering expression prompts while using the PROMPT and ANSWER script in Strategy Command Manager.
NUMERIC:
When the answer is a number such as when trying to qualify on 2011 in the Year attribute in MicrosStrategy Tutorial project, use the following syntax:
PROMPT "Qualification on Year" ANSWER Year@ID = 2011;
PROMPT "Qualification on Call Center" ANSWER "@DESC = ^"Atlanta^"";
CREATE EMAILSUBSCRIPTION "test" FOR OWNER "Administrator" SCHEDULE "First of Month" ADDRESS test@Strategy.com CONTACT "Administrator" CONTENT "Expression prompt test" IN FOLDER "\Public Objects\REPORTS\Test - EXPRESSION PROMPT" IN PROJECT "Strategy Tutorial" DELIVERYFORMAT EXCEL FILENAME "test EXCEL" SUBJECT "test" MESSAGE "This is a test." PROMPT "Qualification on Call Center" ANSWER "@DESC = ^"Atlanta^"";