Cascading Prompts or Nested Prompts

As name suggests they are nested prompts, one prompt after another or i can also say series of prompts which will narrow the end user selection. Prompt values are dependent on previous prompt value (user selected) and only the last value is used in query.

For example: Let’s say we have heirarchy – Country -> State -> City and you want user to select city based of country and state prompt then its time to use cascade prompts. Read more

@Prompt Function in Business Objects

What do you do when your report needs an input (filter) from user in order to run report. You use @prompt function.

Ex: User does not want to see all 10 years of data that we have in our data mart. Instead he/she would enter or option to select year value before report run.

Prompts can be used to restrict the data or to make large value objects easier to use. You use the @Prompt function in the WHERE clause for an object. It forces a user to enter a value for a restriction when that object is used in a query, or to select a value or a list of values. When the user runs the query, a prompt
box appears asking for a value to be entered.
Read more

1 2 3 4 5 7