Click on New > Data Model
Below Screen will appear :
Enter into Description Box and Select Default Data Source.
Click on Data Sets > Diagram > SQL Query.
Enter a name for the New Data Set. After that click on "Query Builder"
button to select the desired tables.
Drag and drop tables from Schema (column on left) to Model (on right).
>> Map the W_Tournament_F table with: W_Player_D,W_COURT_TYPE_D,W_TOURNAMENT_D,W_DATE_D
1. W_Tournament_F (PLAYER_WID) - W_Player_D (PLAYER_WID)
2. W_Tournament_F (COURT_TYPE_WID) - W_COURT_TYPE_D (COURT_TYPE_WID)
3. W_Tournament_F (START_DATE_WID) - W_DATE_D(DATE_WID)
4. W_Tournament_F (Tournament_WID) - W_Tournament_D(Tournament_WID)
Note: Click on right box of the particular table's row and do the same for others for mapping action.
>> Click on the following Check Boxes :
1. W_Player_D : NAME
2. W_COURT_TYPE_D : COURT_TYPE_WID
3. W_DATE_D : YEAR
4. W_Tournament_D : TOURNAMENT_NAME & START_DATE
>> Click on SAVE
After the execution of above steps the screen will look this :
Enter the SQL query in the SQL Query Builder and Click OK :
STEP 8 :
Click on the created Data Set :
Click on Structure :
Rename the DISPLAY NAME column as shown in the below screen shot:
Select the Pencil Icon to edit the SQL Query :
Find WHERE C.YEAR = 2001 and replace it with
WHERE C.YEAR = :P_YEAR
and click on OK.
STEP 11 :
ADD PARAMETER pop-up window will appear.
Select the Check Box p_YEAR and Click on OK.
STEP 12 :
Click on LIST OF VALUES, Provide the Name (Eg: LOV_YEAR) and type for the List of Values.
Add the Values for the Year along with the Lable name.
STEP 12 :
Click on PARAMETERS (p_YEAR).
Enter data as per the below screen(highlighted in red box).
STEP 13 :
Click on DATA SETS > DS_TOURNAMENT_INFO > Click on Data.
> Update Rows to 50
> Click on VIEW
> Click on SAVE AS SAMPLE DATA
> Click OK on the pop-up.
STEP 14 :
Click on NEW > REPORT.
STEP 15 :
> Select USE DATA MODEL & GUIDE ME.
> Select BROWSE icon.
STEP 16 :
Select the created DATA MODEL and OPEN.
After STEP 16 the below screen will appear and select NEXT.
STEP 17 :
> PORTRAIT FROM PAGE OPTIONS
> CHART & TABLE FROM LAYOUT
STEP 18 :
Drag & Drop
> PLAYERS to DROP VALUE HERE
> TOURNAMENT NAME to DROP SERIES HERE
as per the below screen shot :
> Select NEXT.
STEP 19 :
Drag & Drop rest all options to create the table and click NEXT.
STEP 20 :
Select CUSTOMIZE REPORT LAYOUT and click on FINISH.
STEP 21 :
SAVE the report with a name.
STEP 22 :
Report_TT will appear.