Developing Data Model & Report

STEP 1:
Click on New > Data Model
6











STEP 2:
Below Screen will appear :
Enter into Description Box and Select Default Data Source.
8









STEP 3:
Click on Data Sets > Diagram > SQL Query.
9








STEP 4:
Enter a name for the New Data Set. After that click on "Query Builder"
button to  select the desired tables.
10
STEP 5:
Drag and drop tables from Schema (column on left) to Model (on right).
11
STEP 6:
>> 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 :
12
STEP 7:
Enter the SQL query in the SQL Query Builder and Click OK :
13
STEP 8 :
Click on the created Data Set :
14
STEP 9:
Click on Structure :
Rename the DISPLAY NAME column as shown in the below screen shot:
15
STEP 10:
Select the Pencil Icon to edit the SQL Query :
16
Find WHERE C.YEAR = 2001 and replace it with
 WHERE C.YEAR = :P_YEAR
and click on OK.
17
18
 
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.
20
STEP 12 :
Click on PARAMETERS (p_YEAR).
 
Enter data as per the below screen(highlighted in red box).
21
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.
22
23
STEP 14 :
Click on NEW > REPORT.
24
STEP 15 :
> Select USE DATA MODEL & GUIDE ME.
> Select BROWSE icon.
25
STEP 16 :
Select the created DATA MODEL and OPEN.
26
After STEP 16 the below screen will appear and select NEXT.
27
STEP 17 :
Select
> PORTRAIT FROM PAGE OPTIONS 
> CHART & TABLE FROM LAYOUT
28
STEP 18 :
Drag & Drop 
> PLAYERS to DROP VALUE HERE
> TOURNAMENT NAME to DROP SERIES HERE
  as per the below screen shot :
> Select NEXT.
29
STEP 19 :
Drag & Drop rest all options to create the table and click NEXT.
30
 
STEP 20 :
Select CUSTOMIZE REPORT LAYOUT and click on FINISH.
31
STEP 21 :
SAVE the report with a name.
32
STEP 22 :
Report_TT will appear.
33

Leave A Reply

Your email address will not be published. Required fields are marked *