Creating reports

You can create ad hoc reports by using the SAP BusinessObjects Business Intelligence (BI) Web Intelligence Application, which is accessible from the launch pad. For details about navigating the launch pad, see Navigating-the-interface.

• To create an ad hoc report
• Formatting a report
• To save a report
• Related topics

When you create an ad hoc report, you create a report definition. The report definition specifies the data that will be included in the report, including the ways that you can filter the data.

This topic provides an overview of the instructions for creating, formatting, and saving reports. For comprehensive information about creating reports, see the SAP documentation (SAP-BusinessObjects-BI-platform-documentation).

To create an ad hoc report

1. In the SAP BusinessObjects BI launch pad, from My Applications, open Web Intelligence Application .  
2. Click Create a new document .
3. Click Universe.
   
4. Click OK.
5. Click bds_da_unv to select the BMC Decision Support – Database Automation universe as the data source, and then click Select.
   
   
    The Query Panel opens.
   

6. In the Query Panel, drag query items from the universe folders in the left pane to the right pane to build your report queries to and specify prompts.
   

   Warning

   Note

   While creating an adhoc report, if you use the result of a query as a value in another query filter, the following error message appears: ORA-00936: missing expression.

   Workaround: By default, when creating a custom query, BusinessObjects BI creates an alias for the result of the subquery (for example, @dpvalue('D', DP0.DO215)). To resolve the issue, replace the alias with the exact subquery. 

7. When you finish setting up the report, click Run Query .
8. If you added a prompt to your report and it requires input, you are prompted to provide a value. Specify the prompt value.
    In the following example, a time period value is required and Last 30 Days is selected.
   
9. Click OK.
    The report is displayed. This is called the report definition.
   

Formatting a report

When you create a report, default formatting and a default title are used for the report definition. You can rename the report and format it in Web Intelligence Application. For information about formatting, see the SAP documentation.

To save a report

To save your report, click Save, select the location, such as a folder in My Favorites, and click Save again.

Related topics

Sending-and-scheduling-reports
Scheduling-reports