Hi Everyone

I have been asked to look in to creating data constellations with visual discovery. I have searched the IBI site and everything I find is very vague on this. I know I need two data files: nodes and links but they never provide samples of what these files actually look like.

I am sure I can get this to work once I see some sample data files. Does anyone have any sample files with TABLE FILE CAR? Or with any other data?

TIA

Jodye

jodye,

The "links" is basically a two column parent/clild recursive table, and the nodes is just the lowest level child from the links file with the measures you need. The following is an example of the output that was delivered with the product .... well, it was some time ago with I cannot remember what release.

These were tab delimited files, and I replaced the tabs with "^". Change them back and you can use these as an example:

Links File:

Parent^Entity
S^S
Century^Canada
Century^France
Century^Germany
Century^Spain
Century^United States
Canada^Est
Canada^Ouest
France^Nord-Pas-De-Calais
France^Pays de la Loire
France^Provence - Alpes du Sud
France^Île de France
Germany^Nord
Germany^Ost
Germany^Süd
Germany^West
Spain^Andalucía
Spain^Cataluña
Spain^Pais Vasco
United States^East North Central
United States^East South Central
United States^Middle Atlantic
United States^Mountain
United States^New England
United States^North
United States^Pacific
United States^South Atlantic
United States^Web(R)
United States^West North Central
United States^West South Central
Alabama^Maaike Hilbrand
Andalucía^Córdoba
Arizona^Corinne Fabre
Arizona^Frans DeNeve
Arkansas^Marc Fallone
Barcelona^Veronique Treussard
Barcelona^Wendy Hutson
Bavaria^Tiphaine Le Gallic
Bouches-du-Rhône (13)^Theresa Wellman
British Columbia^Roger Iddles
California^AJ Van de Kam
California^Daniel Hagman
California^Ge Kapteijn
California^Karen Hill
California^Petter Holst Johnsen
Cataluña^Barcelona
Colorado^Adriano Prefumo
Colorado^Gil Giati
Colorado^Niklas Schwieler
Connecticut^Akinori Imai
Connecticut^Goran Hagman
Connecticut^Marc Guille
Córdoba^Vincente Moncholi
Delaware^Alex McKay
Delaware^Jong Soo Kim
East North Central^Illinois
East North Central^Indiana
East North Central^Michigan
East North Central^Ohio
East North Central^Wisconsin
East South Central^Alabama
East South Central^Kentucky
East South Central^Tennessee
Est^Manitoba
Est^Ontario
Est^Québec
Florida^Andreas Graff
Florida^Elide Lucas
Florida^Marc Wacongne
Georgia^Elisabeth Rochon-Birac
Georgia^Greg Potter
Georgia^Marcantonio Montesauo
Georgia^Norman Manley
Hawaii^David Lyons
Hawaii^Guenter Luebke
Illinois^Andrew Trousdale
Illinois^Haikke Nienamm
Illinois^Maree Sander
Illinois^Oliver Prentont
Indiana^Deborah Ratcliffe
Indiana^Hector Padilla
Indiana^Olli Kemilla
Kansas^Andy Carter
Kansas^Deigo Castano
Kentucky^Anthony Au
Kentucky^Deiter Wolf
Kentucky^Osamu Arai
Loire-Atlantique (44)^Sarah Terrey
Louisiana^Heinz Gehri
Manitoba^Sarah Gunnell
Maryland^Barry Phillips
Maryland^Carlos Garcia
Maryland^Jose Soto
Maryland^Paolo Sferlazza
Massachusetts^Arild Kristensen
Massachusetts^Denise Daddario
Massachusetts^Helene Dibon
Michigan^Carlos Vadesuso
Michigan^Ellen Roccisano
Middle Atlantic^New Jersey
Middle Atlantic^New York
Middle Atlantic^Pennsylvania
Minnesota^Henri van den Bergh
Minnesota^Philip Van Peperstraete
Missouri^Dennis Bartels
Missouri^Hyo Jin Ahn
Missouri^Mark Ragel
Missouri^Pascal Rawsin
Mountain^Arizona
Mountain^Colorado
Mountain^Nevada
Mountain^Wyoming
Nebraska^Ian Bramley
Nevada^Jan Gamola
Nevada^Ken Tierney
New England^Connecticut
New England^Massachusetts
New England^Vermont
New Jersey^Diego Cordoba
New Jersey^Karl-Heinz Zsenserling
New Jersey^Markku Kivela
New Jersey^Patrick Churchville
New Jersey^Pierre Lemaire
New York^Betty Hong
New York^Catherine Diacre
New York^Jacky Li
New York^Jean Marie Fritel
New York^Markus Wenger
New York^Patrick Infante
Nord^Schleswig-Holstein
Nord (59)^Steve Scott
Nord-Pas-De-Calais^Nord (59)
North^Minnesota
North Carolina^Benoit de la Tour
North Rhine-Westphalia^Thomas Schwieler
Ohio^Christopher Fox
Ohio^Enrique Barragan
Ohio^Joe Cisneros
Ohio^Martin Nissim
Oklahoma^Franck Darriet
Oklahoma^Joe Korting
Oklahoma^Paul-Jan Piekema
Ontario^Robin DeWitte
Oregon^Bill Flynn
Ost^Saxony
Ouest^British Columbia
Pacific^California
Pacific^Hawaii
Pacific^Oregon
Pacific^Washington
Pais Vasco^Vizcaya
Paris (75)^Stef Deboutte
Pays de la Loire^Loire-Atlantique (44)
Pennsylvania^Eberhard Steen
Pennsylvania^Joe Riberio
Pennsylvania^Michael Hayes
Pennsylvania^Richard Pool
Provence - Alpes du Sud^Bouches-du-Rhône (13)
Québec^Roberto Mendez
Saxony^Tsutomo Nakanishi
Schleswig-Holstein^Tracy Reid
South Atlantic^Delaware
South Atlantic^Florida
South Atlantic^Georgia
South Atlantic^Maryland
South Atlantic^North Carolina
South Atlantic^South Carolina
South Atlantic^Virginia
South Carolina^John Manning
Süd^Bavaria
Tennessee^Ebner Christian
Tennessee^Miguel Leche
Texas^Bjorn Danielson
Texas^Franco Ricotti
Texas^Kelley Faux
Texas^Kevin Magee
Texas^Monica Iglesias
Texas^Per Persson
Vermont^Brian Lester
Virginia^Blanca Revilla
Virginia^Nic Wong
Vizcaya^Valerie Larens
Washington^John Osborn
Washington^Paul Joynes
Web(R)^Web(S)
Web(S)^Web
West^North Rhine-Westphalia
West North Central^Kansas
West North Central^Missouri
West North Central^Nebraska
West South Central^Arkansas
West South Central^Louisiana
West South Central^Oklahoma
West South Central^Texas
Wisconsin^Edwin Langweeg
Wisconsin^Josef Rabacher
Wisconsin^Nico Berger
Wyoming^Jon Piercey
Île de France^Paris (75)  

