KB8787: How to set the maximum date from a warehouse table to be the maximum answer displayed when executing a prompted report in MicroStrategy.

To create a prompt that places the maximum date value from a warehouse table as the most current date answer, execute the following steps:
 

• Create a filter that is an attribute qualification.
• Choose the date attribute that is desired.
• Qualify on "ID".
• Set the operator to "Between".
• The first date will be the static date that is desired.
• In the second date field, set the drop down box to "Custom".
• In the date field, type in the ApplySimple statement: ApplySimple("(select max(column_name) from warehouse_table)",0) where column_name is the name of the date column and warehouse_table is the name of the table that is being used.
  

• Save and close the filter.
• Create a Filter Definition Prompt.
• Select "Choose from an attribute element list".
• Place the date attribute into the attribute box.
  

• Click next.
• Select the second radio button "Use a filter to reduce the number of elements".
  

• Select the filter created in steps 1-8.
• Hit the next button and add the display properties that are desired.
• Hit "Finish".
• Create a report with the date attribute in it.
• Place the prompt created in steps 9-16. The maximum date that is in your table should appears as the largest value.