Skip to Content
avatar image
Former Member

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

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 ..?

Add comment
10|10000 characters needed characters exceeded

  • 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.

  • Mohamed,

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

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 27, 2017 at 04:36 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded