KB19517: How to create a nested prompt that only lists names that begin with a user-specified letter in MicroStrategy Developer

To create a nested prompt in Strategy Developer that lists people whose last names begin with a user-specified letter, follow the steps below:

• Create a new attribute with the following syntax:
  

• Make this attribute the 'Parent' of the Customer as shown below:
  

• Create a user hierarchy with 'Cust Last Name' and 'Customer', as shown below:
  

• Set both attributes to unlocked, as shown below:
  

• Create a 'Hierarchy Prompt' using the hierarchy created in step 3, as shown below:
  

• Include this prompt in the report and run the report. The prompt appears as follows:
  

Refer to the following Strategy Knowledge Base technical note for additional information:
KB5490 (KB4000-071-0376): How to create a prompt-in-prompt in Strategy Developer and newer