Which Parameter Type displays a list of members created by using a predefined method query, or entering a SQL expression to generate the members required for the list?

Study for the OneStream Certified Associate Exam. Develop understanding with comprehensive questions and detailed explanations. Ace your exam with confidence!

Multiple Choice

Which Parameter Type displays a list of members created by using a predefined method query, or entering a SQL expression to generate the members required for the list?

Explanation:
Bound List is the parameter type that shows a list of members produced by running a predefined method query or a SQL expression to generate the required members. This makes the list dynamic and data-driven, pulling exactly the members that the query defines and updating as the underlying data changes. It’s useful when you want prompts to reflect a subset of members based on rules or calculations, rather than a fixed set. The other types aren’t built to generate their items from a query or SQL expression: an Input Value expects the user to type in a value, a Literal Value uses a fixed constant, and a Delimited List is a static, delimiter-separated set of values rather than one produced by a query.

Bound List is the parameter type that shows a list of members produced by running a predefined method query or a SQL expression to generate the required members. This makes the list dynamic and data-driven, pulling exactly the members that the query defines and updating as the underlying data changes. It’s useful when you want prompts to reflect a subset of members based on rules or calculations, rather than a fixed set.

The other types aren’t built to generate their items from a query or SQL expression: an Input Value expects the user to type in a value, a Literal Value uses a fixed constant, and a Delimited List is a static, delimiter-separated set of values rather than one produced by a query.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy