Skip to Content

@prompt variable not using associated dimension's Index awareness

I have a dimension, Lists\Surgeon Group, that defines the Select (GROUP.NAME) and the Primary Key awareness (GROUP.ID). Both values are Characters. I've also defined a list-of-values for the dimension that displays the values from the GROUP.NAME.

I reference this dimension in a prompt:

@Prompt( 'Select one or more Surgeon Groups(s)', 'A', 'Lists\Surgeon Group', multi, Constrained)

Unfortunately, the prompt is returning the GROUP.NAME value, rather than the GROUP.ID.

Are key values supported in @prompt variables? If so, what am I missing?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 08, 2017 at 03:03 PM

    I needed to use the primary_key keyword:

    @Prompt('Select one or more Surgeon Groups(s)','A','Lists\Surgeon Group', multi, primary_key)
    Add comment
    10|10000 characters needed characters exceeded