Follow the below steps to create new report.

1. Login into BIP console.
2. To Create a new report first create the data model. Click on Data Model on left.

   Figure 5-1 Creating a New Report 1

   
   

   
   Description of "Figure 5-1 Creating a New Report 1"

   
   
3. On clicking Data Model, it will open the following Screen.

   Figure 5-2 Creating a New Report 2

   
   

   
   Description of "Figure 5-2 Creating a New Report 2"

   
   
4. To create a New Data Set, Click on New Data Set and select the type SQL Query.

   Figure 5-3 Creating a New Report 3

   
   

   
   Description of "Figure 5-3 Creating a New Report 3"

   
   

   The following screen is displayed.

   Figure 5-4 Creating a New Report 4

   
   

   
   Description of "Figure 5-4 Creating a New Report 4"

   
   
5. Enter the new data model name (Use the same name while creating the report layout).
6. Select the Data Source.
7. Add the sql query. It depends on what data needed on the report and what should be the parameters.

   Figure 5-5 Creating a New Report 5

   
   

   
   Description of "Figure 5-5 Creating a New Report 5"

   
   
8. Click OK. A confirmation dialog is displayed to create the parameter. Select the parameter and press OK.

   Figure 5-6 Creating a New Report 6

   
   

   
   Description of "Figure 5-6 Creating a New Report 6"

   
   
9. The parameter is created as indicated below.

   Figure 5-7 Creating a New Report 7

   
   

   
   Description of "Figure 5-7 Creating a New Report 7"

   
   
10. Save the data model. Select the directory in which you would need to save the details. For Reports save in reports directory and for Letters save it in Letters directory.
11. You can also save with the same name and specify the description of the report.

    Figure 5-8 Creating a New Report 8

    
    

    
    Description of "Figure 5-8 Creating a New Report 8"

    
    

    Figure 5-9 Creating a New Report 9

    
    

    
    Description of "Figure 5-9 Creating a New Report 9"

    
    
12. Once the Data Model is created, create the sample data as indicated below.
13. Click on View Data on right side of the page.

    Figure 5-10 Creating a New Report 10

    
    

    
    Description of "Figure 5-10 Creating a New Report 10"

    
    

    Figure 5-11 Creating a New Report 11

    
    

    
    Description of "Figure 5-11 Creating a New Report 11"

    
    
14. Specify the following value in Parameter (P_STATUS).

    Figure 5-12 Creating a New Report 12

    
    

    
    Description of "Figure 5-12 Creating a New Report 12"

    
    
15. Click View. The sample data is created as indicated.

    Figure 5-13 Creating a New Report 13

    
    

    
    Description of "Figure 5-13 Creating a New Report 13"

    
    
16. Click on Save As Sample Data.

    Figure 5-14 Creating a New Report 14

    
    

    
    Description of "Figure 5-14 Creating a New Report 14"

    
    
17. The Data model is created and can be use to create the report layout.