In this blog I leverage 3 HANA capabilities that I have enabled before in this order:
As a result, I got a SAP Agile Data Preparation 1.0 SP14 installation comprising of the following Delivery Units (please check the PAM for the supported combinations):
On top of Make SAP Agile Data Preparation work for you I activate the HANA Rules Framework for Agile Data Preparation:
With this I log into my SAP Agile Data Preparation Cockpit, crate a project and download my data using the Remote Connection from Enable Smart Data Integration on your HANA, express edition:
I select of all Available Columns (for this blog, I extended the data model from this excellent blog series by ben.hofmans, and added both the data.cfg as well as the data.csv files in the appendix – please be aware that the data is not intended to be complete and might most likely even be wrong but hopefully suits this tutorial well as a fictitious data basis):
With my data downloaded, I get the first insight from the Functional Dependency tab. In fact, Agile Data Preparation determined that there is functional dependency between COUNTRY and ISO and also the other way around, but with Conflicting Values since country code GB maps to England, Scotland and Wales, which makes sense and can be used to simplify the data analysis later:
But also that country code DE mostly maps to Germany but 2 times to Deutschland, which indicates a data inconsistency challenges that has to be considered:
Next I look into the data quality, especially duplicates. Unfortunately, the build in Person Match Policy does not work for me, since I am missing some required fields:
Therefor I am creating a custom one assuming that a combination of FIRSTNAME, LASTNAME and COUNTRY will uniquely define a player:
As a result, I get presented with the players that won the UEFA Champions League with more than one club and that therefore had been recorded more than once with their surplus records being removed now. Whether this is correct or whether these records should rather have been aggregated is another questions, but with the Custom Match Policy that I defined, this is the result:
With a clean data set, I am interested in some aggregated overview information, in this case the clubs that won the UEFA Champions League with players from Great Britain. For this I define the pivot table knowing from the Functinal Dependency analysis that I can use country code GB to cover the countries I am interested in:
And get presented with the result in a Preview that I could Save as New Worksheet if I wanted to work on this further:
Finally, I am going into some sophisticated analysis on the Rules tab, leveraging the HANA Rules Framework. I am interested in all Scottish players with more than one win and therefore define a respective table rule:
By using this rule as a filter:
I get my desired result of Scottish Stars (6 out of 669):
Of course there is a lot more functionality in SAP Agile Data Preparation, but with this tutorial I hope that you learned 5 of the crucial ones:
Appendix
Please be aware that this data is not intended to be complete and might most likely even be wrong but hopefully suits this tutorial well as a fictitious data basis:
data.cfg
data.csv
- Enable Smart Data Integration on your HANA, express edition
- Enable the HANA Rules Framework on your HANA, express edition
- Make SAP Agile Data Preparation work for you
As a result, I got a SAP Agile Data Preparation 1.0 SP14 installation comprising of the following Delivery Units (please check the PAM for the supported combinations):
- HANA Version 1.00.122.03
- HANA_IM_DP Version 1.3.4
- HCO_RULE_FW Version 1.8.3
- HANA_IM_ESS Version 1.3.4
- HANA_IM_ADP Version 1.14.0
On top of Make SAP Agile Data Preparation work for you I activate the HANA Rules Framework for Agile Data Preparation:
CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.db.procedures::setupHRF"();
CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.db.procedures::setInformationsStewardMode"(1)With this I log into my SAP Agile Data Preparation Cockpit, crate a project and download my data using the Remote Connection from Enable Smart Data Integration on your HANA, express edition:
I select of all Available Columns (for this blog, I extended the data model from this excellent blog series by ben.hofmans, and added both the data.cfg as well as the data.csv files in the appendix – please be aware that the data is not intended to be complete and might most likely even be wrong but hopefully suits this tutorial well as a fictitious data basis):
With my data downloaded, I get the first insight from the Functional Dependency tab. In fact, Agile Data Preparation determined that there is functional dependency between COUNTRY and ISO and also the other way around, but with Conflicting Values since country code GB maps to England, Scotland and Wales, which makes sense and can be used to simplify the data analysis later:
But also that country code DE mostly maps to Germany but 2 times to Deutschland, which indicates a data inconsistency challenges that has to be considered:
Next I look into the data quality, especially duplicates. Unfortunately, the build in Person Match Policy does not work for me, since I am missing some required fields:
Therefor I am creating a custom one assuming that a combination of FIRSTNAME, LASTNAME and COUNTRY will uniquely define a player:
As a result, I get presented with the players that won the UEFA Champions League with more than one club and that therefore had been recorded more than once with their surplus records being removed now. Whether this is correct or whether these records should rather have been aggregated is another questions, but with the Custom Match Policy that I defined, this is the result:
With a clean data set, I am interested in some aggregated overview information, in this case the clubs that won the UEFA Champions League with players from Great Britain. For this I define the pivot table knowing from the Functinal Dependency analysis that I can use country code GB to cover the countries I am interested in:
And get presented with the result in a Preview that I could Save as New Worksheet if I wanted to work on this further:
Finally, I am going into some sophisticated analysis on the Rules tab, leveraging the HANA Rules Framework. I am interested in all Scottish players with more than one win and therefore define a respective table rule:
By using this rule as a filter:
I get my desired result of Scottish Stars (6 out of 669):
Of course there is a lot more functionality in SAP Agile Data Preparation, but with this tutorial I hope that you learned 5 of the crucial ones:
- Leverage Smart Data Integration for data acquisition
- Functial Dependency analysis
- Remove Duplicates
- Aggregate Data
- Leverage the HANA Rules Framework for complex data analysis
Appendix
Please be aware that this data is not intended to be complete and might most likely even be wrong but hopefully suits this tutorial well as a fictitious data basis:
data.cfg
Fileformat to read sample data
FORMAT=csv
FORCE_FILENAME_PATTERN=data%.csv
COLUMN_DELIMITER=;
ROW_DELIMITER=\r\n
SKIP_HEADER_LINES=1
COLUMN=FIRSTNAME;VARCHAR(50);First Name
COLUMN=LASTNAME;VARCHAR(50);Last Name
COLUMN=COUNTRY;VARCHAR(50);Country
COLUMN=CLUB;VARCHAR(50);Club
COLUMN=TITLES;INTEGER;Titles
COLUMN=ISO;VARCHAR(50);County Codedata.csv
Rabah;Madjer;Algeria;Porto;1;DZ
Javier;Mascherano;Argentina;Barcelona;2;AR
Esteban;Cambiasso;Argentina;Internazionale;1;AR
Javier;Zanetti;Argentina;Internazionale;1;AR
Walter;Samuel;Argentina;Internazionale;1;AR
Diego;Milito;Argentina;Internazionale;1;AR
Gabriel;Milito;Argentina;Barcelona;2;AR
Carlos;Tevez;Argentina;Manchester United;1;AR
Lionel;Messi;Argentina;Barcelona;4;AR
Maxi;López;Argentina;Barcelona;1;AR
Santiago;Solari;Argentina;Real Madrid;1;AR
Albano;Bizarri;Argentina;Real Madrid;1;AR
Fernando;Redondo;Argentina;Real Madrid;3;AR
Fernando;Redondo;Argentina;Milan;3;AR
Rogelio;Domínguez;Argentina;Real Madrid;3;AR
Roque;Olsen;Argentina;Real Madrid;1;AR
Zeljko;Kalac;Australia;Milan;1;AU
Harry;Kewell;Australia;Liverpool;1;AU
Philipp;Lienhart;Austria;Real Madrid;1;AT
David;Alaba;Austria;Bayern Munich;1;AT
Marko;Arnautovi?;Austria;Internazionale;1;AT
Franz;Hasil;Austria;Feyenoord;1;AT
Alexander;Hleb;Belarus;Barcelona;1;BY
Thomas;Vermaelen;Belgium;Barcelona;1;BE
Eric;Gerets;Belgium;PSV Eindhoven;1;BE
Luiz;Gustavo;Brazil;Bayern Munich;1;BR
David;Luiz;Brazil;Chelsea;1;BR
Júlio;César;Brazil;Internazionale;1;BR
Dani;Alves;Brazil;Barcelona;3;BR
Ricardo;Oliveira;Brazil;Milan;1;BR
Juliano;Belletti;Brazil;Barcelona;1;BR
Carlos;Alberto;Brazil;Porto;1;BR
Roque;Júnior;Brazil;Milan;1;BR
Flávio;Conceição;Brazil;Real Madrid;1;BR
Paulo;Sérgio;Brazil;Bayern Munich;1;BR
Giovane;Élber;Brazil;Bayern Munich;1;BR
Júlio;César;Brazil;Real Madrid;1;BR
Zé;Roberto;Brazil;Real Madrid;1;BR
Roberto;Carlos;Brazil;Real Madrid;3;BR
Walter;Casagrande;Brazil;Porto;1;BR
Dino;Sani;Brazil;Milan;1;BR
José;Altafini;Brazil;Milan;1;BR
Hristo;Stoichkov;Bulgaria;Barcelona;1;BG
Samuel;Eto'o;Cameroon;Barcelona;3;CM
Samuel;Eto'o;Cameroon;Internazionale;3;CM
Claudio;Bravo;Chile;Barcelona;1;CL
James;Rodríguez;Colombia;Real Madrid;1;CO
Iván;Córdoba;Colombia;Internazionale;1;CO
Mateo;Kova?i?;Croatia;Real Madrid;1;HR
Ivan;Rakiti?;Croatia;Barcelona;1;HR
Luka;Modri?;Croatia;Real Madrid;2;HR
Mario;Mandžuki?;Croatia;Bayern Munich;1;HR
Dario;Šimi?;Croatia;Milan;2;HR
Igor;Biš?an;Croatia;Liverpool;1;HR
Davor;Šuker;Croatia;Real Madrid;1;HR
Zvonimir;Boban;Croatia;Milan;1;HR
Alen;Bokši?;Croatia;Marseille;1;HR
Martin;Laursen;Denmark;Milan;1;DK
Thomas;Helveg;Denmark;Milan;1;DK
Peter;Schmeichel;Denmark;Manchester United;1;DK
Brian;Laudrup;Denmark;Milan;1;DK
Michael;Laudrup;Denmark;Barcelona;1;DK
Ivan;Nielsen;Denmark;PSV Eindhoven;1;DK
Jan;Heintze;Denmark;PSV Eindhoven;1;DK
Søren;Lerby;Denmark;PSV Eindhoven;1;DK
Lars;Bastrup;Denmark;Hamburg;1;DK
Johnny;Hansen;Denmark;Bayern Munich;3;DK
Ryan;Bertrand;England;Chelsea;1;GB
Ross;Turnbull;England;Chelsea;1;GB
Gary;Cahill;England;Chelsea;1;GB
Ashley;Cole;England;Chelsea;1;GB
Jamal;Blackman;England;Chelsea;1;GB
Frank;Lampard;England;Chelsea;1;GB
Daniel;Sturridge;England;Chelsea;1;GB
John;Terry;England;Chelsea;1;GB
Wayne;Rooney;England;Manchester United;1;GB
Michael;Carrick;England;Manchester United;1;GB
Rio;Ferdinand;England;Manchester United;1;GB
Jamie;Carragher;England;Liverpool;1;GB
Steven;Gerrard;England;Liverpool;1;GB
Scott;Carson;England;Liverpool;1;GB
Owen;Hargreaves;England;Bayern Munich;2;GB
Owen;Hargreaves;England;Manchester United;2;GB
Steve;McManaman;England;Real Madrid;2;GB
Gary;Neville;England;Manchester United;2;GB
David;Beckham;England;Manchester United;1;GB
Nicky;Butt;England;Manchester United;1;GB
Teddy;Sheringham;England;Manchester United;1;GB
Andy;Cole;England;Manchester United;1;GB
David;May;England;Manchester United;1;GB
Phil;Neville;England;Manchester United;1;GB
Wes;Brown;England;Manchester United;2;GB
Jonathan;Greening;England;Manchester United;1;GB
Paul;Scholes;England;Manchester United;2;GB
Phil;Neal;England;Liverpool;4;GB
Alan;Kennedy;England;Liverpool;2;GB
Craig;Johnston;England;Liverpool;1;GB
Sammy;Lee;England;Liverpool;2;GB
Bob;Bolder;England;Liverpool;1;GB
David;Hodgson;England;Liverpool;1;GB
Jimmy;Rimmer;England;Manchester United;2;GB
Jimmy;Rimmer;England;Aston Villa;2;GB
Nigel;Spink;England;Aston Villa;1;GB
Kenny;Swain;England;Aston Villa;1;GB
Gary;Williams;England;Aston Villa;1;GB
Gordon;Cowans;England;Aston Villa;1;GB
Dennis;Mortimer;England;Aston Villa;1;GB
Gary;Shaw;England;Aston Villa;1;GB
Peter;Withe;England;Aston Villa;1;GB
Tony;Morley;England;Aston Villa;1;GB
Pat;Heard;England;Aston Villa;1;GB
Ray;Clemence;England;Liverpool;3;GB
Phil;Thompson;England;Liverpool;2;GB
Terry;McDermott;England;Liverpool;3;GB
Ray;Kennedy;England;Liverpool;3;GB
Jimmy;Case;England;Liverpool;3;GB
David;Johnson;England;Liverpool;2;GB
Steve;Ogrizovic;England;Liverpool;2;GB
Colin;Irwin;England;Liverpool;2;GB
Howard;Gayle;England;Liverpool;1;GB
Richard;Money;England;Liverpool;1;GB
Peter;Shilton;England;Nottingham Forest;2;GB
Viv;Anderson;England;Nottingham Forest;2;GB
Bryn;Gunn;England;Nottingham Forest;1;GB
Larry;Lloyd;England;Nottingham Forest;2;GB
Frank;Clark;England;Nottingham Forest;2;GB
Ian;Bowyer;England;Nottingham Forest;2;GB
Gary;Mills;England;Nottingham Forest;1;GB
Garry;Birtles;England;Nottingham Forest;2;GB
Jimmy;Montgomery;England;Nottingham Forest;1;GB
Trevor;Francis;England;Nottingham Forest;1;GB
Tony;Woodcock;England;Nottingham Forest;1;GB
Chris;Woods;England;Nottingham Forest;1;GB
Emlyn;Hughes;England;Liverpool;2;GB
David;Fairclough;England;Liverpool;2;GB
Ian;Callaghan;England;Liverpool;2;GB
Tommy;Smith;England;Liverpool;1;GB
Kevin;Keegan;England;Liverpool;1;GB
Peter;McDonnell;England;Liverpool;1;GB
Alan;Waddle;England;Liverpool;1;GB
Alec;Lindsay;England;Liverpool;1;GB
Alex;Stepney;England;Manchester United;1;GB
Nobby;Stiles;England;Manchester United;1;GB
Bill;Foulkes;England;Manchester United;1;GB
Bobby;Charlton;England;Manchester United;1;GB
David;Sadler;England;Manchester United;1;GB
Brian;Kidd;England;Manchester United;1;GB
John;Aston;England;Manchester United;1;GB
Sami;Hyypiä;Finland;Liverpool;1;FI
Jari;Litmanen;Finland;Ajax;1;FI
Jérémy;Mathieu;France;Barcelona;1;FR
Raphaël;Varane;France;Real Madrid;2;FR
Karim;Benzema;France;Real Madrid;2;FR
Franck;Ribéry;France;Bayern Munich;1;FR
Florent;Malouda;France;Chelsea;1;FR
Thierry;Henry;France;Barcelona;1;FR
Éric;Abidal;France;Barcelona;2;FR
Louis;Saha;France;Manchester United;1;FR
Patrice;Evra;France;Manchester United;1;FR
Mikaël;Silvestre;France;Manchester United;1;FR
Yoann;Gourcuff;France;Milan;1;FR
Ludovic;Giuly;France;Barcelona;1;FR
Djibril;Cissé;France;Liverpool;1;FR
Claude;Makélélé;France;Real Madrid;1;FR
Zinedine;Zidane;France;Real Madrid;1;FR
Willy;Sagnol;France;Bayern Munich;1;FR
Bixente;Lizarazu;France;Bayern Munich;1;FR
Nicolas;Anelka;France;Real Madrid;1;FR
Christian;Karembeu;France;Real Madrid;2;FR
Didier;Deschamps;France;Marseille;2;FR
Didier;Deschamps;France;Juventus;2;FR
Marcel;Desailly;France;Marseille;2;FR
Marcel;Desailly;France;Milan;2;FR
Fabien;Barthez;France;Marseille;1;FR
Jocelyn;Angloma;France;Marseille;1;FR
Jean-Philippe;Durand;France;Marseille;1;FR
Basile;Boli;France;Marseille;1;FR
Franck;Sauzée;France;Marseille;1;FR
Jean-Jacques;Eydelie;France;Marseille;1;FR
Jean-Christophe;Thomas;France;Marseille;1;FR
Pascal;Olmeta;France;Marseille;1;FR
Bernard;Casoni;France;Marseille;1;FR
Jean-Marc;Ferreri;France;Marseille;1;FR
Michel;Platini;France;Juventus;1;FR
Raymond;Kopa;France;Real Madrid;3;FR
Kakha;Kaladze;Georgia;Milan;2;GE
Sami;Khedira;Deutschland;Real Madrid;1;DE
Manuel;Neuer;Deutschland;Bayern Munich;1;DE
Philipp;Lahm;Germany;Bayern Munich;1;DE
Jérôme;Boateng;Germany;Bayern Munich;1;DE
Thomas;Müller;Germany;Bayern Munich;1;DE
Bastian;Schweinsteiger;Germany;Bayern Munich;1;DE
Tom;Starke;Germany;Bayern Munich;1;DE
Mario;Gómez;Germany;Bayern Munich;1;DE
Holger;Badstuber;Germany;Bayern Munich;1;DE
Toni;Kroos;Germany;Bayern Munich;2;DE
Toni;Kroos;Germany;Real Madrid;2;DE
Diego;Contento;Germany;Bayern Munich;1;DE
Dietmar;Hamann;Germany;Liverpool;1;DE
Oliver;Kahn;Germany;Bayern Munich;1;DE
Thomas;Linke;Germany;Bayern Munich;1;DE
Carsten;Jancker;Germany;Bayern Munich;1;DE
Stefan;Effenberg;Germany;Bayern Munich;1;DE
Mehmet;Scholl;Germany;Bayern Munich;1;DE
Alexander;Zickler;Germany;Bayern Munich;1;DE
Bernd;Dreher;Germany;Bayern Munich;1;DE
Michael;Tarnat;Germany;Bayern Munich;1;DE
Stefan;Wessels;Germany;Bayern Munich;1;DE
Thorsten;Fink;Germany;Bayern Munich;1;DE
Jens;Jeremies;Germany;Bayern Munich;1;DE
Michael;Wiesinger;Germany;Bayern Munich;1;DE
Bodo;Illgner;Germany;Real Madrid;2;DE
Stefan;Klos;Germany;Borussia Dortmund;1;DE
Jürgen;Kohler;Germany;Borussia Dortmund;1;DE
Matthias;Sammer;Germany;Borussia Dortmund;1;DE
Martin;Kree;Germany;Borussia Dortmund;1;DE
Stefan;Reuter;Germany;Borussia Dortmund;1;DE
Jörg;Heinrich;Germany;Borussia Dortmund;1;DE
Andreas;Möller;Germany;Borussia Dortmund;1;DE
Michael;Zorc;Germany;Borussia Dortmund;1;DE
Karlheinz;Riedle;Germany;Borussia Dortmund;1;DE
Heiko;Herrlich;Germany;Borussia Dortmund;1;DE
Lars;Ricken;Germany;Borussia Dortmund;1;DE
René;Tretschok;Germany;Borussia Dortmund;1;DE
Rudi;Völler;Germany;Marseille;1;DE
Uli;Stein;Germany;Hamburg;1;DE
Manfred;Kaltz;Germany;Hamburg;1;DE
Ditmar;Jakobs;Germany;Hamburg;1;DE
Holger;Hieronymus;Germany;Hamburg;1;DE
Bernd;Wehmeyer;Germany;Hamburg;1;DE
Jürgen;Groh;Germany;Hamburg;1;DE
Wolfgang;Rolff;Germany;Hamburg;1;DE
Felix;Magath;Germany;Hamburg;1;DE
Jürgen;Milewski;Germany;Hamburg;1;DE
Horst;Hrubesch;Germany;Hamburg;1;DE
Uwe;Hain;Germany;Hamburg;1;DE
Sepp;Maier;Germany;Bayern Munich;3;DE
Hans-Georg;Schwarzenbeck;Germany;Bayern Munich;3;DE
Franz;Beckenbauer;Germany;Bayern Munich;3;DE
Udo;Horsmann;Germany;Bayern Munich;1;DE
Hugo;Robl;Germany;Bayern Munich;2;DE
Bernd;Dürnberger;Germany;Bayern Munich;3;DE
Franz;Roth;Germany;Bayern Munich;3;DE
Hans-Josef;Kapellmann;Germany;Bayern Munich;3;DE
Karl-Heinz;Rummenigge;Germany;Bayern Munich;2;DE
Gerd;Müller;Germany;Bayern Munich;3;DE
Ulrich;Hoeness;Germany;Bayern Munich;3;DE
Sepp;Weiss;Germany;Bayern Munich;1;DE
Rainer;Zobel;Germany;Bayern Munich;3;DE
Klaus;Wunder;Germany;Bayern Munich;1;DE
Paul;Breitner;Germany;Bayern Munich;1;DE
Horst;Blankenburg;Germany;Ajax;3;DE
Karl-Heinz;Schnellinger;Germany;Milan;1;DE
Michael;Essien;Ghana;Chelsea;1;GH
Sulley;Muntari;Ghana;Internazionale;1;GH
Samuel;Kuffour;Ghana;Bayern Munich;1;GH
Abédi;Pelé;Ghana;Marseille;1;GH
Ferenc;Puskás;Hungary;Real Madrid;3;HU
Eiður;Guðjohnsen;Iceland;Barcelona;1;IS
John;O'Shea;Ireland;Manchester United;1;IE
Steve;Finnan;Ireland;Liverpool;1;IE
Denis;Irwin;Ireland;Manchester United;1;IE
Roy;Keane;Ireland;Manchester United;1;IE
Mark;Lawrenson;Ireland;Liverpool;1;IE
Ronnie;Whelan;Ireland;Liverpool;1;IE
Michael;Robinson;Ireland;Liverpool;1;IE
Steve;Heighway;Ireland;Liverpool;3;IE
Shay;Brennan;Ireland;Manchester United;1;IE
Tony;Dunne;Ireland;Manchester United;1;IE
Avi;Cohen;Israel;Liverpool;1;IL
Paolo;Orlandoni;Italy;Internazionale;1;IT
Davide;Santon;Italy;Internazionale;1;IT
Mario;Balotelli;Italy;Internazionale;1;IT
Marco;Materazzi;Italy;Internazionale;1;IT
Francesco;Toldo;Italy;Internazionale;1;IT
Giuseppe;Favalli;Italy;Milan;1;IT
Alberto;Gilardino;Italy;Milan;1;IT
Massimo;Oddo;Italy;Milan;1;IT
Daniele;Bonera;Italy;Milan;1;IT
Marco;Storari;Italy;Milan;1;IT
Valerio;Fiori;Italy;Milan;2;IT
Thiago;Motta;Italy;Barcelona;2;IT
Thiago;Motta;Italy;Internazionale;2;IT
Alessandro;Costacurta;Italy;Milan;5;IT
Alessandro;Nesta;Italy;Milan;2;IT
Paolo;Maldini;Italy;Milan;5;IT
Gennaro;Gattuso;Italy;Milan;2;IT
Andrea;Pirlo;Italy;Milan;2;IT
Massimo;Ambrosini;Italy;Milan;2;IT
Filippo;Inzaghi;Italy;Milan;2;IT
Christian;Abbiati;Italy;Milan;1;IT
Cristian;Brocchi;Italy;Milan;2;IT
Angelo;Peruzzi;Italy;Juventus;1;IT
Ciro;Ferrara;Italy;Juventus;1;IT
Moreno;Torricelli;Italy;Juventus;1;IT
Pietro;Vierchowod;Italy;Juventus;1;IT
Gianluca;Pessotto;Italy;Juventus;1;IT
Antonio;Conte;Italy;Juventus;1;IT
Gianluca;Vialli;Italy;Juventus;1;IT
Fabrizio;Ravanelli;Italy;Juventus;1;IT
Michele;Padovano;Italy;Juventus;1;IT
Sergio;Porrini;Italy;Juventus;1;IT
Michaelangelo;Rampulla;Italy;Juventus;1;IT
Sebastiano;Rossi;Italy;Milan;1;IT
Christian;Panucci;Italy;Milan;2;IT
Christian;Panucci;Italy;Real Madrid;2;IT
Mauro;Tassotti;Italy;Milan;3;IT
Demetrio;Albertini;Italy;Milan;1;IT
Filippo;Galli;Italy;Milan;3;IT
Stefano;Nava;Italy;Milan;1;IT
Roberto;Donadoni;Italy;Milan;3;IT
Daniele;Massaro;Italy;Milan;2;IT
Marco;Simone;Italy;Milan;2;IT
Mario;Ielpo;Italy;Milan;1;IT
Gianluigi;Lentini;Italy;Milan;1;IT
Angelo;Carbone;Italy;Milan;1;IT
Andrea;Pazzagli;Italy;Milan;1;IT
Stefano;Borgonovo;Italy;Milan;1;IT
Giovanni;Galli;Italy;Milan;2;IT
Franco;Baresi;Italy;Milan;3;IT
Angelo;Colombo;Italy;Milan;2;IT
Carlo;Ancelotti;Italy;Milan;2;IT
Alberigo;Evani;Italy;Milan;2;IT
Davide;Pinato;Italy;Milan;1;IT
Roberto;Mussi;Italy;Milan;1;IT
Stefano;Tacconi;Italy;Juventus;1;IT
Luciano;Favero;Italy;Juventus;1;IT
Antonio;Cabrini;Italy;Juventus;1;IT
Sergio;Brio;Italy;Juventus;1;IT
Gaetano;Scirea;Italy;Juventus;1;IT
Marco;Tardelli;Italy;Juventus;1;IT
Massimo;Briaschi;Italy;Juventus;1;IT
Claudio;Prandelli;Italy;Juventus;1;IT
Paolo;Rossi;Italy;Juventus;1;IT
Beniamo;Vignola;Italy;Juventus;1;IT
Luciano;Bodini;Italy;Juventus;1;IT
Nicola;Caricola;Italy;Juventus;1;IT
Bruno;Limido;Italy;Juventus;1;IT
Fabio;Cudicini;Italy;Milan;1;IT
Angelo;Anquilletti;Italy;Milan;1;IT
Roberto;Rosato;Italy;Milan;1;IT
Saul;Malatrasi;Italy;Internazionale;2;IT
Saul;Malatrasi;Italy;Milan;2;IT
Giovanni;Trapattoni;Italy;Milan;2;IT
Giovanni;Lodetti;Italy;Milan;2;IT
Angelo;Sormani;Italy;Milan;1;IT
Gianni;Rivera;Italy;Milan;2;IT
Pierino;Prati;Italy;Milan;1;IT
Giuliano;Sarti;Italy;Internazionale;2;IT
Tarcisio;Burgnich;Italy;Internazionale;2;IT
Aristide;Guarneri;Italy;Internazionale;2;IT
Giacinto;Facchetti;Italy;Internazionale;2;IT
Gianfranco;Bedin;Italy;Internazionale;1;IT
Armando;Picchi;Italy;Internazionale;2;IT
Sandro;Mazzola;Italy;Internazionale;2;IT
Mario;Corso;Italy;Internazionale;2;IT
Carlo;Tagnin;Italy;Internazionale;1;IT
Aurelio;Milani;Italy;Internazionale;1;IT
Giorgio;Ghezzi;Italy;Milan;1;IT
Mario;David;Italy;Milan;1;IT
Mario;Trebbi;Italy;Milan;1;IT
Cesare;Maldini;Italy;Milan;1;IT
Gino;Pivatelli;Italy;Milan;1;IT
Bruno;Mora;Italy;Milan;1;IT
McDonald;Mariga;Kenya;Internazionale;1;KE
Edgaras;Jankauskas;Lithuania;Porto;1;LT
Goran;Pandev;Macedonia;Internazionale;1;MK
Seydou;Keita;Mali;Barcelona;2;ML
Djimi;Traoré;Mali;Liverpool;1;ML
Rafael;Márquez;Mexico;Barcelona;2;MX
Arjen;Robben;Netherlands;Bayern Munich;1;NL
Ibrahim;Afellay;Netherlands;Barcelona;1;NL
Wesley;Sneijder;Netherlands;Internazionale;1;NL
Jaap;Stam;Netherlands;Manchester United;1;NL
Clarence;Seedorf;Netherlands;Ajax;4;NL
Clarence;Seedorf;Netherlands;Real Madrid;4;NL
Clarence;Seedorf;Netherlands;Milan;4;NL
Michael;Reiziger;Netherlands;Ajax;1;NL
Danny;Blind;Netherlands;Ajax;1;NL
Frank;Rijkaard;Netherlands;Milan;3;NL
Frank;Rijkaard;Netherlands;Ajax;3;NL
Edgar;Davids;Netherlands;Ajax;1;NL
Marc;Overmars;Netherlands;Ajax;1;NL
Patrick;Kluivert;Netherlands;Ajax;1;NL
Fred;Grim;Netherlands;Ajax;1;NL
Winston;Bogarde;Netherlands;Ajax;1;NL
Ronald;Koeman;Netherlands;PSV Eindhoven;2;NL
Ronald;Koeman;Netherlands;Barcelona;2;NL
Richard;Witschge;Netherlands;Barcelona;1;NL
Ruud;Gullit;Netherlands;Milan;2;NL
Edward;Linskens;Netherlands;PSV Eindhoven;1;NL
Gerald;Vanenburg;Netherlands;PSV Eindhoven;1;NL
Wim;Kieft;Netherlands;PSV Eindhoven;1;NL
Hans;Gillhaus;Netherlands;PSV Eindhoven;1;NL
Anton;Janssen;Netherlands;PSV Eindhoven;1;NL
Adick;Koot;Netherlands;PSV Eindhoven;1;NL
Eric;Viscaal;Netherlands;PSV Eindhoven;1;NL
Patrick;Lodewijks;Netherlands;PSV Eindhoven;1;NL
Heinz;Stuy;Netherlands;Ajax;3;NL
Wim;Suurbier;Netherlands;Ajax;3;NL
Barry;Hulshoff;Netherlands;Ajax;3;NL
Ruud;Krol;Netherlands;Ajax;2;NL
Johan;Neeskens;Netherlands;Ajax;3;NL
Arnold;Mühren;Netherlands;Ajax;3;NL
Gerrie;Mühren;Netherlands;Ajax;3;NL
Arie;Haan;Netherlands;Ajax;3;NL
Johnny;Rep;Netherlands;Ajax;1;NL
Johan;Cruijff;Netherlands;Ajax;3;NL
Piet;Keizer;Netherlands;Ajax;3;NL
Sjaak;Swart;Netherlands;Ajax;2;NL
Nico;Rijnders;Netherlands;Ajax;1;NL
Piet;Romeijn;Netherlands;Feyenoord;1;NL
Guus;Haak;Netherlands;Feyenoord;1;NL
Theo;Laseroms;Netherlands;Feyenoord;1;NL
Rinus;Israël;Netherlands;Feyenoord;1;NL
Wim;Jansen;Netherlands;Feyenoord;1;NL
Henk;Wery;Netherlands;Feyenoord;1;NL
Coen;Moulijn;Netherlands;Feyenoord;1;NL
Finidi;George;Nigeria;Ajax;1;NG
Nwankwo;Kanu;Nigeria;Ajax;1;NG
Martin;Ødegaard;Norway;Real Madrid;1;NO
Ronny;Johnsen;Norway;Manchester United;1;NO
Henning;Berg;Norway;Manchester United;1;NO
Steinar;Pedersen;Norway;Borussia Dortmund;1;NO
Juan;Agüero;Paraguay;Real Madrid;1;PY
Claudio;Pizarro;Peru;Bayern Munich;1;PE
Tomasz;Kuszczak;Poland;Manchester United;1;PL
Jerzy;Dudek;Poland;Liverpool;1;PL
Józef;Mlynarczyk;Poland;Porto;1;PL
Zbigniew;Boniek;Poland;Juventus;1;PL
Fábio;Coentrão;Portugal;Real Madrid;1;PT
José;Bosingwa;Portugal;Porto;2;PT
José;Bosingwa;Portugal;Chelsea;2;PT
Paulo;Ferreira;Portugal;Porto;2;PT
Paulo;Ferreira;Portugal;Chelsea;2;PT
Raul;Meireles;Portugal;Chelsea;1;PT
Ricardo;Quaresma;Portugal;Internazionale;1;PT
Cristiano;Ronaldo;Portugal;Manchester United;3;PT
Cristiano;Ronaldo;Portugal;Real Madrid;3;PT
Vítor;Baía;Portugal;Porto;1;PT
Nuno;Valente;Portugal;Porto;1;PT
Jorge;Costa;Portugal;Porto;1;PT
Ricardo;Carvalho;Portugal;Porto;1;PT
Pedro;Emanuel;Portugal;Porto;1;PT
Pedro;Mendes;Portugal;Porto;1;PT
Ricardo;Costa;Portugal;Porto;1;PT
Rui;Costa;Portugal;Milan;1;PT
Luís;Figo;Portugal;Real Madrid;1;PT
Paulo;Sousa;Portugal;Juventus;2;PT
Paulo;Sousa;Portugal;Borussia Dortmund;2;PT
João;Pinto;Portugal;Porto;1;PT
Eduardo;Luís;Portugal;Porto;1;PT
Augusto;Inácio;Portugal;Porto;1;PT
Antonio;Frasco;Portugal;Porto;1;PT
Jaime;Magalhães;Portugal;Porto;1;PT
António;André;Portugal;Porto;1;PT
António;Sousa;Portugal;Porto;1;PT
Paulo;Futre;Portugal;Porto;1;PT
Zé;Beto;Portugal;Porto;1;PT
Costa;Pereira;Portugal;Benfica;2;PT
Mario;João;Portugal;Benfica;2;PT
Angelo;Martins;Portugal;Benfica;2;PT
Domiciano;Cávem;Portugal;Benfica;2;PT
Fernando;Cruz;Portugal;Benfica;2;PT
José;Augusto;Portugal;Benfica;2;PT
José;Aguas;Portugal;Benfica;2;PT
Mário;Coluna;Portugal;Benfica;2;PT
António;Simões;Portugal;Benfica;1;PT
José;Neto;Portugal;Benfica;1;PT
Joaquim;Santana;Portugal;Benfica;1;PT
Cristian;Chivu;Romania;Internazionale;1;RO
Florin;R?ducioiu;Romania;Milan;1;RO
Miodrag;Belodedici;Romania;Steaua Bucure?ti;2;RO
Miodrag;Belodedici;Romania;Red Star Belgrade;2;RO
Helmuth;Duckadam;Romania;Steaua Bucure?ti;1;RO
?tefan;Iovan;Romania;Steaua Bucure?ti;1;RO
Adrian;Bumbescu;Romania;Steaua Bucure?ti;1;RO
Ilie;B?rbulescu;Romania;Steaua Bucure?ti;1;RO
Gavril;Balint;Romania;Steaua Bucure?ti;1;RO
Lucian;B?lan;Romania;Steaua Bucure?ti;1;RO
Anghel;Iord?nescu;Romania;Steaua Bucure?ti;1;RO
Ladislau;Bölöni;Romania;Steaua Bucure?ti;1;RO
Mihail;Majearu;Romania;Steaua Bucure?ti;1;RO
Marius;L?c?tu?;Romania;Steaua Bucure?ti;1;RO
Victor;Pi?urc?;Romania;Steaua Bucure?ti;1;RO
Marin;Radu;Romania;Steaua Bucure?ti;1;RO
Dumitru;Stângaciu;Romania;Steaua Bucure?ti;1;RO
Tudorel;Stoica;Romania;Steaua Bucure?ti;1;RO
Dmitri;Alenichev;Russia;Porto;1;RU
Vladimir;But;Russia;Borussia Dortmund;1;RU
Igor;Dobrovolski;Russia;Marseille;1;RU
Darren;Fletcher;Scotland;Manchester United;1;GB
Paul;Lambert;Scotland;Borussia Dortmund;1;GB
Alan;Hansen;Scotland;Liverpool;3;GB
Steve;Nicol;Scotland;Liverpool;1;GB
Graeme;Souness;Scotland;Liverpool;3;GB
Kenny;Dalglish;Scotland;Liverpool;3;GB
Gary;Gillespie;Scotland;Liverpool;1;GB
Allan;Evans;Scotland;Aston Villa;1;GB
Ken;McNaught;Scotland;Aston Villa;1;GB
Des;Bremner;Scotland;Aston Villa;1;GB
Frank;Gray;Scotland;Nottingham Forest;1;GB
Kenny;Burns;Scotland;Nottingham Forest;2;GB
John;McGovern;Scotland;Nottingham Forest;2;GB
John;O'Hare;Scotland;Nottingham Forest;1;GB
John;Robertson;Scotland;Nottingham Forest;2;GB
Pat;Crerand;Scotland;Manchester United;1;GB
Francis;Burns;Scotland;Manchester United;1;GB
John;Fitzpatrick;Scotland;Manchester United;1;GB
Jimmy;Ryan;Scotland;Manchester United;1;GB
Ronnie;Simpson;Scotland;Celtic;1;GB
Jim;Craig;Scotland;Celtic;1;GB
Tommy;Gemmell;Scotland;Celtic;1;GB
Bobby;Murdoch;Scotland;Celtic;1;GB
Billy;McNeill;Scotland;Celtic;1;GB
John;Clark;Scotland;Celtic;1;GB
Jimmy;Johnstone;Scotland;Celtic;1;GB
William;Wallace;Scotland;Celtic;1;GB
Stevie;Chalmers;Scotland;Celtic;1;GB
Bertie;Auld;Scotland;Celtic;1;GB
Bobby;Lennox;Scotland;Celtic;1;GB
John;Fallon;Scotland;Celtic;1;GB
Branislav;Ivanovi?;Serbia;Chelsea;1;RS
Dejan;Stankovi?;Serbia;Internazionale;1;RS
Nemanja;Vidi?;Serbia;Manchester United;1;RS
Rene;Krhin;Slovenia;Internazionale;1;SI
Mariano;Díaz;Spain;Real Madrid;1;ES
Kiko;Casilla;Spain;Real Madrid;1;ES
Lucas;Vázquez;Spain;Real Madrid;1;ES
Sandro;Ramírez;Spain;Barcelona;1;ES
Sergi;Samper;Spain;Barcelona;1;ES
Jordi;Masip;Spain;Barcelona;1;ES
Martín;Montoya;Spain;Barcelona;1;ES
Sergi;Roberto;Spain;Barcelona;1;ES
Jordi;Alba;Spain;Barcelona;1;ES
Álvaro;Morata;Spain;Real Madrid;1;ES
Asier;Illarramendi;Spain;Real Madrid;1;ES
Diego;López;Spain;Real Madrid;1;ES
Dani;Carvajal;Spain;Real Madrid;2;ES
Álvaro;Arbeloa;Spain;Real Madrid;2;ES
Sergio;Ramos;Spain;Real Madrid;2;ES
Javi;Martínez;Spain;Bayern Munich;1;ES
Juan;Mata;Spain;Chelsea;1;ES
Oriol;Romeu;Spain;Chelsea;1;ES
Fernando;Torres;Spain;Chelsea;1;ES
Marc;Bartra;Spain;Barcelona;2;ES
Andreu;Fontàs;Spain;Barcelona;1;ES
David;Villa;Spain;Barcelona;1;ES
Sergio;Busquets;Spain;Barcelona;3;ES
Gerard;Piqué;Spain;Manchester United;4;ES
Gerard;Piqué;Spain;Barcelona;4;ES
Víctor;Valdés;Spain;Barcelona;3;ES
Carles;Puyol;Spain;Barcelona;3;ES
Andrés;Iniesta;Spain;Barcelona;4;ES
Albert;Jorquera;Spain;Barcelona;2;ES
Santiago;Ezquerro;Spain;Barcelona;1;ES
Xabi;Alonso;Spain;Liverpool;2;ES
Xabi;Alonso;Spain;Real Madrid;2;ES
Luis;García;Spain;Liverpool;1;ES
Antonio;Núñez;Spain;Liverpool;1;ES
César;Sánchez;Spain;Real Madrid;1;ES
Pedro;Munitis;Spain;Real Madrid;1;ES
Francisco;Pavón;Spain;Real Madrid;1;ES
Javier;Portillo;Spain;Real Madrid;1;ES
Carlos;Sánchez;Spain;Real Madrid;1;ES
Albert;Celades;Spain;Real Madrid;1;ES
Óscar;Miñambres;Spain;Real Madrid;1;ES
Enrique;Corrales;Spain;Real Madrid;1;ES
Raúl;Bravo;Spain;Real Madrid;1;ES
Javier;Dorado;Spain;Real Madrid;1;ES
David;Aganzo;Spain;Real Madrid;1;ES
Manuel;Meca;Spain;Real Madrid;1;ES
Iván;Campo;Spain;Real Madrid;2;ES
Míchel;Salgado;Spain;Real Madrid;2;ES
Iván;Helguera;Spain;Real Madrid;2;ES
Carlos;Aranda;Spain;Real Madrid;2;ES
José;Amavisca;Spain;Real Madrid;1;ES
Dani;García;Spain;Real Madrid;1;ES
Jaime;Sánchez;Spain;Real Madrid;1;ES
Santiago;Cañizares;Spain;Real Madrid;1;ES
Fernando;Sanz;Spain;Real Madrid;1;ES
Víctor;Sánchez;Spain;Real Madrid;1;ES
Pedro;Contreras;Spain;Real Madrid;1;ES
Raúl;Pareja;Spain;Real Madrid;1;ES
Manuel;Canabal;Spain;Real Madrid;1;ES
Álvaro;Benito;Spain;Real Madrid;1;ES
Roberto;Rojas;Spain;Real Madrid;1;ES
Manolo;Sanchís;Spain;Real Madrid;2;ES
Fernando;Hierro;Spain;Real Madrid;3;ES
Fernando;Morientes;Spain;Real Madrid;3;ES
Iker;Casillas;Spain;Real Madrid;3;ES
Aitor;Karanka;Spain;Real Madrid;3;ES
Andoni;Zubizarreta;Spain;Barcelona;1;ES
Eusebio;Sacristán;Spain;Barcelona;1;ES
Albert;Ferrer;Spain;Barcelona;1;ES
Juan;Carlos;Spain;Barcelona;1;ES
Pep;Guardiola;Spain;Barcelona;1;ES
Julio;Salinas;Spain;Barcelona;1;ES
Andoni;Goikoetxea;Spain;Barcelona;1;ES
Ricardo;Serna;Spain;Barcelona;1;ES
Cristóbal;Parralo;Spain;Barcelona;1;ES
Guillermo;Amor;Spain;Barcelona;1;ES
Aitor;Beguiristain;Spain;Barcelona;1;ES
Carles;Busquets;Spain;Barcelona;1;ES
José;Araquistáin;Spain;Real Madrid;1;ES
Antonio;Betancort;Spain;Real Madrid;1;ES
Ramón;Tejada;Spain;Real Madrid;1;ES
Vicente;Miera;Spain;Real Madrid;1;ES
Antonio;Calpe;Spain;Real Madrid;1;ES
Ignacio;Zoco;Spain;Real Madrid;1;ES
Manuel;Velázquez;Spain;Real Madrid;1;ES
Fernando;Serena;Spain;Real Madrid;1;ES
Félix;Ruiz;Spain;Real Madrid;1;ES
Amancio;Amaro;Spain;Real Madrid;1;ES
Ramón;Grosso;Spain;Real Madrid;1;ES
Joaquín;Peiró;Spain;Internazionale;1;ES
Luis;Suárez;Spain;Internazionale;2;ES
Manuel;Bueno;Spain;Real Madrid;2;ES
Jesús;Herrera;Spain;Real Madrid;2;ES
Manuel;Torres;Spain;Real Madrid;1;ES
Berasaluce;Marquiegui;Spain;Real Madrid;1;ES
Enrique;Mateos[2];Spain;Real Madrid;4;ES
Luis;Molowny;Spain;Real Madrid;1;ES
Pérez-Payá;Soler;Spain;Real Madrid;1;ES
Joaquín;Navarro;Spain;Real Madrid;2;ES
Joaquín;Oliva;Spain;Real Madrid;2;ES
Angel;Atienza;Spain;Real Madrid;3;ES
Miguel;Muñoz;Spain;Real Madrid;3;ES
Becerril;Minguela;Spain;Real Madrid;3;ES
Héctor;Rial;Spain;Real Madrid;5;ES
Juan;Alonso[4];Spain;Real Madrid;5;ES
Juan;Santisteban;Spain;Real Madrid;5;ES
Rafael;Lesmes;Spain;Real Madrid;5;ES
Francisco;Gento;Spain;Real Madrid;6;ES
Henrik;Larsson;Sweden;Barcelona;1;SE
Patrik;Andersson;Sweden;Bayern Munich;1;SE
Jesper;Blomqvist;Sweden;Manchester United;1;SE
Björn;Andersson;Sweden;Bayern Munich;1;SE
Conny;Torstensson;Sweden;Bayern Munich;3;SE
Ove;Kindvall;Sweden;Feyenoord;1;SE
Kurt;Hamrin;Sweden;Milan;1;SE
Xherdan;Shaqiri;Switzerland;Bayern Munich;1;CH
Ciriaco;Sforza;Switzerland;Bayern Munich;1;CH
Stéphane;Chapuisat;Switzerland;Borussia Dortmund;1;CH
Anatoliy;Tymoshchuk;Ukraine;Bayern Munich;1;UA
Andriy;Shevchenko;Ukraine;Milan;1;UA
Luis;Suárez;Uruguay;Barcelona;1;UY
Martín;Cáceres;Uruguay;Barcelona;1;UY
José;Santamaría;Uruguay;Real Madrid;4;UY
Gareth;Bale;Wales;Real Madrid;2;GB
Ryan;Giggs;Wales;Manchester United;2;GB
Ian;Rush;Wales;Liverpool;1;GB
Joey;Jones;Wales;Liverpool;2;GB
Perica;Ognjenovi?;Yugoslavia;Real Madrid;1;CS
Predrag;Mijatovi?;Yugoslavia;Real Madrid;1;CS
Stevan;Stojanovi?;Yugoslavia;Red Star Belgrade;1;CS
Ilija;Najdoski;Yugoslavia;Red Star Belgrade;1;CS
Refik;Šabanadžovi?;Yugoslavia;Red Star Belgrade;1;CS
Slobodan;Marovi?;Yugoslavia;Red Star Belgrade;1;CS
Siniša;Mihajlovi?;Yugoslavia;Red Star Belgrade;1;CS
Dragiša;Bini?;Yugoslavia;Red Star Belgrade;1;CS
Robert;Prosine?ki;Yugoslavia;Red Star Belgrade;1;CS
Darko;Pan?ev;Yugoslavia;Red Star Belgrade;1;CS
Vlada;Stoši?;Yugoslavia;Red Star Belgrade;1;CS
Mili?;Jovanovi?;Yugoslavia;Red Star Belgrade;1;CS
Ivica;Mom?ilovi?;Yugoslavia;Red Star Belgrade;1;CS
Rade;Toši?;Yugoslavia;Red Star Belgrade;1;CS
Vladan;Luki?;Yugoslavia;Red Star Belgrade;1;CS
Velibor;Vasovi?;Yugoslavia;Ajax;1;CS
Bruce;Grobbelaar;Zimbabwe;Liverpool;1;ZW- SAP Managed Tags:
