Passing prompt filters and values to custom attributes or measures

Use GETPROMPTVALUE for dynamic custom attributes and measures based on user selections in prompts at run time. GETPROMPTVALUE inserts the user's selected value into the formula definition before sending the query to the database.

Note: Unlike report expressions, casting the prompt value is not necessary because the user's selection is inserted and the formula is sent to the database.

Example custom attribute MyCustomAttr

DatePart(Year,[Custom Week.Week End Date])

Example filter:

[Custom Week.MyCustomAttr] = INTEGER(GETPROMPTVALUE('Time.Year'))