@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

Fact table

A Fact table consists of metrics, measurements, or facts of any business process. Facts and Dimensions are at the root of data warehouse. Facts are the metrics that senior management or board members of an organization use for making business decisions. Dimensional modeling brings together the relational model Read more

1 2 3 4 5 6 9