Nodes File:

  
Entity^Tier^Revenue^Legend^Role^Quota%^Leads^Visits
S^I^R^S^S^R^I^I
AJ Van de Kam^1^20885103.00^Sales Reps^Hunter^71.47^5^6
Adriano Prefumo^1^1409675.00^Sales Reps^Farmer^5.98^54^67
Akinori Imai^1^5139363.00^Sales Reps^Hybrid^98.87^74^92
Alabama^2^863627.00^Branches^N/A^48.27^38^47
Alex McKay^1^4787094.00^Sales Reps^Hunter^42.11^24^30
Andalucía^3^12742615.00^Regions^N/A^47.74^34^42
Andreas Graff^1^4078487.00^Sales Reps^Hunter^45.72^24^30
Andrew Trousdale^1^11979479.00^Sales Reps^Farmer^.66^4^5
Andy Carter^1^227409.00^Sales Reps^Hybrid^44.80^2^2
Anthony Au^1^962963.00^Sales Reps^Hunter^56.35^40^50
Arild Kristensen^1^50379924.00^Sales Reps^Farmer^26.75^28^35
Arizona^2^5457017.00^Branches^N/A^72.81^32^40
Arkansas^2^7228349.00^Branches^N/A^68.33^7^8
Barcelona^2^44428015.00^Branches^N/A^42.53^69^86
Barry Phillips^1^43419919.00^Sales Reps^Hunter^12.02^78^97
Bavaria^2^19516104.00^Branches^N/A^27.16^44^55
Benoit de la Tour^1^2642693.00^Sales Reps^Hunter^49.65^55^68
Betty Hong^1^35714713.00^Sales Reps^Farmer^64.35^45^56
Bill Flynn^1^2153944.00^Sales Reps^Hybrid^3.51^93^116
Bjorn Danielson^1^49906101.00^Sales Reps^Hunter^4.62^56^70
Blanca Revilla^1^17741665.00^Sales Reps^Farmer^49.36^42^52
Bouches-du-Rhône (13)^2^26361768.00^Branches^N/A^83.19^30^37
Brian Lester^1^4734066.00^Sales Reps^Hunter^2.02^1^1
British Columbia^2^28018061.00^Branches^N/A^56.61^17^21
California^2^92855583.00^Branches^N/A^35.79^107^133
Canada^4^181714046.00^Country^N/A^39.67^17^21
Carlos Garcia^1^331439.00^Sales Reps^Hunter^25.37^94^117
Carlos Vadesuso^1^1116317.00^Sales Reps^Farmer^35.98^4^5
Cataluña^3^44428015.00^Regions^N/A^52.98^38^47
Catherine Diacre^1^10972296.00^Sales Reps^Hunter^27.56^44^55
Century^5^1561923919.00^Century^N/A^49.72^18^22
Christopher Fox^1^18160324.00^Sales Reps^Hunter^46.55^15^18
Colorado^2^16872906.00^Branches^N/A^37.21^98^122
Connecticut^2^36114331.00^Branches^N/A^44.60^10^12
Corinne Fabre^1^2365929.00^Sales Reps^Hunter^70.27^29^36
Córdoba^2^12742615.00^Branches^N/A^15.82^44^55
Daniel Hagman^1^15352545.00^Sales Reps^Hunter^86.68^13^16
David Lyons^1^945625.00^Sales Reps^Farmer^6.75^54^67
Deborah Ratcliffe^1^12303314.00^Sales Reps^Hybrid^27.01^89^111
Deigo Castano^1^2865151.00^Sales Reps^Hunter^37.99^45^56
Deiter Wolf^1^5842548.00^Sales Reps^Farmer^45.82^2^2
Delaware^2^31191663.00^Branches^N/A^.48^11^13
Denise Daddario^1^9786369.00^Sales Reps^Hunter^71.85^16^20
Dennis Bartels^1^8513602.00^Sales Reps^Farmer^11.99^57^71
Diego Cordoba^1^3511145.00^Sales Reps^Hybrid^99.25^118^147
East North Central^3^186435937.00^Regions^N/A^51.71^18^22
East South Central^3^21009294.00^Regions^N/A^13.14^44^55
Eberhard Steen^1^2342878.00^Sales Reps^Hunter^46.23^13^16
Ebner Christian^1^3280311.00^Sales Reps^Farmer^54.98^9^11
Edwin Langweeg^1^6928524.00^Sales Reps^Hybrid^80.53^118^147
Elide Lucas^1^5179256.00^Sales Reps^Hunter^77.90^5^6
Elisabeth Rochon-Birac^1^32470686.00^Sales Reps^Farmer^57.89^13^16
Ellen Roccisano^1^24822455.00^Sales Reps^Hybrid^57.78^49^61
Enrique Barragan^1^2786784.00^Sales Reps^Hunter^91.11^64^80
Est^3^153695985.00^Regions^N/A^40.67^3^3
Florida^2^55400248.00^Branches^N/A^75.47^9^11
France^4^65482052.00^Country^N/A^17.29^7^8
Franck Darriet^1^16697776.00^Sales Reps^Hunter^84.80^62^77
Franco Ricotti^1^21579887.00^Sales Reps^Farmer^62.40^53^66
Frans DeNeve^1^3091088.00^Sales Reps^Hybrid^82.75^43^53
Ge Kapteijn^1^36006767.00^Sales Reps^Hunter^52.41^18^22
Georgia^2^52898327.00^Branches^N/A^12.92^7^8
Germany^4^86208655.00^Country^N/A^81.09^11^13
Gil Giati^1^13672564.00^Sales Reps^Hunter^57.91^21^26
Goran Hagman^1^5937555.00^Sales Reps^Farmer^6.46^30^37
Greg Potter^1^1726837.00^Sales Reps^Hybrid^19.11^1^1
Guenter Luebke^1^1176866.00^Sales Reps^Hunter^94.74^26^32
Haikke Nienamm^1^17867088.00^Sales Reps^Farmer^89.94^75^93
Hawaii^2^2122491.00^Branches^N/A^21.08^20^25
Hector Padilla^1^8828361.00^Sales Reps^Hunter^70.08^5^6
Heinz Gehri^1^1658147.00^Sales Reps^Farmer^12.30^48^60
Helene Dibon^1^6331980.00^Sales Reps^Hybrid^33.00^45^56
Henri van den Bergh^1^8783101.00^Sales Reps^Hunter^73.76^26^32
Hyo Jin Ahn^1^1264716.00^Sales Reps^Farmer^30.63^20^25
Ian Bramley^1^2704776.00^Sales Reps^Hybrid^55.42^26^32
Illinois^2^64131018.00^Branches^N/A^8.87^1^1
Indiana^2^27684694.00^Branches^N/A^21.47^39^48
Jacky Li^1^15354411.00^Sales Reps^Hunter^36.11^25^31
Jan Gamola^1^1043505.00^Sales Reps^Farmer^51.14^38^47
Jean Marie Fritel^1^22855868.00^Sales Reps^Hybrid^40.24^7^8
Joe Cisneros^1^944446.00^Sales Reps^Hunter^88.44^32^40
Joe Korting^1^2504778.00^Sales Reps^Farmer^80.51^4^5
Joe Riberio^1^21162597.00^Sales Reps^Hybrid^42.24^13^16
John Manning^1^113190.00^Sales Reps^Hunter^62.81^47^58
John Osborn^1^1908327.00^Sales Reps^Farmer^75.39^15^18
Jon Piercey^1^769747.00^Sales Reps^Hybrid^.76^28^35
Jong Soo Kim^1^26404569.00^Sales Reps^Hunter^25.54^89^111
Jose Soto^1^6889774.00^Sales Reps^Farmer^95.11^94^117
Josef Rabacher^1^9630907.00^Sales Reps^Hybrid^22.95^54^67
Kansas^2^3092560.00^Branches^N/A^27.97^71^88
Karen Hill^1^10375941.00^Sales Reps^Hunter^63.26^36^45
Karl-Heinz Zsenserling^1^12222686.00^Sales Reps^Farmer^10.86^12^15
Kelley Faux^1^1655675.00^Sales Reps^Hybrid^6.44^45^56
Ken Tierney^1^1301840.00^Sales Reps^Hunter^93.53^50^62
Kentucky^2^16391771.00^Branches^N/A^96.77^74^92
Kevin Magee^1^5100742.00^Sales Reps^Hunter^24.53^96^120
Loire-Atlantique (44)^2^15187055.00^Branches^N/A^35.57^9^11
Louisiana^2^1658147.00^Branches^N/A^61.15^31^38
Maaike Hilbrand^1^863627.00^Sales Reps^Hunter^25.92^49^61
Manitoba^2^14164247.00^Branches^N/A^10.57^87^108
Marc Fallone^1^7228349.00^Sales Reps^Hunter^66.02^73^91
Marc Guille^1^25037413.00^Sales Reps^Farmer^81.90^4^5
Marc Wacongne^1^46142505.00^Sales Reps^Hybrid^40.15^31^38
Marcantonio Montesauo^1^14720194.00^Sales Reps^Hunter^65.05^3^3
Maree Sander^1^19358735.00^Sales Reps^Farmer^30.32^15^18
Mark Ragel^1^534888.00^Sales Reps^Hybrid^10.63^36^45
Markku Kivela^1^480189.00^Sales Reps^Hunter^14.27^74^92
Markus Wenger^1^13701421.00^Sales Reps^Farmer^82.28^4^5
Martin Nissim^1^28482733.00^Sales Reps^Hybrid^38.50^23^28
Maryland^2^51036687.00^Branches^N/A^22.72^18^22
Massachusetts^2^66498273.00^Branches^N/A^98.77^53^66
Michael Hayes^1^10947524.00^Sales Reps^Hunter^23.52^70^87
Michigan^2^25938772.00^Branches^N/A^9.42^17^21
Middle Atlantic^3^207522394.00^Regions^N/A^64.97^8^10
Miguel Leche^1^473585.00^Sales Reps^Hunter^45.40^56^70
Minnesota^2^30981509.00^Branches^N/A^58.27^64^80
Missouri^2^10946718.00^Branches^N/A^63.97^27^33
Monica Iglesias^1^2185970.00^Sales Reps^Hunter^90.25^21^26
Mountain^3^25445015.00^Regions^N/A^16.00^25^31
Nebraska^2^2704776.00^Branches^N/A^18.26^43^53
Nevada^2^2345345.00^Branches^N/A^98.39^13^16
New England^3^107346670.00^Regions^N/A^73.86^4^5
New Jersey^2^57749627.00^Branches^N/A^15.13^30^37
New York^2^110433472.00^Branches^N/A^1.23^105^131
Nic Wong^1^1811301.00^Sales Reps^Hunter^82.07^118^147
Nico Berger^1^1747735.00^Sales Reps^Farmer^78.95^7^8
Niklas Schwieler^1^1790667.00^Sales Reps^Hybrid^60.65^7^8
Nord^3^9935337.00^Regions^N/A^24.59^35^43
Nord (59)^2^8726547.00^Branches^N/A^5.53^16^20
Nord-Pas-De-Calais^3^8726547.00^Regions^N/A^43.65^37^46
Norman Manley^1^3980610.00^Sales Reps^Hunter^45.73^10^12
North^3^30981509.00^Regions^N/A^66.67^18^22
North Carolina^2^2642693.00^Branches^N/A^62.64^63^78
North Rhine-Westphalia^2^12409822.00^Branches^N/A^1.91^19^23
Ohio^2^50374287.00^Branches^N/A^19.49^10^12
Oklahoma^2^20809004.00^Branches^N/A^47.07^19^23
Oliver Prentont^1^14925716.00^Sales Reps^Hunter^19.22^138^172
Olli Kemilla^1^6553019.00^Sales Reps^Farmer^90.37^25^31
Ontario^2^135294247.00^Branches^N/A^73.38^65^81
Oregon^2^2153944.00^Branches^N/A^63.00^5^6
Osamu Arai^1^9586260.00^Sales Reps^Hunter^63.31^25^31
Ost^3^44347392.00^Regions^N/A^9.92^13^16
Ouest^3^28018061.00^Regions^N/A^65.61^5^6
Pacific^3^108800705.00^Regions^N/A^1.39^144^180
Pais Vasco^3^12307019.00^Regions^N/A^67.86^8^10
Paolo Sferlazza^1^395555.00^Sales Reps^Hunter^87.56^58^72
Paris (75)^2^15206682.00^Branches^N/A^94.25^66^82
Pascal Rawsin^1^633512.00^Sales Reps^Hunter^76.43^33^41
Patrick Churchville^1^36016255.00^Sales Reps^Farmer^32.36^82^102
Patrick Infante^1^11834763.00^Sales Reps^Hybrid^70.93^25^31
Paul Joynes^1^9760360.00^Sales Reps^Hunter^44.42^79^98
Paul-Jan Piekema^1^1606450.00^Sales Reps^Farmer^27.35^54^67
Pays de la Loire^3^15187055.00^Regions^N/A^13.53^76^95
Pennsylvania^2^39339295.00^Branches^N/A^88.60^37^46
Per Persson^1^1018203.00^Sales Reps^Hunter^38.79^74^92
Petter Holst Johnsen^1^10235227.00^Sales Reps^Farmer^68.43^22^27
Philip Van Peperstraete^1^22198408.00^Sales Reps^Hybrid^47.12^37^46
Pierre Lemaire^1^5519352.00^Sales Reps^Hunter^19.67^43^53
Provence - Alpes du Sud^3^26361768.00^Regions^N/A^47.23^17^21
Québec^2^4237491.00^Branches^N/A^25.36^84^105
Richard Pool^1^4886296.00^Sales Reps^Hunter^33.91^105^131
Roberto Mendez^1^4237491.00^Sales Reps^Farmer^23.95^113^141
Robin DeWitte^1^135294247.00^Sales Reps^Hybrid^89.13^9^11
Roger Iddles^1^28018061.00^Sales Reps^Hunter^81.87^55^68
Sarah Gunnell^1^14164247.00^Sales Reps^Farmer^52.83^12^15
Sarah Terrey^1^15187055.00^Sales Reps^Hybrid^29.34^52^65
Saxony^2^44347392.00^Branches^N/A^53.78^31^38
Schleswig-Holstein^2^9935337.00^Branches^N/A^6.93^23^28
South Atlantic^3^212835774.00^Regions^N/A^31.95^53^66
South Carolina^2^113190.00^Branches^N/A^86.86^70^87
Spain^4^69477649.00^Country^N/A^54.55^11^13
Stef Deboutte^1^15206682.00^Sales Reps^Hunter^70.64^29^36
Steve Scott^1^8726547.00^Sales Reps^Farmer^68.29^30^37
Süd^3^19516104.00^Regions^N/A^.19^31^38
Tennessee^2^3753896.00^Branches^N/A^95.23^93^116
Texas^2^81446578.00^Branches^N/A^3.13^79^98
Theresa Wellman^1^26361768.00^Sales Reps^Hunter^52.38^10^12
Thomas Schwieler^1^12409822.00^Sales Reps^Farmer^88.85^40^50
Tiphaine Le Gallic^1^19516104.00^Sales Reps^Hybrid^13.57^20^25
Tracy Reid^1^9935337.00^Sales Reps^Hunter^.33^51^63
Tsutomo Nakanishi^1^44347392.00^Sales Reps^Farmer^17.67^74^92
United States^4^1159041517.00^Country^N/A^8.87^28^35
Valerie Larens^1^12307019.00^Sales Reps^Hunter^68.38^17^21
Vermont^2^4734066.00^Branches^N/A^56.24^27^33
Veronique Treussard^1^17571567.00^Sales Reps^Hunter^58.12^5^6
Vincente Moncholi^1^12742615.00^Sales Reps^Farmer^6.79^8^10
Virginia^2^19552966.00^Branches^N/A^91.06^19^23
Vizcaya^2^12307019.00^Branches^N/A^51.94^8^10
Washington^2^11668687.00^Branches^N/A^27.19^89^111
Web^1^130778087.00^Sales Reps^Hunter^40.50^45^56
Web(R)^3^130778087.00^Regions^N/A^31.38^13^16
Web(S)^2^130778087.00^Branches^N/A^11.70^35^43
Wendy Hutson^1^26856448.00^Sales Reps^Hunter^37.14^1^1
West^3^12409822.00^Regions^N/A^51.64^20^25
West North Central^3^16744054.00^Regions^N/A^80.98^23^28
West South Central^3^111142078.00^Regions^N/A^63.35^11^13
Wisconsin^2^18307166.00^Branches^N/A^25.08^43^53
Wyoming^2^769747.00^Branches^N/A^16.37^39^48
Île de France^3^15206682.00^Regions^N/A^95.32^24^30

Good luck

Thanks a million for that Dhagen. I am sure it will help.

Jodye