Developing Repository [Presentation Layer] : Tennis Tournament

STEP 1 :

Drag from BMM Layer & drop in Presentation Layer as per the below screen shot.

046

STEP 2 :

Double click on Tennis Matches > Set…

47

 

STEP 3 :

Select GAMES_WIN > OK.

48

 

STEP 4 :

Fact – Matches > New Object > Logical Column.

49

 

STEP 5 :

Name the new Logical Column as % Games Own.

50

 

STEP 6 :

Select the radio button of Derived from existing columns using an expression and click on Expression Icon.

51

 

STEP 7 :

Enter the Query as shown in the below figure and click OK.

52

 

STEP 8 :

Drag % Games Own from BMM Layer to Presentation Layer.

53

 

STEP 9 :

In Logical Table Source W_MATCH_F click on Add New Icon & add % Games Won (Physical).

Then Click on Expression Icon.

054

 

STEP 10 :

Enter query as shown in the below figure.

55

 

STEP 11 :

Drag % Games Won (Physical) from BMM Layer to Presentation Layer.

56

 

STEP 12 :

Under the Logical Level open Logical Level – Dim Time Total and edit as shown in the below screen shot.

57

 

STEP 13 :

Under Fact – Matches create a Logical Column named Derived Logical Column.

Drag the Derived Logical Column from BMM Layer to Presentation Layer as shown in the below screen shot.

58

 

STEP 14 :

Rename the Derived Logical Column to % Games Won Last Year.

Note : The change of name in BMM Layer will reflect in Presentation Layer,refer the below screen shot.

59_rename

 

STEP 15 :

Right click on % Games Won Last Year > Duplicate,refer below screen shot.

60

 

STEP 16 :

Rename the % Games Won Last Year#1 to Total % Games Won Last Year.

61

 

STEP 17 :

Open Total % Games Won Last Year change the Logical Level(follow the below screen shot).

62

Leave A Reply

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