cancel
Showing results for 
Search instead for 
Did you mean: 

Pass DS-dropdown value to @Prompt in unx ..

Former Member
0 Kudos

following scenario

1. DS Report with one Dropdown based on state
2. simple efashion query on state and city. where State as Prompt-filter in Query
3. with setvariable method you can pass selected value in dropdown to query silently
--> works fine in DS1.6

because of big data amount i tried to use @prompt instead of the onboard Promptfilter in DS-Query.

1. i opened unx and added formula @Prompt(State) to "Where" of "City"
2. i removed the old onboard Prompt filter from DS Query. Now DS Report is forced to take the @prompt (also working)
3. changed the Prompt name in setvariable accordingly (notice the new @prompt is recognized from DS)
4. BUT when loading report the @prompt popups unless of getting scilently the passed parameter from dropdown like in to first scenario ..

what i m doing wrong ..?

TammyPowlas
Active Contributor
0 Kudos

Mohamed, would you please share screen shots, version of Design Studio you are using (and which SP) - also share which version of the BI platform you are using.

eFashion doesn't have a lot of data, so I am surprised at this. But seeing screen shots would help.

MustafaBensan
Active Contributor
0 Kudos

Mohamed,

What do you mean by "onboard Prompt filter from DS Query"? Can you provide a screenshot?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Tammy .. eFashion is just for explaining the issue. i got the problem in a bigger DB.

Release 1.6 SP4 Patch 1 (Version: 16.4.1)