Creating an Ad-hoc Report

images\btn_mini.gif Related Topics          images\btn_mini.gif Reference

 

Ad-hoc reports (or reports on demand) can be created if you have purchased this premium feature from Bridgeway Suite. Analysis Center, which is powered by SAP BusinessObjects Web Intelligence, is the leading Web-based query and analysis tool, designed to provide insight to the maximum number of users in an intuitive environment on a scalable platform.

See Building Queries with SAP BusinessObjects Web Intelligence Query – HTML and Building Reports with the SAP BusinessObjects Web Intelligence HTML Report Panel documents provided by BusinessObjects for more information on Analysis Center interface.

To Create an Ad-hoc Report:

1.          Open Analysis Center.

2.          On the Analysis Center dialog box, select a universe from which you want to create a report. Universes are custom-built to include information from your company.

3.          Click Begin.

4.          In the Analysis Center, select fields from the universe that you want to see as results in your report, and click the right arrow button or drag-and-drop the fields on the Result Objects list box.

5.          Select data on which you want to filter the report, and click the right arrow button or drag-and-drop the field on the Query Filters list box.

6.          Select an operator (for example, Greater than or Equal to).

7.          Select one of the following:

§                  If you use the default selection of Constant for the filter type, type a value in the text box.

§                  To select from a value in a list, click the images\btn_filter_type.gif Filter Type button and select Value(s) from list. On the List of Values dialog box, select the value(s) to be used in the query, and click OK.

§                  To prompt for a value during report execution, click the images\btn_filter_type.gif Filter Type button and select Prompt. Click the images\btn_prompt_properties.gif Prompt Properties button to open the Prompt Properties dialog box to select any information concerning the value the report executor will be prompted to supply when he/she runs the report, and click OK.

8.          Click images\btn_run_query.gif Run Query.

9.          If you selected Prompt in Step 7, enter the value on which you want to filter data from the Prompts dialog box (if the value is in a list, click on the value, then click the left arrow button to move the value to the selected list), and click Run Query.