KB40992: How to get attribute prompt elements automatically updated after the data in warehouse has been modified without updating schema in MicroStrategy Web 9.x and 10.x

In some business scenarios, it is required to have the element list in a prompt being updated automatically without updating schema after the data in warehouse being modified.
The following steps describe how to let prompt attribute's elements get automatically updated when user runs this prompt report in Web. Tutorial project is used in this example.
 
 

• Create an element prompt on Year attribute and use it as the filter of a report with Year attribute in row.
• Run the report via Web. The prompt displays as the following screenshot.  

• Open Attribute editor of Year, click tab 'Display' and uncheck 'Enable element caching', as shown below:         

•  Insert a row '2012' in the lookup table of Year, as shown below.

•  Run this report in Web again.

Note: The newly added element appears in the prompt while user does not perform updating schema.
 
Disable element caching can be applied at project level, Developer level and attribute level. User may apply it according to their development and performance needs.