Skip to Content
0
Former Member
Jun 30, 2006 at 12:32 PM

Query Designing

14 Views

Hi,

I have data in the cube as follows:

Type -


NAME -


Games played

Cricket -- Player1 -- 100

Cricket -- Player2 -- 50

Cricket -- Player3 -- 45

Football -- Player4 -- 60

Football -- Player5 -- 12

Football -- Player6 -- 45

Tennis -- Player7 -- 2

Tennis -- Player8 -- 90

Tennis -- Player9 -- 120

where "Type" and "Name" are Characteristic Infoobjects and "games played" is a keyfigure.

I should design a query to display the output as follows:

Type -


Top Player Name -


Games Played

Cricket -- Player1 -- 100

Football -- Player4 -- 60

Tennis -- Player9 -- 120

What I mean is the query should display the player name with the more number of games played in the individual types.

How shud i go about designing the query?

Regards,

Sham'm