Skip to main content

Prompt / Quick Prompt

Prompt and Quick Prompt insert dimension values as filters into your formulas or extractions. Both tools read the data model referenced by the selected cell and only show dimensions that have a prompt defined.

The selected values are written directly into the active cell as filter parameters. The difference is in how many values you can select: Prompt supports multiple selections and displays full dimension details (codes, descriptions, attributes) to help you identify the right values. Quick Prompt is limited to a single value and skips the extra context.

Excel Add-in Prompt / Quick Prompt

Prompt vs. Quick Prompt​

ToolWhat it does
PromptOpens a full dialog where you can browse, search, sort, and select multiple values at once. Use it when you need to see codes, descriptions, or attributes before choosing.
Quick PromptInserts a single value with no additional context. Use it when you already know the value you need.

When to use prompts​

  • Filter a formula or extraction by dimension values instead of typing them manually into a cell.
  • Pick values from a long list using search, sort, and filter tools to find the right item.
  • Confirm the right value when codes, descriptions, or attributes are needed to identify it.

Apply filters​

Prompt: select multiple values​

  1. In the Add-ins tab, select Prompt.
  2. Select the reference pointing to the data model where the prompt is defined.
  3. Select the dimension you want to filter by.
  4. Select OK to load the available values.
  5. In the Available list:
    • Use Add Highlighted or Add All to move values to the Selected list.
    • Use Remove Highlighted or Remove All to move values back.
    • Use Sort, Search, or Filter to find specific values.
  6. Select Ok. The selected values are inserted as a comma-separated list into the active cell.

Quick prompt: insert a single value​

  1. In the Add-ins tab, select Quick Prompt.
  2. Select the reference pointing to the data model where the prompt is defined.
  3. Select the dimension you want to filter by.
  4. Select the value you want to use. Use Sort, Search, or Filter to find it if needed.
  5. Select Ok. The selected value is inserted into the active cell.

tip

When you reopen the dialog for the same cell, your previous selection load automatically.