Desktop productivity for business analysts and programmers

Exclude values from dynamic prompts

Reply
New Contributor
Posts: 3

Exclude values from dynamic prompts

I have created an STP in EG, with dynamic prompts and dependencies.

So, when I choose a value from the firts prompt, the next prompt is populated with values.

However, I don't want all the values to be available in the second prompt. Is there some way to exclude values from being shown?

Contributor
Posts: 45

Re: Exclude values from dynamic prompts

Creating a prompt data set separate from your STP data source is a good way to control your prompt values...where are you getting your prompt values?...your dynamic data values

New Contributor
Posts: 3

Re: Exclude values from dynamic prompts

I get the prompt values from one of the tables in the database.

I don't have access rights to create new tables and place them in the public areas of the database. Is there another way?

Contributor
Posts: 45

Re: Exclude values from dynamic prompts

Sorry, that functionality does not exist in the prompt creation process...all you get is, essentially, a where statement in your dependency choice.
Since prompt data sources must be registered, there is no way to make the prompt source conform without a permanent data set.
Ask a Question
Discussion stats
  • 3 replies
  • 86 views
  • 0 likes
  • 2 in conversation