Using @prompt to get user input for a report variable

[Former Member]

Hi,

I want to create a filter in the universe to simply get a numeric value from the user. Next, I'll use that value in a calculation for a report variable.

Eg: Prompt will allow the user to select 1 of 4 values (25, 50, 75, 100).

I'll create a report variable (new_var) = userresponse*existing_var.

How do I create this type of a filter using @prompt in the universt to simply to get user input?

DLN

[Former Member · Accepted solution]

Hello,

Create the condition in the @Universe.

@prompt('select value','N',{'25','50','75','100'},mono,constrained) = @prompt('select value','N','25','50','75','100'},mono,constrained)

As you can see, the condition is always true. so it won't affect data returned from a database when it's used in a report.

It will work when it will be used in a query.

Gracias...!!

[Former Member · Accepted solution]

Hi BOCP-BOE,

Why we are making it to @Prompt=@Prompt?? Can you explain it...

I used to do Tab.col=@Prompt

Or

@Select(class\obj)=@Prompt

DLN

[Former Member · Accepted solution]

By making @prompt = @prompt you do not impact the SQL at all. If you reference a table, then that table will always be used in the SQL even if it is not needed for anything else. The solution posted is quite common, and avoids the need to bring in extra tables for no reason.

[Former Member · Accepted solution]

Hope Dave's explanation clears your doubts.

Gracias...!!

Let's play with Aurora (BO XI 4.0)