cancel
Showing results for 
Search instead for 
Did you mean: 

Query Designing

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Shameem,

In the query designer, click on condition/exception and you can see the property select TOP chars...for the particular char and it will display as you expectd. hope it helps....

thanks,

Vachan

Assign points if helpfull

Former Member
0 Kudos

Thanks Vachan,

that reply was a beauty, i could not assign points immediately as I was out of station.

thanks once again.

sham'm

Former Member
0 Kudos

Hi Shameem, You are most welcome...

thanks,

Vachan

Answers (0)