Create Dynamic prompt on WEBI report.

Compared to Crystal Report, create a dynamic prompt on Web Intelligence report is simplier. The design view of WEBI is always has two window: Top window contain any data field you drag and drop from the Business Objects Universe as display on the report. Bottom window contain any filters you could build. The filter can also turn to prompt.

1.in WEBI report design window, drag a data field into the Query Filter window, select a condition as "prompt".

2.When user access this WEBI report, the prompt windows will display. in this case, user must select a data value (Year name) from a list of values. 

3. Then click Refresh Query, the WEBI report display the filtered data based on user selection prompt.

4. One thing about Business Objects WEBI is quick. One click can turn filter to prompt. In this case, one right click can turn a report table into graphic. Just select "Turn To"

5.Select the graph you prefer then click OK

6. Report table now turns to bar graph.

Web intelligent: using variables on report.

Variables can be created in Universe Designer or build into the Webi report.  Using the sample database, a US company has sales revenue data collected from multiple states. Let’s assume multiple states charge various percentage of state corporate tax.

There are States and Sales Revenue data in the database which being retrieve to build the web report.  A variable is needed to be added to calculate the amounts of the State Income Tax from three different states.

1. From the exiting webi report add a blank column

 

2. Name the blank column title as state income tax

3. From webi report tool bar, click Variable Editor to create a variable

4. The variable will calculate the amount of state income tax based on the names listed on the [State] column

5. In Varialbe Editor, enter the formula like this:

         =IF( [State]="California";[Sales revenue]*0.05;
           IF ([State]="Colorado"; [Sales revenue]*0.1;
           IF( [State] ="New York";[Sales revenue]*0.08)))

6. Now the amount of state income tax of the three states are shown on the report.