V_Verkauf.mdl 105 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212
  1. Name "Neues Modell" ModelCodePage "ibm-5348_P100-1997" AutoAccess False
  2. UpdateCycle 95 ModelStamp 1193670307 Version "10.2.6111.504" ModelCategoryOrderDefault OrderUsePreference
  3. ModelOrderedByDefault False ModelNonRollupHierarchies False
  4. DataSource 1024297 "current_date_Prognose" Separator ";" SourceType FlatFile_ColNames
  5. CharacterSet Ansi DecimalSep "," Thousandsep "." Columns True Timing PopYesCreateDefault
  6. Source "C:\GlobalCube\system\OPTIMA\Export\current_date_Prognose.csv" SetCurrent True
  7. ServerSource False Speed False Presummarized False StreamExtractSize 0
  8. OrgName 1024299 "Bundeslaender Id" Origin Generated Offset 0 Column "Bundeslaender Id"
  9. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  10. OrgName 1024301 "Datum" Origin Generated Offset 1 Column "Invoice Date"
  11. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  12. OrgName 1024303 "Wochentage Id" Origin Generated Offset 2 Column "Wochentage Id"
  13. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  14. OrgName 1024305 "Arbeitstag Mofr" Origin Generated Offset 3 Column "Arbeitstag Mofr"
  15. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  16. OrgName 1024307 "Zaehler Mofr" Origin Generated Offset 4 Column "Zaehler Mofr"
  17. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  18. OrgName 1024309 "Summe Mofr" Origin Generated Offset 5 Column "Summe Mofr"
  19. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  20. OrgName 1024311 "Arbeitstag Mosa" Origin Generated Offset 6 Column "Arbeitstag Mosa"
  21. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  22. OrgName 1024313 "Zaehler Mosa" Origin Generated Offset 7 Column "Zaehler Mosa"
  23. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  24. OrgName 1024315 "Summe Mosa" Origin Generated Offset 8 Column "Summe Mosa"
  25. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  26. OrgName 1024317 "Feiertage Id" Origin Generated Offset 9 Column "Feiertage Id"
  27. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  28. OrgName 1024319 "Jahr" Origin Generated Offset 10 Column "Jahr" Storage Default
  29. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  30. OrgName 1024321 "Arbeitstag Nr Jahr" Origin Generated Offset 11 Column "Arbeitstag Nr Jahr"
  31. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  32. OrgName 1024323 "Gesamt Arbeitstage" Origin Generated Offset 12 Column "Gesamt Arbeitstage"
  33. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  34. DataSource 1023715 "NW_GW_VK_csv" Separator ";" SourceType FlatFile_ColNames
  35. CharacterSet Ansi DecimalSep "," Thousandsep "." Columns True Timing PopYesCreateDefault
  36. Source "C:\GlobalCube\system\OPTIMA\Export\NW_GW_VK_csv.csv" SetCurrent False
  37. ServerSource False Speed False Presummarized False StreamExtractSize 0
  38. OrgName 1023717 "Unit Number" Origin Generated Offset 0 Column "Unit Number"
  39. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  40. OrgName 1023719 "Basis Number" Origin Generated Offset 1 Column "Basis Number"
  41. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  42. OrgName 1023721 "Ecc Status" Origin Generated Offset 2 Column "Ecc Status"
  43. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  44. OrgName 1023723 "Vehicle Type" Origin Generated Offset 3 Column "Vehicle Type"
  45. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  46. OrgName 1023725 "Vehicle Type_vpp5r" Origin Generated Offset 4 Column "Vehicle Type_vpp5r"
  47. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  48. OrgName 1023727 "Vehicle Type Text_vpp5r" Origin Generated Offset 5 Column "Vehicle Type Text_vpp5r"
  49. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  50. OrgName 1023729 "Car Creation Date" Origin Generated Offset 6 Column "Car Creation Date"
  51. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  52. OrgName 1023731 "Depreciation" Origin Generated Offset 7 Column "Depreciation"
  53. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  54. OrgName 1023733 "Book Keeping Code" Origin Generated Offset 118 Column "Book Keeping Code"
  55. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  56. OrgName 1023735 "Book Keeping Code_vpp5m" Origin Generated Offset 9 Column "Book Keeping Code_vpp5m"
  57. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  58. OrgName 1023737 "Specify_vpp5m" Origin Generated Offset 10 Column "Specify_vpp5m"
  59. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  60. OrgName 1023739 "Mileage" Origin Generated Offset 65 Column "Mileage" Storage Default
  61. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  62. OrgName 1023741 "Purch Department" Origin Generated Offset 12 Column "Purch Department"
  63. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  64. OrgName 1023743 "Purch Salsman Code" Origin Generated Offset 13 Column "Purch Salsman Code"
  65. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  66. OrgName 1023745 "Purch Date" Origin Generated Offset 14 Column "Purch Date"
  67. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  68. OrgName 1023747 "Reception Date" Origin Generated Offset 15 Column "Reception Date"
  69. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  70. OrgName 1023749 "Sales Department" Origin Generated Offset 16 Column "Sales Department"
  71. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  72. OrgName 1023751 "Department Type Id_Dep" Origin Generated Offset 17 Column "Department Type Id_Dep"
  73. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  74. OrgName 1023753 "Description_Dep" Origin Generated Offset 18 Column "Description_Dep"
  75. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  76. OrgName 1023755 "Sale Salesman" Origin Generated Offset 19 Column "Sale Salesman"
  77. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  78. OrgName 1023757 "Seller Code_vpp43" Origin Generated Offset 20 Column "Seller Code_vpp43"
  79. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  80. OrgName 1023759 "Sel Name_vpp43" Origin Generated Offset 21 Column "Sel Name_vpp43"
  81. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  82. OrgName 1023761 "Sel Family Name_vpp43" Origin Generated Offset 22 Column "Sel Family Name_vpp43"
  83. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  84. OrgName 1023763 "Sale Inv Number" Origin Generated Offset 23 Column "Sale Inv Number"
  85. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  86. OrgName 1023765 "Sale Date" Origin Generated Offset 24 Column "Sale Date"
  87. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  88. OrgName 1023767 "Bud Sale Det" Origin Generated Offset 25 Column "Bud Sale Det"
  89. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  90. OrgName 1023769 "Bud Purch Price" Origin Generated Offset 26 Column "Bud Purch Price"
  91. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  92. OrgName 1023771 "Bud Reg Fee" Origin Generated Offset 27 Column "Bud Reg Fee"
  93. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  94. OrgName 1023773 "Bud Deduct Fee" Origin Generated Offset 28 Column "Bud Deduct Fee"
  95. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  96. OrgName 1023775 "Bud Cost" Origin Generated Offset 29 Column "Bud Cost"
  97. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  98. OrgName 1023777 "Purch Price Unit" Origin Generated Offset 30 Column "Purch Price Unit"
  99. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  100. OrgName 1023779 "Cost Unit" Origin Generated Offset 31 Column "Cost Unit"
  101. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  102. OrgName 1023781 "Sales Price Unit" Origin Generated Offset 32 Column "Sales Price Unit"
  103. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  104. OrgName 1023783 "Reg Fee" Origin Generated Offset 33 Column "Reg Fee" Storage Default
  105. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  106. OrgName 1023785 "Stock Days" Origin Generated Offset 34 Column "Stock Days"
  107. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  108. OrgName 1023787 "Buying Order No" Origin Generated Offset 35 Column "Buying Order No"
  109. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  110. OrgName 1023789 "Buying Order Date" Origin Generated Offset 36 Column "Buying Order Date"
  111. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  112. OrgName 1023791 "Pa Number" Origin Generated Offset 37 Column "Pa Number"
  113. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  114. OrgName 1023793 "Location Code" Origin Generated Offset 38 Column "Location Code"
  115. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  116. OrgName 1023795 "Owner" Origin Generated Offset 39 Column "Owner" Storage Default
  117. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  118. OrgName 1023797 "Prev Owner" Origin Generated Offset 40 Column "Prev Owner"
  119. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  120. OrgName 1023799 "Account Purchase" Origin Generated Offset 41 Column "Account Purchase"
  121. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  122. OrgName 1023801 "Account Sales" Origin Generated Offset 42 Column "Account Sales"
  123. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  124. OrgName 1023803 "Customer Number_Cust" Origin Generated Offset 43 Column "Customer Number_Cust"
  125. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  126. OrgName 1023805 "Name_Cust" Origin Generated Offset 44 Column "Name_Cust"
  127. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  128. OrgName 1023807 "Customer Group_Cust" Origin Generated Offset 45 Column "Customer Group_Cust"
  129. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  130. OrgName 1023809 "Customer Group_vpp48" Origin Generated Offset 46 Column "Customer Group_vpp48"
  131. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  132. OrgName 1023811 "Cust Group Specify_vpp48" Origin Generated Offset 47 Column "Cust Group Specify_vpp48"
  133. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  134. OrgName 1023813 "Order Arrival Date" Origin Generated Offset 48 Column "Order Arrival Date"
  135. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  136. OrgName 1023815 "Order Confirm Date" Origin Generated Offset 49 Column "Order Confirm Date"
  137. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  138. OrgName 1023817 "Contract Date" Origin Generated Offset 50 Column "Contract Date"
  139. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  140. OrgName 1023819 "Register Number" Origin Generated Offset 51 Column "Register Number"
  141. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  142. OrgName 1023821 "Chassis Number" Origin Generated Offset 52 Column "Chassis Number"
  143. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  144. OrgName 1023823 "Owner Code" Origin Generated Offset 53 Column "Owner Code"
  145. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  146. OrgName 1023825 "First Reg Date" Origin Generated Offset 54 Column "First Reg Date"
  147. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  148. OrgName 1023827 "Latest Reg Date" Origin Generated Offset 55 Column "Latest Reg Date"
  149. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  150. OrgName 1023829 "Arrival Date" Origin Generated Offset 56 Column "Arrival Date"
  151. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  152. OrgName 1023831 "Salesman Buy" Origin Generated Offset 57 Column "Salesman Buy"
  153. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  154. OrgName 1023833 "Salesman Sale" Origin Generated Offset 58 Column "Salesman Sale"
  155. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  156. OrgName 1023835 "Model Text" Origin Generated Offset 59 Column "Model Text"
  157. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  158. OrgName 1023837 "Colour Cf" Origin Generated Offset 60 Column "Colour Cf"
  159. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  160. OrgName 1023839 "Model Line" Origin Generated Offset 61 Column "Model Line"
  161. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  162. OrgName 1023841 "Model Line_vpp5q" Origin Generated Offset 62 Column "Model Line_vpp5q"
  163. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  164. OrgName 1023843 "Mod Lin Specify_vpp5q" Origin Generated Offset 63 Column "Mod Lin Specify_vpp5q"
  165. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  166. OrgName 1023845 "Workshop Model" Origin Generated Offset 64 Column "Workshop Model"
  167. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  168. OrgName 1023849 "Motor Code" Origin Generated Offset 66 Column "Motor Code"
  169. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  170. OrgName 1023851 "Drive Code" Origin Generated Offset 67 Column "Drive Code"
  171. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  172. OrgName 1023853 "Colour Code" Origin Generated Offset 68 Column "Colour Code"
  173. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  174. OrgName 1023855 "Make" Origin Generated Offset 69 Column "Make" Storage Default
  175. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  176. OrgName 1023857 "Make Cd" Origin Generated Offset 70 Column "Make Cd" Storage Default
  177. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  178. OrgName 1023859 "Global Make Cd" Origin Generated Offset 71 Column "Global Make Cd"
  179. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  180. OrgName 1023861 "Description_Global_Make" Origin Generated Offset 72 Column "Description_Global_Make"
  181. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  182. OrgName 1023863 "Orig Inv Date" Origin Generated Offset 73 Column "Orig Inv Date"
  183. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  184. OrgName 1023865 "Latest Inv Date" Origin Generated Offset 74 Column "Latest Inv Date"
  185. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  186. OrgName 1023867 "Invoice Date" Origin Generated Offset 75 Column "Invoice Date"
  187. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  188. OrgName 1023869 "Hauptbetrieb" Origin Generated Offset 76 Column "Hauptbetrieb"
  189. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  190. OrgName 1023871 "Standort_Verkaufskostenstelle" Origin Generated Offset 77
  191. Column "Standort_Verkaufskostenstelle" Storage Default Scale 0 Size 1 Decimals 0
  192. InputScale 0 TimeArray Off ColSrcType None
  193. OrgName 1023873 "Verkäufer" Origin Generated Offset 78 Column "Verkäufer"
  194. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  195. OrgName 1023875 "Fabrikat_ori" Origin Generated Offset 79 Column "Fabrikat_ori"
  196. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  197. OrgName 1023877 "Model" Origin Generated Offset 80 Column "Model" Storage Default
  198. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  199. OrgName 1023879 "Modellbez" Origin Generated Offset 81 Column "Modellbez"
  200. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  201. OrgName 1023881 "Fahrgestellnr" Origin Generated Offset 82 Column "Fahrgestellnr"
  202. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  203. OrgName 1023883 "Fahrzeugart" Origin Generated Offset 83 Column "Fahrzeugart"
  204. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  205. OrgName 1023885 "Fahrzeugtyp" Origin Generated Offset 84 Column "Fahrzeugtyp"
  206. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  207. OrgName 1023887 "Kunde" Origin Generated Offset 85 Column "Kunde" Storage Default
  208. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  209. OrgName 1023889 "Kundenart" Origin Generated Offset 86 Column "Kundenart"
  210. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  211. OrgName 1023891 "Geschäftsart" Origin Generated Offset 87 Column "Geschäftsart"
  212. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  213. OrgName 1023893 "Farbe" Origin Generated Offset 88 Column "Farbe" Storage Default
  214. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  215. OrgName 1023895 "ECC_Status_Text" Origin Generated Offset 89 Column "ECC_Status_Text"
  216. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  217. OrgName 1023897 "FZG" Origin Generated Offset 90 Column "FZG" Storage Default
  218. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  219. OrgName 1023899 "FZG_1" Origin Generated Offset 91 Column "FZG_1" Storage Default
  220. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  221. OrgName 1023901 "FZG_Liste_1" Origin Generated Offset 92 Column "FZG_Liste_1"
  222. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  223. OrgName 1023903 "Sel Name_EK_vpp43" Origin Generated Offset 93 Column "Sel Name_EK_vpp43"
  224. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  225. OrgName 1023905 "Einkäufer" Origin Generated Offset 94 Column "Einkäufer"
  226. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  227. OrgName 1023907 "Vorbesitzer" Origin Generated Offset 95 Column "Vorbesitzer"
  228. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  229. OrgName 1023909 "FZG_Liste_2" Origin Generated Offset 96 Column "FZG_Liste_2"
  230. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  231. OrgName 1023911 "FZG_Liste_3" Origin Generated Offset 97 Column "FZG_Liste_3"
  232. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  233. OrgName 1023913 "FZG_Liste_4" Origin Generated Offset 98 Column "FZG_Liste_4"
  234. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  235. OrgName 1023915 "Unit Number_Unit_Hist" Origin Generated Offset 99 Column "Unit Number_Unit_Hist"
  236. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  237. OrgName 1023917 "Line Type" Origin Generated Offset 100 Column "Line Type"
  238. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  239. OrgName 1023919 "Line No" Origin Generated Offset 101 Column "Line No"
  240. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  241. OrgName 1023921 "Transact Date" Origin Generated Offset 102 Column "Transact Date"
  242. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  243. OrgName 1023923 "Handler" Origin Generated Offset 103 Column "Handler"
  244. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  245. OrgName 1023925 "Program" Origin Generated Offset 104 Column "Program"
  246. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  247. OrgName 1023927 "Function Code" Origin Generated Offset 105 Column "Function Code"
  248. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  249. OrgName 1023929 "Document Date" Origin Generated Offset 106 Column "Document Date"
  250. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  251. OrgName 1023931 "Document Nr" Origin Generated Offset 107 Column "Document Nr"
  252. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  253. OrgName 1023933 "Order Date" Origin Generated Offset 108 Column "Order Date"
  254. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  255. OrgName 1023935 "Order Number" Origin Generated Offset 109 Column "Order Number"
  256. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  257. OrgName 1023937 "Transaction Code" Origin Generated Offset 110 Column "Transaction Code"
  258. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  259. OrgName 1023939 "Transaction Code_vpp5a" Origin Generated Offset 111 Column "Transaction Code_vpp5a"
  260. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  261. OrgName 1023941 "Specify_vpp5a" Origin Generated Offset 112 Column "Specify_vpp5a"
  262. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  263. OrgName 1023943 "Reference" Origin Generated Offset 113 Column "Reference"
  264. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  265. OrgName 1023945 "Costs" Origin Generated Offset 114 Column "Costs" Storage Default
  266. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  267. OrgName 1023947 "Orders Grossvalue" Origin Generated Offset 115 Column "Orders Grossvalue"
  268. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  269. OrgName 1023949 "Discount" Origin Generated Offset 116 Column "Discount"
  270. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  271. OrgName 1023951 "Classification Dte" Origin Generated Offset 117 Column "Classification Dte"
  272. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  273. OrgName 1023955 "Department" Origin Generated Offset 119 Column "Department"
  274. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  275. OrgName 1023957 "Destination" Origin Generated Offset 120 Column "Destination"
  276. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  277. OrgName 1023959 "Int Voucher No" Origin Generated Offset 121 Column "Int Voucher No"
  278. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  279. OrgName 1023961 "Erlös" Origin Generated Offset 122 Column "Erlös" Storage Default
  280. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  281. OrgName 1023963 "Sonst. Erlöse" Origin Generated Offset 123 Column "Sonst. Erlöse"
  282. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  283. OrgName 1023965 "Ums. Fracht und Überf." Origin Generated Offset 124 Column "Ums. Fracht und Überf."
  284. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  285. OrgName 1023967 "Nachlass" Origin Generated Offset 125 Column "Nachlass"
  286. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  287. OrgName 1023969 "Provisionen" Origin Generated Offset 126 Column "Provisionen"
  288. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  289. OrgName 1023971 "EK Fahrzeug" Origin Generated Offset 127 Column "EK Fahrzeug"
  290. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  291. OrgName 1023973 "FZG-Kosten" Origin Generated Offset 128 Column "FZG-Kosten"
  292. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  293. OrgName 1023975 "Einsatz" Origin Generated Offset 129 Column "Einsatz"
  294. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  295. OrgName 1023977 "VK_Hilfen" Origin Generated Offset 130 Column "VK_Hilfen"
  296. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  297. OrgName 1023979 "Standtage" Origin Generated Offset 131 Column "Standtage"
  298. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  299. OrgName 1023981 "Fabrikat_manuell" Origin Generated Offset 132 Column "Fabrikat_manuell"
  300. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  301. OrgName 1023983 "Mandant" Origin Generated Offset 133 Column "Mandant"
  302. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  303. OrgName 1023985 "Department_unit_change_hist" Origin Generated Offset 134
  304. Column "Department_unit_change_hist" Storage Default Scale 0 Size 1 Decimals 0
  305. InputScale 0 TimeArray Off ColSrcType None
  306. OrgName 1023987 "Unique Ident_unit_change_hist" Origin Generated Offset 135
  307. Column "Unique Ident_unit_change_hist" Storage Default Scale 0 Size 1 Decimals 0
  308. InputScale 0 TimeArray Off ColSrcType None
  309. OrgName 1023989 "Maximum_Unique_Ident" Origin Generated Offset 136 Column "Maximum_Unique_Ident"
  310. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  311. OrgName 1023991 "Standort" Origin Generated Offset 137 Column "Standort"
  312. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  313. OrgName 1023993 "TR Code" Origin Generated Offset 138 Column "TR Code"
  314. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  315. OrgName 1023995 "Zipcode" Origin Generated Offset 139 Column "Zipcode"
  316. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  317. OrgName 1023997 "Hauptbetrieb_ID_ori" Origin Generated Offset 140 Column "Hauptbetrieb_ID_ori"
  318. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  319. OrgName 1023999 "Hauptbetrieb_Name_ori" Origin Generated Offset 141 Column "Hauptbetrieb_Name_ori"
  320. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  321. OrgName 1024001 "Standort_ID_ori" Origin Generated Offset 142 Column "Standort_ID_ori"
  322. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  323. OrgName 1024003 "Standort_Name_ori" Origin Generated Offset 143 Column "Standort_Name_ori"
  324. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  325. OrgName 1024005 "Fabrikat_GC_Marke_ori" Origin Generated Offset 144 Column "Fabrikat_GC_Marke_ori"
  326. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  327. OrgName 1024653 "Hauptbetrieb_ID" Origin Generated Offset 145 Column "Hauptbetrieb_ID"
  328. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  329. OrgName 1024009 "Hauptbetrieb_Name" Origin Generated Offset 146 Column "Hauptbetrieb_Name"
  330. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  331. OrgName 1024011 "Standort_ID" Origin Generated Offset 179 Column "Standort_ID"
  332. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  333. OrgName 1024655 "Fabrikat" Origin Generated Offset 149 Column "Fabrikat"
  334. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  335. OrgName 1751433 "Standort_ID_alt" Origin Generated Offset 147 Column "Standort_ID_alt"
  336. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  337. OrgName 1751435 "Standort_Name_alt" Origin Generated Offset 148 Column "Standort_Name_alt"
  338. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  339. OrgName 1024013 "Standort_Name" Origin Generated Offset 180 Column "Standort_Name"
  340. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  341. OrgName 1024017 "Order By_ori" Origin Generated Offset 150 Column "Order By_ori"
  342. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  343. OrgName 1024019 "Modell_Beschreibung" Origin Generated Offset 151 Column "Modell_Beschreibung"
  344. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  345. OrgName 1024021 "PLZ_1" Origin Generated Offset 152 Column "PLZ_1" Storage Default
  346. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  347. OrgName 1024023 "PLZ_2" Origin Generated Offset 153 Column "PLZ_2" Storage Default
  348. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  349. OrgName 1024657 "PLZ Code_Deb" Origin Generated Offset 156 Column "PLZ Code_Deb"
  350. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  351. OrgName 1024025 "PLZ_3" Origin Generated Offset 154 Column "PLZ_3" Storage Default
  352. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  353. OrgName 1024027 "PLZ_4" Origin Generated Offset 155 Column "PLZ_4" Storage Default
  354. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  355. OrgName 1024031 "FZG_Erlös" Origin Generated Offset 157 Column "FZG_Erlös"
  356. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  357. OrgName 1024033 "Einsatz_FZG" Origin Generated Offset 158 Column "Einsatz_FZG"
  358. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  359. OrgName 1024035 "Erlös_Prov" Origin Generated Offset 159 Column "Erlös_Prov"
  360. Storage Default Scale 0 Size 1 Decimals 0 Class Quantity InputScale 0 TimeArray Off
  361. ColSrcType None
  362. OrgName 1024659 "Einkäufer/Vorbesitzer" Origin Generated Offset 163 Column "Einkäufer/Vorbesitzer"
  363. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  364. OrgName 1024037 "Erlös_Überf." Origin Generated Offset 160 Column "Erlös_Überf."
  365. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  366. OrgName 1024039 "Erlös Sonst." Origin Generated Offset 161 Column "Erlös Sonst."
  367. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  368. OrgName 1024041 "Order By" Origin Generated Offset 162 Column "Order By"
  369. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  370. OrgName 1024661 "DB1 < 0" Origin Generated Offset 164 Column "DB1 < 0"
  371. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  372. OrgName 1024663 "Name_Einkäufer" Origin Generated Offset 165 Column "Name_Einkäufer"
  373. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  374. OrgName 1024665 "Konto" Origin Generated Offset 166 Column "Konto" Storage Default
  375. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  376. OrgName 1024667 "Buch_Text" Origin Generated Offset 167 Column "Buch_Text"
  377. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  378. OrgName 1024679 "Name_Lieferant" Origin Generated Offset 168 Column "Name_Lieferant"
  379. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  380. OrgName 1024693 "Erlös Prov" Origin Generated Offset 169 Column "Erlös Prov"
  381. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  382. OrgName 1024695 "Erlös_FZG" Origin Generated Offset 170 Column "Erlös FZG"
  383. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  384. OrgName 1024697 "Erlös Überf." Origin Generated Offset 171 Column "Erlös Überf."
  385. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  386. OrgName 1024699 "Einsatz FZG" Origin Generated Offset 172 Column "Einsatz FZG"
  387. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  388. OrgName 1024711 "Menge_1" Origin Generated Offset 173 Column "Menge_1"
  389. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  390. OrgName 1024713 "Anzahl_Datensätze" Origin Generated Offset 174 Column "Anzahl_Datensätze"
  391. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  392. OrgName 1024715 "Menge" Origin Generated Offset 175 Column "Menge" Storage Default
  393. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  394. OrgName 1024717 "DB1" Origin Generated Offset 176 Column "DB1" Storage Default
  395. Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  396. OrgName 1024719 "Summe_DB1" Origin Generated Offset 177 Column "Summe_DB1"
  397. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  398. OrgName 1266915 "FZG_Detail" Origin Generated Offset 178 Column "FZG_Detail"
  399. Storage Default Scale 0 Size 1 Decimals 0 InputScale 0 TimeArray Off ColSrcType None
  400. Dimension 669 "Zeit" DimType Date EarliestDate 19010101 LatestDate 21001231
  401. ManualPeriods False DaysInWeek 127 NewCatsLock False ExcludeAutoPartitioning False
  402. DimDefaultCategory 0
  403. Categories
  404. Root 673 "Zeit" Inclusion Generate Lastuse 20210216 Date 0 Filtered False
  405. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  406. Blanks False
  407. Drill 675 "Nach Zeit" Label "Nach Zeit" Inclusion Suppress Filtered False
  408. Suppressed True PrimaryDrill True HideValue False YearBegins 20190901 PartialWeek Split
  409. ExtraWeek None WeekBegins Sunday
  410. Levels 681 "Jahr" Blanks "( Leerstelle )" Inclusion Generate DateFunction Year
  411. Generate Need RefreshLabel False RefreshDescription False RefreshShortName False
  412. NewCatsLock False CatLabFormat "YYYY" Timerank 10 UniqueCategories True
  413. UniqueMove False Associations 683 "Invoice Date" AssociationType Type_Query
  414. AssociationRole Role_Source AssociationReferenced "Invoice Date"
  415. Associations 685 "Invoice Date" AssociationContext 675 AssociationType Type_Query
  416. AssociationRole Role_OrderBy AssociationReferenced "Invoice Date" SortOrder Default
  417. SortAs Ascending
  418. Levels 687 "Quartal" Blanks "( Leerstelle )" Inclusion Generate DateFunction Quarter
  419. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  420. NewCatsLock False CatLabFormat "Q"". Q."" YYYY" Timerank 20 UniqueCategories True
  421. UniqueMove False Associations 689 "Invoice Date" AssociationType Type_Query
  422. AssociationRole Role_Source AssociationReferenced "Invoice Date"
  423. Associations 691 "Invoice Date" AssociationContext 675 AssociationType Type_Query
  424. AssociationRole Role_OrderBy AssociationReferenced "Invoice Date" SortOrder Default
  425. SortAs Ascending
  426. Levels 693 "Monat" Blanks "( Leerstelle )" Inclusion Generate DateFunction Month
  427. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  428. NewCatsLock False CatLabFormat "MMM/YYYY" Timerank 30 UniqueCategories True
  429. UniqueMove False Associations 695 "Invoice Date" AssociationType Type_Query
  430. AssociationRole Role_Source AssociationReferenced "Invoice Date"
  431. Associations 697 "Invoice Date" AssociationContext 675 AssociationType Type_Query
  432. AssociationRole Role_OrderBy AssociationReferenced "Invoice Date" SortOrder Default
  433. SortAs Ascending
  434. Levels 699 "Tag" Blanks "( Leerstelle )" Inclusion Generate DateFunction Day
  435. Generate All RefreshLabel False RefreshDescription False RefreshShortName False
  436. NewCatsLock False CatLabFormat "DD/MM/YYYY" Timerank 50 UniqueCategories True
  437. UniqueMove False Associations 701 "Invoice Date" AssociationType Type_Query
  438. AssociationRole Role_Source AssociationReferenced "Invoice Date"
  439. Associations 703 "Invoice Date" AssociationContext 675 AssociationType Type_Query
  440. AssociationRole Role_OrderBy AssociationReferenced "Invoice Date" SortOrder Text
  441. SortAs Ascending
  442. SpecialCategory 705 "Aktueller Tag" Parent 673 Levels 0 Lastuse 20210216
  443. Rollup True TimeAggregate Single RunningPeriods 0 TargetOffset 0 TargetLevel "Tag"
  444. ContextOffset 0 DateDrill 675 Sign False
  445. SpecialCategory 707 "Gestern" Parent 673 Levels 0 Lastuse 20210216 Rollup True
  446. TimeAggregate Single RunningPeriods 0 TargetOffset -1 TargetLevel "Tag"
  447. ContextOffset 0 DateDrill 675 Sign False
  448. SpecialCategory 709 "M bisher" Parent 673 Levels 0 Lastuse 20210216 Rollup True
  449. TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Monat" TargetOffset 0
  450. TargetLevel "Tag" ContextOffset 0 DateDrill 675 Sign False
  451. SpecialCategory 711 "Voriger M bisher" Parent 673 Levels 0 Lastuse 20210216
  452. Rollup True TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Monat" TargetOffset 0
  453. TargetLevel "Tag" ContextOffset -1 ContextLevel "Monat" DateDrill 675 Sign False
  454. SpecialCategory 713 "M bisher gruppiert" Parent 673 Levels 0 Lastuse 20210216
  455. Rollup True TimeAggregate ToDate_Grp RunningPeriods 0 ToDateLevel "Monat"
  456. TargetOffset 0 TargetLevel "Tag" ContextOffset -1 ContextLevel "Monat"
  457. DateDrill 675 TransientLevelList 447501 For 713 EndList Primary 1553 Primary 1551
  458. Primary 1555 Primary 1557 Sign False
  459. SpecialCategory 1553 "M bisher gruppiert~Voriger M bisher" Parent 713 Levels 0
  460. Label "Voriger M bisher" Lastuse 20210216 Rollup False TimeAggregate ToDate
  461. RunningPeriods 0 ToDateLevel "Monat" TargetOffset 0 TargetLevel "Tag" ContextOffset -1
  462. ContextLevel "Monat" DateDrill 675 Sign False
  463. SpecialCategory 1551 "M bisher gruppiert~M bisher" Parent 713 Levels 0
  464. Label "M bisher" Lastuse 20210216 Rollup False TimeAggregate ToDate RunningPeriods 0
  465. ToDateLevel "Monat" TargetOffset 0 TargetLevel "Tag" ContextOffset 0 DateDrill 675
  466. Sign False
  467. SpecialCategory 1555 "M bisher gruppiert~ÄNDERUNG ( ""Voriger M bisher"" , ""M bisher"" )"
  468. Parent 713 Levels 0 Label "M bisher Änderung" Lastuse 20210216 Rollup False
  469. TimeAggregate None Calc change ( "M bisher gruppiert~Voriger M bisher@1553" , "M bisher gruppiert~M bisher@1551" ) Sign False
  470. SpecialCategory 1557 "M bisher gruppiert~PROZENTZUWACHS ( ""Voriger M bisher"" , ""M bisher"" )"
  471. Parent 713 Levels 0 Label "M bisher Zuwachs" Lastuse 20210216 Rollup False
  472. TimeAggregate None Calc percent-growth ( "M bisher gruppiert~Voriger M bisher@1553" , "M bisher gruppiert~M bisher@1551" ) Format "0%~2"
  473. Sign False
  474. SpecialCategory 745905 "745905" Parent 673 Levels 0 Label "M bisher VJ"
  475. Lastuse 20210216 Rollup False TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Monat"
  476. TargetOffset 0 TargetLevel "Tag" ContextOffset -1 ContextLevel "Jahr" DateDrill 675
  477. Sign False
  478. SpecialCategory 715 "Q bisher" Parent 673 Levels 0 Lastuse 20210216 Rollup True
  479. TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Quartal" TargetOffset 0
  480. TargetLevel "Tag" ContextOffset 0 DateDrill 675 TransientLevelList 447503 For 693
  481. EndList Primary 444707 Primary 1020349 Sign False
  482. SpecialCategory 444707 "Q bisher~Monat1" Parent 715 Levels 0 Label "Jan./2021"
  483. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  484. SpecialCategory 1020349 "Q bisher~Monat2" Parent 715 Levels 0 Label "Feb./2021"
  485. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  486. SpecialCategory 717 "Voriges Q bisher" Parent 673 Levels 0 Lastuse 20210216
  487. Rollup True TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Quartal"
  488. TargetOffset 0 TargetLevel "Tag" ContextOffset -1 ContextLevel "Quartal"
  489. DateDrill 675 TransientLevelList 447505 For 693 EndList Primary 444709
  490. Primary 1020353 Sign False
  491. SpecialCategory 444709 "Voriges Q bisher~Monat1" Parent 717 Levels 0 Label "Okt./2020"
  492. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  493. SpecialCategory 1020353 "Voriges Q bisher~Monat2" Parent 717 Levels 0 Label "Nov./2020"
  494. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  495. SpecialCategory 719 "Q bisher gruppiert" Parent 673 Levels 0 Lastuse 20210216
  496. Rollup True TimeAggregate ToDate_Grp RunningPeriods 0 ToDateLevel "Quartal"
  497. TargetOffset 0 TargetLevel "Tag" ContextOffset -1 ContextLevel "Quartal"
  498. DateDrill 675 TransientLevelList 447507 For 719 447509 For 693 EndList Primary 1567
  499. Primary 1563 Primary 1571 Primary 1573 Sign False
  500. SpecialCategory 1567 "Q bisher gruppiert~Voriges Q bisher" Parent 719 Levels 0
  501. Label "Voriges Q bisher" Lastuse 20210216 Rollup False TimeAggregate ToDate
  502. RunningPeriods 0 ToDateLevel "Quartal" TargetOffset 0 TargetLevel "Tag"
  503. ContextOffset -1 ContextLevel "Quartal" DateDrill 675 Primary 444711 Primary 1020357
  504. Sign False
  505. SpecialCategory 444711 "Q bisher gruppiert~Voriges Q bisher~Monat1" Parent 1567
  506. Levels 0 Label "Okt./2020" Inclusion Generate Lastuse 20210216 Rollup True
  507. TimeAggregate None Sign False
  508. SpecialCategory 1020357 "Q bisher gruppiert~Voriges Q bisher~Monat2" Parent 1567
  509. Levels 0 Label "Nov./2020" Inclusion Generate Lastuse 20210216 Rollup True
  510. TimeAggregate None Sign False
  511. SpecialCategory 1563 "Q bisher gruppiert~Q bisher" Parent 719 Levels 0
  512. Label "Q bisher" Lastuse 20210216 Rollup False TimeAggregate ToDate RunningPeriods 0
  513. ToDateLevel "Quartal" TargetOffset 0 TargetLevel "Tag" ContextOffset 0
  514. DateDrill 675 Primary 444713 Primary 1020361 Sign False
  515. SpecialCategory 444713 "Q bisher gruppiert~Q bisher~Monat1" Parent 1563
  516. Levels 0 Label "Jan./2021" Inclusion Generate Lastuse 20210216 Rollup True
  517. TimeAggregate None Sign False
  518. SpecialCategory 1020361 "Q bisher gruppiert~Q bisher~Monat2" Parent 1563
  519. Levels 0 Label "Feb./2021" Inclusion Generate Lastuse 20210216 Rollup True
  520. TimeAggregate None Sign False
  521. SpecialCategory 1571 "Q bisher gruppiert~ÄNDERUNG ( ""Voriges Q bisher"" , ""Q bisher"" )"
  522. Parent 719 Levels 0 Label "Q bisher Änderung" Lastuse 20210216 Rollup False
  523. TimeAggregate None Calc change ( "Q bisher gruppiert~Voriges Q bisher@1567" , "Q bisher gruppiert~Q bisher@1563" ) Sign False
  524. SpecialCategory 1573 "Q bisher gruppiert~PROZENTZUWACHS ( ""Voriges Q bisher"" , ""Q bisher"" )"
  525. Parent 719 Levels 0 Label "Q bisher Zuwachs" Lastuse 20210216 Rollup False
  526. TimeAggregate None Calc percent-growth ( "Q bisher gruppiert~Voriges Q bisher@1567" , "Q bisher gruppiert~Q bisher@1563" ) Format "0%~2"
  527. Sign False
  528. SpecialCategory 721 "J bisher" Parent 673 Levels 0 Lastuse 20210216 Rollup True
  529. TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Jahr" TargetOffset 0
  530. TargetLevel "Tag" ContextOffset 0 DateDrill 675 TransientLevelList 447511 For 687
  531. 447513 For 693 EndList Primary 444715 Sign False
  532. SpecialCategory 444715 "J bisher~Quartal1" Parent 721 Levels 0 Label "1. Q. 2021"
  533. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Primary 444717
  534. Primary 447515 Sign False
  535. SpecialCategory 444717 "J bisher~Quartal1~Monat1" Parent 444715 Levels 0
  536. Label "Jan./2021" Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None
  537. Sign False
  538. SpecialCategory 447515 "J bisher~Quartal1~Monat2" Parent 444715 Levels 0
  539. Label "Feb./2021" Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None
  540. Sign False
  541. SpecialCategory 723 "Voriges J bisher" Parent 673 Levels 0 Lastuse 20210216
  542. Rollup True TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Jahr" TargetOffset 0
  543. TargetLevel "Tag" ContextOffset -1 ContextLevel "Jahr" DateDrill 675 TransientLevelList 745855 For 687
  544. 745859 For 693 EndList Primary 745853 Sign False
  545. SpecialCategory 745853 "Voriges J bisher~Quartal1" Parent 723 Levels 0
  546. Label "1. Q. 2020" Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None
  547. Primary 745857 Primary 745861 Sign False
  548. SpecialCategory 745857 "Voriges J bisher~Quartal1~Monat1" Parent 745853
  549. Levels 0 Label "Jan./2020" Inclusion Generate Lastuse 20210216 Rollup True
  550. TimeAggregate None Sign False
  551. SpecialCategory 745861 "Voriges J bisher~Quartal1~Monat2" Parent 745853
  552. Levels 0 Label "Feb./2020" Inclusion Generate Lastuse 20210216 Rollup True
  553. TimeAggregate None Sign False
  554. SpecialCategory 725 "J bisher gruppiert" Parent 673 Levels 0 Lastuse 20210216
  555. Rollup True TimeAggregate ToDate_Grp RunningPeriods 0 ToDateLevel "Jahr"
  556. TargetOffset 0 TargetLevel "Tag" ContextOffset -1 ContextLevel "Jahr" DateDrill 675
  557. TransientLevelList 447539 For 725 447541 For 687 447543 For 693 EndList Primary 1585
  558. Primary 1579 Primary 1587 Primary 1589 Sign False
  559. SpecialCategory 1585 "J bisher gruppiert~Voriges J bisher" Parent 725 Levels 0
  560. Label "Voriges J bisher" Lastuse 20210216 Rollup False TimeAggregate ToDate
  561. RunningPeriods 0 ToDateLevel "Jahr" TargetOffset 0 TargetLevel "Tag" ContextOffset -1
  562. ContextLevel "Jahr" DateDrill 675 Primary 745881 Sign False
  563. SpecialCategory 745881 "J bisher gruppiert~Voriges J bisher~Quartal1" Parent 1585
  564. Levels 0 Label "1. Q. 2020" Inclusion Generate Lastuse 20210216 Rollup True
  565. TimeAggregate None Primary 745883 Primary 745885 Sign False
  566. SpecialCategory 745883 "J bisher gruppiert~Voriges J bisher~Quartal1~Monat1"
  567. Parent 745881 Levels 0 Label "Jan./2020" Inclusion Generate Lastuse 20210216
  568. Rollup True TimeAggregate None Sign False
  569. SpecialCategory 745885 "J bisher gruppiert~Voriges J bisher~Quartal1~Monat2"
  570. Parent 745881 Levels 0 Label "Feb./2020" Inclusion Generate Lastuse 20210216
  571. Rollup True TimeAggregate None Sign False
  572. SpecialCategory 1579 "J bisher gruppiert~J bisher" Parent 725 Levels 0
  573. Label "J bisher" Lastuse 20210216 Rollup False TimeAggregate ToDate RunningPeriods 0
  574. ToDateLevel "Jahr" TargetOffset 0 TargetLevel "Tag" ContextOffset 0 DateDrill 675
  575. Primary 444719 Sign False
  576. SpecialCategory 444719 "J bisher gruppiert~J bisher~Quartal1" Parent 1579
  577. Levels 0 Label "1. Q. 2021" Inclusion Generate Lastuse 20210216 Rollup True
  578. TimeAggregate None Primary 444721 Primary 447545 Sign False
  579. SpecialCategory 444721 "J bisher gruppiert~J bisher~Quartal1~Monat1" Parent 444719
  580. Levels 0 Label "Jan./2021" Inclusion Generate Lastuse 20210216 Rollup True
  581. TimeAggregate None Sign False
  582. SpecialCategory 447545 "J bisher gruppiert~J bisher~Quartal1~Monat2" Parent 444719
  583. Levels 0 Label "Feb./2021" Inclusion Generate Lastuse 20210216 Rollup True
  584. TimeAggregate None Sign False
  585. SpecialCategory 1587 "J bisher gruppiert~ÄNDERUNG ( ""Voriges J bisher"" , ""J bisher"" )"
  586. Parent 725 Levels 0 Label "J bisher Änderung" Lastuse 20210216 Rollup False
  587. TimeAggregate None Calc change ( "J bisher gruppiert~Voriges J bisher@1585" , "J bisher gruppiert~J bisher@1579" ) Sign False
  588. SpecialCategory 1589 "J bisher gruppiert~PROZENTZUWACHS ( ""Voriges J bisher"" , ""J bisher"" )"
  589. Parent 725 Levels 0 Label "J bisher Zuwachs" Lastuse 20210216 Rollup False
  590. TimeAggregate None Calc percent-growth ( "J bisher gruppiert~Voriges J bisher@1585" , "J bisher gruppiert~J bisher@1579" ) Format "0%~2"
  591. Sign False
  592. SpecialCategory 441549 "441549" Parent 673 Levels 0 Label "Aktueller Monat"
  593. Lastuse 20210216 Rollup True TimeAggregate Single RunningPeriods 0 TargetOffset 0
  594. TargetLevel "Monat" ContextOffset 0 DateDrill 675 Sign False
  595. SpecialCategory 11071 "11071" Parent 673 Levels 0 Label "Vormonat (-1)"
  596. Lastuse 20210216 Rollup True TimeAggregate Single RunningPeriods 0 TargetOffset -1
  597. TargetLevel "Monat" ContextOffset 0 DateDrill 675 Sign False
  598. SpecialCategory 11073 "11073" Parent 673 Levels 0 Label "Vormonat (-2)"
  599. Lastuse 20210216 Rollup True TimeAggregate Single RunningPeriods 0 TargetOffset -2
  600. TargetLevel "Monat" ContextOffset 0 DateDrill 675 Sign False
  601. SpecialCategory 11077 "11077" Parent 673 Levels 0 Label "Vormonat (-3)"
  602. Lastuse 20210216 Rollup True TimeAggregate Single RunningPeriods 0 TargetOffset -3
  603. TargetLevel "Monat" ContextOffset 0 DateDrill 675 Sign False
  604. SpecialCategory 11079 "11079" Parent 673 Levels 0 Label "J bisher per Vormonat (-1)"
  605. Lastuse 20210216 Rollup True TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Jahr"
  606. TargetOffset -1 TargetLevel "Monat" ContextOffset 0 DateDrill 675 TransientLevelList 447569 For 687
  607. EndList Primary 444723 Sign False
  608. SpecialCategory 444723 "11079~Quartal1" Parent 11079 Levels 0 Label "1. Q. 2021"
  609. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  610. SpecialCategory 11083 "11083" Parent 673 Levels 0 Label "J bisher per Vormonat (-2)"
  611. Lastuse 20210216 Rollup True TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Jahr"
  612. TargetOffset -2 TargetLevel "Monat" ContextOffset 0 DateDrill 675 TransientLevelList 447577 For 687
  613. EndList Primary 447575 Primary 447579 Primary 447581 Primary 1750011 Sign False
  614. SpecialCategory 447575 "11083~Quartal1" Parent 11083 Levels 0 Label "1. Q. 2020"
  615. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  616. SpecialCategory 447579 "11083~Quartal2" Parent 11083 Levels 0 Label "2. Q. 2020"
  617. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  618. SpecialCategory 447581 "11083~Quartal3" Parent 11083 Levels 0 Label "3. Q. 2020"
  619. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  620. SpecialCategory 1750011 "11083~Quartal4" Parent 11083 Levels 0 Label "4. Q. 2020"
  621. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  622. SpecialCategory 11085 "11085" Parent 673 Levels 0 Label "J bisher per Vormonat (-3)"
  623. Lastuse 20210216 Rollup True TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Jahr"
  624. TargetOffset -3 TargetLevel "Monat" ContextOffset 0 DateDrill 675 TransientLevelList 447583 For 687
  625. EndList Primary 444725 Primary 447585 Primary 1493669 Primary 1750013 Sign False
  626. SpecialCategory 444725 "11085~Quartal1" Parent 11085 Levels 0 Label "1. Q. 2020"
  627. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  628. SpecialCategory 447585 "11085~Quartal2" Parent 11085 Levels 0 Label "2. Q. 2020"
  629. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  630. SpecialCategory 1493669 "11085~Quartal3" Parent 11085 Levels 0 Label "3. Q. 2020"
  631. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  632. SpecialCategory 1750013 "11085~Quartal4" Parent 11085 Levels 0 Label "4. Q. 2020"
  633. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Sign False
  634. SpecialCategory 1493511 "1021815" Parent 673 Levels 0 Label "Vorletztes Jahr bisher"
  635. Lastuse 20210216 Rollup False TimeAggregate ToDate RunningPeriods 0 ToDateLevel "Jahr"
  636. TargetOffset 0 TargetLevel "Tag" ContextOffset -2 ContextLevel "Jahr" DateDrill 675
  637. TransientLevelList 1493515 For 687 1493519 For 693 EndList Primary 1493513
  638. Sign False
  639. SpecialCategory 1493513 "1021815~Quartal1" Parent 1493511 Levels 0 Label "1. Q. 2019"
  640. Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None Primary 1493517
  641. Primary 1493521 Sign False
  642. SpecialCategory 1493517 "1021815~Quartal1~Monat1" Parent 1493513 Levels 0
  643. Label "Jan./2019" Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None
  644. Sign False
  645. SpecialCategory 1493521 "1021815~Quartal1~Monat2" Parent 1493513 Levels 0
  646. Label "Feb./2019" Inclusion Generate Lastuse 20210216 Rollup True TimeAggregate None
  647. Sign False
  648. SpecialCategory 745945 "745945" Parent 673 Levels 0 Label "letztes Jahr"
  649. Lastuse 20210216 Rollup False TimeAggregate Single RunningPeriods 0 TargetOffset -1
  650. TargetLevel "Jahr" ContextOffset 0 DateDrill 675 Sign False
  651. SpecialCategory 1493541 "1021813" Parent 673 Levels 0 Label "Vorletztes Jahr"
  652. Lastuse 20210216 Rollup False TimeAggregate Single RunningPeriods 0 TargetOffset -2
  653. TargetLevel "Jahr" ContextOffset 0 DateDrill 675 Sign False
  654. SpecialCategory 745947 "745947" Parent 673 Levels 0 Label "letzte 13 Monate"
  655. Lastuse 20210216 Rollup False TimeAggregate Running RunningPeriods 13 TargetOffset -1
  656. TargetLevel "Monat" ContextOffset 0 DateDrill 675 Sign False
  657. SpecialCategory 1493479 "1021745" Parent 673 Levels 0 Label "12 Monate kum. rollierend"
  658. Lastuse 20210216 Rollup False TimeAggregate None Primary 1493481 Primary 1493483
  659. Primary 1493485 Primary 1493487 Primary 1493491 Primary 1493493 Primary 1493495
  660. Primary 1493497 Primary 1493499 Primary 1493501 Primary 1493503 Primary 1493505
  661. Primary 1493507 Primary 1493509 Sign False
  662. SpecialCategory 1493481 "1021749" Parent 1493479 Levels 0 Label "-13" Lastuse 20210216
  663. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -13 TargetLevel "Monat"
  664. ContextOffset 0 DateDrill 675 Sign False
  665. SpecialCategory 1493483 "1021751" Parent 1493479 Levels 0 Label "-12" Lastuse 20210216
  666. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -12 TargetLevel "Monat"
  667. ContextOffset 0 DateDrill 675 Sign False
  668. SpecialCategory 1493485 "1021753" Parent 1493479 Levels 0 Label "-11" Lastuse 20210216
  669. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -11 TargetLevel "Monat"
  670. ContextOffset 0 DateDrill 675 Sign False
  671. SpecialCategory 1493487 "1021755" Parent 1493479 Levels 0 Label "-10" Lastuse 20210216
  672. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -10 TargetLevel "Monat"
  673. ContextOffset 0 DateDrill 675 Sign False
  674. SpecialCategory 1493491 "1021757" Parent 1493479 Levels 0 Label "-9" Lastuse 20210216
  675. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -9 TargetLevel "Monat"
  676. ContextOffset 0 DateDrill 675 Sign False
  677. SpecialCategory 1493493 "1021759" Parent 1493479 Levels 0 Label "-8" Lastuse 20210216
  678. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -8 TargetLevel "Monat"
  679. ContextOffset 0 DateDrill 675 Sign False
  680. SpecialCategory 1493495 "1021761" Parent 1493479 Levels 0 Label "-7" Lastuse 20210216
  681. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -7 TargetLevel "Monat"
  682. ContextOffset 0 DateDrill 675 Sign False
  683. SpecialCategory 1493497 "1021763" Parent 1493479 Levels 0 Label "-6" Lastuse 20210216
  684. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -6 TargetLevel "Monat"
  685. ContextOffset 0 DateDrill 675 Sign False
  686. SpecialCategory 1493499 "1021765" Parent 1493479 Levels 0 Label "-5" Lastuse 20210216
  687. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -5 TargetLevel "Monat"
  688. ContextOffset -1 ContextLevel "Jahr" DateDrill 675 Sign False
  689. SpecialCategory 1493501 "1021767" Parent 1493479 Levels 0 Label "-4" Lastuse 20210216
  690. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -4 TargetLevel "Monat"
  691. ContextOffset 0 DateDrill 675 Sign False
  692. SpecialCategory 1493503 "1021769" Parent 1493479 Levels 0 Label "-3" Lastuse 20210216
  693. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -3 TargetLevel "Monat"
  694. ContextOffset 0 DateDrill 675 Sign False
  695. SpecialCategory 1493505 "1021771" Parent 1493479 Levels 0 Label "-2" Lastuse 20210216
  696. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -2 TargetLevel "Monat"
  697. ContextOffset 0 DateDrill 675 Sign False
  698. SpecialCategory 1493507 "1021773" Parent 1493479 Levels 0 Label "-1" Lastuse 20210216
  699. Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset -1 TargetLevel "Monat"
  700. ContextOffset 0 DateDrill 675 Sign False
  701. SpecialCategory 1493509 "1021775" Parent 1493479 Levels 0 Label "letzte 12 Mon. akt."
  702. Lastuse 20210216 Rollup True TimeAggregate Running RunningPeriods 12 TargetOffset 0
  703. TargetLevel "Monat" ContextOffset 0 DateDrill 675 Sign False
  704. SpecialCategory 1750067 "1750067" Parent 673 Levels 0 Label "Aktuelles Jahr"
  705. Lastuse 20210217 Rollup False TimeAggregate Single RunningPeriods 0 TargetOffset 0
  706. TargetLevel "Jahr" ContextOffset 0 DateDrill 675 Sign False
  707. MapDrills
  708. MapDrill 675
  709. ViewName 677 "Alle Kategorien" Type All ViewCustomView 0
  710. ViewName 679 "Dimension auslassen" Type Omit ViewCustomView 0
  711. Dimension 727 "AH-Gruppe" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  712. DimDefaultCategory 0
  713. Categories
  714. Root 729 "Hauptbetrieb" Inclusion Generate Lastuse 20210216 Filtered False
  715. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  716. Blanks False
  717. Drill 731 "Nach Hauptbetrieb" Inclusion Suppress Filtered False Suppressed True
  718. PrimaryDrill True HideValue False
  719. Levels 737 "Hauptbetrieb" Blanks "( Leerstelle )" DateFunction None Generate None
  720. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  721. Timerank 0 UniqueCategories False UniqueMove False Associations 739 "Hauptbetrieb_ID"
  722. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Hauptbetrieb_ID"
  723. Associations 1020673 "Hauptbetrieb_Name" AssociationType Type_Query AssociationRole Role_Label
  724. AssociationReferenced "Hauptbetrieb_Name"
  725. Associations 1020679 "Hauptbetrieb_ID" AssociationContext 731 AssociationType Type_Query
  726. AssociationRole Role_OrderBy AssociationReferenced "Hauptbetrieb_ID" SortOrder Text
  727. SortAs Ascending
  728. Levels 741 "Standort" Blanks "( Leerstelle )" DateFunction None Generate None
  729. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  730. Timerank 0 UniqueCategories False UniqueMove False Associations 743 "Standort_ID"
  731. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Standort_ID"
  732. Associations 1020675 "Standort_Name" AssociationType Type_Query AssociationRole Role_Label
  733. AssociationReferenced "Standort_Name"
  734. Associations 1020681 "Standort_ID" AssociationContext 731 AssociationType Type_Query
  735. AssociationRole Role_OrderBy AssociationReferenced "Standort_ID" SortOrder Text
  736. SortAs Ascending
  737. Levels 745 "Verkäufer" Blanks "( Leerstelle )" DateFunction None Generate None
  738. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  739. Timerank 0 UniqueCategories False UniqueMove False Associations 747 "Verkäufer"
  740. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Verkäufer"
  741. Associations 302051 "Verkäufer" AssociationContext 731 AssociationType Type_Query
  742. AssociationRole Role_OrderBy AssociationReferenced "Verkäufer" SortOrder Text
  743. SortAs Ascending
  744. Levels 749 "Fabrikat" Blanks "( Leerstelle )" DateFunction None Generate None
  745. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  746. Timerank 0 UniqueCategories False UniqueMove False Associations 751 "Fabrikat"
  747. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Fabrikat"
  748. Associations 1021303 "Fabrikat_Order_By" AssociationContext 731 AssociationType Type_Query
  749. AssociationRole Role_OrderBy AssociationReferenced "Fabrikat_Order_By"
  750. SortOrder Int16 SortAs Ascending
  751. Levels 753 "Model" Blanks "( Leerstelle )" DateFunction None Generate None
  752. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  753. Timerank 0 UniqueCategories False UniqueMove False Associations 755 "Model"
  754. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Model"
  755. Associations 2577 "Model" AssociationContext 731 AssociationType Type_Query
  756. AssociationRole Role_OrderBy AssociationReferenced "Model" SortOrder Text
  757. SortAs Ascending
  758. Levels 15571 "FZG" Blanks "( Leerstelle )" DateFunction None Generate None
  759. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  760. Timerank 0 UniqueCategories False UniqueMove False Associations 15573 "FZG"
  761. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "FZG"
  762. Associations 15575 "Unit Number" AssociationContext 731 AssociationType Type_Query
  763. AssociationRole Role_OrderBy AssociationReferenced "Unit Number" SortOrder Int16
  764. SortAs Ascending
  765. MapDrills
  766. MapDrill 731
  767. ViewName 733 "Alle Kategorien" Type All ViewCustomView 0
  768. ViewName 735 "Dimension auslassen" Type Omit ViewCustomView 0
  769. Dimension 2393 "Verkäufer" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  770. DimDefaultCategory 0
  771. Categories
  772. Root 2395 "Verkäufer" Inclusion Generate Lastuse 20210216 Filtered False
  773. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  774. Blanks False
  775. Drill 2397 "Nach Verkäufer" Inclusion Suppress Filtered False Suppressed True
  776. PrimaryDrill True HideValue False
  777. Levels 2403 "Verkäufer" Blanks "( Leerstelle )" DateFunction None Generate None
  778. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  779. Timerank 0 UniqueCategories False UniqueMove False Associations 2405 "Verkäufer"
  780. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Verkäufer"
  781. Associations 242173 "Verkäufer" AssociationContext 2397 AssociationType Type_Query
  782. AssociationRole Role_OrderBy AssociationReferenced "Verkäufer" SortOrder Text
  783. SortAs Ascending
  784. Levels 2407 "Fabrikat" Blanks "( Leerstelle )" DateFunction None Generate None
  785. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  786. Timerank 0 UniqueCategories False UniqueMove False Associations 2409 "Fabrikat"
  787. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Fabrikat"
  788. Associations 1021305 "Fabrikat_Order_By" AssociationContext 2397 AssociationType Type_Query
  789. AssociationRole Role_OrderBy AssociationReferenced "Fabrikat_Order_By"
  790. SortOrder Int16 SortAs Ascending
  791. Levels 2411 "Model" Blanks "( Leerstelle )" DateFunction None Generate None
  792. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  793. Timerank 0 UniqueCategories False UniqueMove False Associations 2413 "Model"
  794. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Model"
  795. Associations 1020367 "Model" AssociationContext 2397 AssociationType Type_Query
  796. AssociationRole Role_OrderBy AssociationReferenced "Model" SortOrder Text
  797. SortAs Ascending
  798. Levels 442445 "Modell_Beschreibung" Blanks "( Leerstelle )" DateFunction None
  799. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  800. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 442447
  801. "Modell_Beschreibung" AssociationType Type_Query AssociationRole Role_Source
  802. AssociationReferenced "Modell_Beschreibung"
  803. Associations 442453 "Modellbez" AssociationContext 2397 AssociationType Type_Query
  804. AssociationRole Role_OrderBy AssociationReferenced "Modellbez" SortOrder Text
  805. SortAs Ascending
  806. Levels 8333 "FZG" Blanks "( Leerstelle )" DateFunction None Generate None
  807. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  808. Timerank 0 UniqueCategories False UniqueMove False Associations 8335 "FZG"
  809. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "FZG"
  810. Category 1526517 "( Leerstelle )~212021" Parent 2397 Levels 2403 OrderBy Drill 2397
  811. Value "( Leerstelle )" Lastuse 20210216 SourceValue "( Leerstelle )" Filtered False
  812. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  813. Blanks True
  814. Category 1495059 "Alparslan Solak" Parent 2397 Levels 2403 OrderBy Drill 2397
  815. Value "Alparslan Solak" Lastuse 20210216 SourceValue "Alparslan Solak"
  816. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  817. IsTruncated False Blanks False
  818. Category 1501163 "AOV März" Parent 2397 Levels 2403 OrderBy Drill 2397
  819. Value "AOV März" Lastuse 20210216 SourceValue "AOV März" Filtered False
  820. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  821. Blanks False
  822. Category 1506389 "AOV Riedl" Parent 2397 Levels 2403 OrderBy Drill 2397
  823. Value "AOV Riedl" Lastuse 20210216 SourceValue "AOV Riedl" Filtered False
  824. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  825. Blanks False
  826. Category 1503063 "AOV Schroth" Parent 2397 Levels 2403 OrderBy Drill 2397
  827. Value "AOV Schroth" Lastuse 20210216 SourceValue "AOV Schroth" Filtered False
  828. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  829. Blanks False
  830. Category 1605463 "AOV Teuner" Parent 2397 Levels 2403 OrderBy Drill 2397
  831. Value "AOV Teuner" Lastuse 20210216 SourceValue "AOV Teuner" Filtered False
  832. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  833. Blanks False
  834. Category 1495689 "AOV Tiefel" Parent 2397 Levels 2403 OrderBy Drill 2397
  835. Value "AOV Tiefel" Lastuse 20210216 SourceValue "AOV Tiefel" Filtered False
  836. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  837. Blanks False
  838. Category 1506461 "AOV Zwilling" Parent 2397 Levels 2403 OrderBy Drill 2397
  839. Value "AOV Zwilling" Lastuse 20210216 SourceValue "AOV Zwilling" Filtered False
  840. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  841. Blanks False
  842. Category 1504195 "ASS" Parent 2397 Levels 2403 OrderBy Drill 2397 Value "ASS"
  843. Lastuse 20210216 SourceValue "ASS" Filtered False Suppressed False Sign False
  844. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  845. Category 1493751 "Gabriel Minolfo" Parent 2397 Levels 2403 OrderBy Drill 2397
  846. Value "Gabriel Minolfo" Lastuse 20210216 SourceValue "Gabriel Minolfo"
  847. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  848. IsTruncated False Blanks False
  849. Category 1495331 "Georg Pelz" Parent 2397 Levels 2403 OrderBy Drill 2397
  850. Value "Georg Pelz" Lastuse 20210216 SourceValue "Georg Pelz" Filtered False
  851. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  852. Blanks False
  853. Category 1499099 "Geschäftsleitung" Parent 2397 Levels 2403 OrderBy Drill 2397
  854. Value "Geschäftsleitung" Lastuse 20210216 SourceValue "Geschäftsleitung"
  855. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  856. IsTruncated False Blanks False
  857. Category 1502963 "GMAC" Parent 2397 Levels 2403 OrderBy Drill 2397 Value "GMAC"
  858. Lastuse 20210216 SourceValue "GMAC" Filtered False Suppressed False Sign False
  859. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  860. Category 1493683 "Jürgen Bäder" Parent 2397 Levels 2403 OrderBy Drill 2397
  861. Value "Jürgen Bäder" Lastuse 20210216 SourceValue "Jürgen Bäder" Filtered False
  862. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  863. Blanks False
  864. Category 1498703 "Lars Budach" Parent 2397 Levels 2403 OrderBy Drill 2397
  865. Value "Lars Budach" Lastuse 20210216 SourceValue "Lars Budach" Filtered False
  866. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  867. Blanks False
  868. Category 1494023 "Leonardo Fazio" Parent 2397 Levels 2403 OrderBy Drill 2397
  869. Value "Leonardo Fazio" Lastuse 20210216 SourceValue "Leonardo Fazio" Filtered False
  870. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  871. Blanks False
  872. Category 1503443 "Luca Reinheimer" Parent 2397 Levels 2403 OrderBy Drill 2397
  873. Value "Luca Reinheimer" Lastuse 20210216 SourceValue "Luca Reinheimer"
  874. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  875. IsTruncated False Blanks False
  876. Category 1498299 "Marc Teuner" Parent 2397 Levels 2403 OrderBy Drill 2397
  877. Value "Marc Teuner" Lastuse 20210216 SourceValue "Marc Teuner" Filtered False
  878. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  879. Blanks False
  880. Category 1510823 "Markus Hopsch" Parent 2397 Levels 2403 OrderBy Drill 2397
  881. Value "Markus Hopsch" Lastuse 20210216 SourceValue "Markus Hopsch" Filtered False
  882. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  883. Blanks False
  884. Category 1494615 "Maurice Pauly" Parent 2397 Levels 2403 OrderBy Drill 2397
  885. Value "Maurice Pauly" Lastuse 20210216 SourceValue "Maurice Pauly" Filtered False
  886. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  887. Blanks False
  888. Category 1493965 "Michael Camponeschi" Parent 2397 Levels 2403 OrderBy Drill 2397
  889. Value "Michael Camponeschi" Lastuse 20210216 SourceValue "Michael Camponeschi"
  890. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  891. IsTruncated False Blanks False
  892. Category 1493871 "Michael Pfaff" Parent 2397 Levels 2403 OrderBy Drill 2397
  893. Value "Michael Pfaff" Lastuse 20210216 SourceValue "Michael Pfaff" Filtered False
  894. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  895. Blanks False
  896. Category 1494169 "Muhamed Duranoglu" Parent 2397 Levels 2403 OrderBy Drill 2397
  897. Value "Muhamed Duranoglu" Lastuse 20210216 SourceValue "Muhamed Duranoglu"
  898. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  899. IsTruncated False Blanks False
  900. Category 1494689 "Oliver Rischer" Parent 2397 Levels 2403 OrderBy Drill 2397
  901. Value "Oliver Rischer" Lastuse 20210216 SourceValue "Oliver Rischer" Filtered False
  902. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  903. Blanks False
  904. Category 1502821 "Peter Ullmann" Parent 2397 Levels 2403 OrderBy Drill 2397
  905. Value "Peter Ullmann" Lastuse 20210216 SourceValue "Peter Ullmann" Filtered False
  906. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  907. Blanks False
  908. Category 1495551 "Salvador Salguero" Parent 2397 Levels 2403 OrderBy Drill 2397
  909. Value "Salvador Salguero" Lastuse 20210216 SourceValue "Salvador Salguero"
  910. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  911. IsTruncated False Blanks False
  912. Category 1642095 "Sarah Rößler" Parent 2397 Levels 2403 OrderBy Drill 2397
  913. Value "Sarah Rößler" Lastuse 20210216 SourceValue "Sarah Rößler" Filtered False
  914. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  915. Blanks False
  916. Category 1496297 "Tim Kleber" Parent 2397 Levels 2403 OrderBy Drill 2397
  917. Value "Tim Kleber" Lastuse 20210216 SourceValue "Tim Kleber" Filtered False
  918. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  919. Blanks False
  920. Category 1692455 "Ursula Herrgen" Parent 2397 Levels 2403 OrderBy Drill 2397
  921. Value "Ursula Herrgen" Lastuse 20210216 SourceValue "Ursula Herrgen" Filtered False
  922. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  923. Blanks False
  924. Category 1751429 "VB Gebrauchtwagen" Parent 2397 Levels 2403 OrderBy Drill 2397
  925. Value "VB Gebrauchtwagen" Lastuse 20210216 SourceValue "VB Gebrauchtwagen"
  926. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  927. IsTruncated False Blanks False
  928. Category 1493807 "Volker Horz" Parent 2397 Levels 2403 OrderBy Drill 2397
  929. Value "Volker Horz" Lastuse 20210216 SourceValue "Volker Horz" Filtered False
  930. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  931. Blanks False
  932. MapDrills
  933. MapDrill 2397
  934. ViewName 2399 "Alle Kategorien" Type All ViewCustomView 0
  935. ViewName 2401 "Dimension auslassen" Type Omit ViewCustomView 0
  936. Dimension 2423 "Fabrikat" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  937. DimDefaultCategory 0
  938. Categories
  939. Root 2425 "Fabrikat" Inclusion Generate Lastuse 20210216 Filtered False
  940. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  941. Blanks False
  942. Drill 2427 "Nach Fabrikat" Inclusion Suppress Filtered False Suppressed True
  943. PrimaryDrill True HideValue False
  944. Levels 2433 "Fabrikat" Blanks "( Leerstelle )" DateFunction None Generate None
  945. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  946. Timerank 0 UniqueCategories False UniqueMove False Associations 2435 "Fabrikat"
  947. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Fabrikat"
  948. Associations 1024721 "Fabrikat" AssociationContext 2427 AssociationType Type_Query
  949. AssociationRole Role_OrderBy AssociationReferenced "Fabrikat" SortOrder Text
  950. SortAs Descending
  951. Levels 2437 "Model" Blanks "( Leerstelle )" DateFunction None Generate None
  952. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  953. Timerank 0 UniqueCategories False UniqueMove False Associations 2439 "Model"
  954. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Model"
  955. Associations 1020365 "Model" AssociationContext 2427 AssociationType Type_Query
  956. AssociationRole Role_OrderBy AssociationReferenced "Model" SortOrder Text
  957. SortAs Ascending
  958. Levels 442449 "Modell_Beschreibung" Blanks "( Leerstelle )" DateFunction None
  959. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  960. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 442451
  961. "Modell_Beschreibung" AssociationType Type_Query AssociationRole Role_Source
  962. AssociationReferenced "Modell_Beschreibung"
  963. Associations 442455 "Modellbez" AssociationContext 2427 AssociationType Type_Query
  964. AssociationRole Role_OrderBy AssociationReferenced "Modellbez" SortOrder Text
  965. SortAs Ascending
  966. Levels 8337 "FZG" Blanks "( Leerstelle )" DateFunction None Generate None
  967. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  968. Timerank 0 UniqueCategories False UniqueMove False Associations 8339 "FZG"
  969. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "FZG"
  970. Category 1619117 "Fremdfabrikat" Parent 2427 Levels 2433 OrderBy Drill 2427
  971. Value "Fremdfabrikat" Lastuse 20210216 SourceValue "Fremdfabrikat" Filtered False
  972. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  973. Blanks False
  974. MapDrills
  975. MapDrill 2427
  976. ViewName 2429 "Alle Kategorien" Type All ViewCustomView 0
  977. ViewName 2431 "Dimension auslassen" Type Omit ViewCustomView 0
  978. Dimension 2467 "Kunde" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  979. DimDefaultCategory 0
  980. Categories
  981. Root 2469 "Kunde" Inclusion Generate Lastuse 20210216 Filtered False Suppressed False
  982. Sign False HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  983. Drill 2471 "Nach Kunde" Inclusion Suppress Filtered False Suppressed True
  984. PrimaryDrill True HideValue False
  985. Levels 2477 "Kunde" Blanks "( Leerstelle )" DateFunction None Generate None
  986. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  987. Timerank 0 UniqueCategories False UniqueMove False Associations 2479 "Kunde"
  988. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Kunde"
  989. Associations 2555 "Kunde" AssociationContext 2471 AssociationType Type_Query
  990. AssociationRole Role_OrderBy AssociationReferenced "Kunde" SortOrder Int16
  991. SortAs Ascending
  992. MapDrills
  993. MapDrill 2471
  994. ViewName 2473 "Alle Kategorien" Type All ViewCustomView 0
  995. ViewName 2475 "Dimension auslassen" Type Omit ViewCustomView 0
  996. Dimension 9617 "Kundenart" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  997. DimDefaultCategory 0
  998. Categories
  999. Root 9619 "Kundenart_neu" Inclusion Generate Lastuse 20210216 Filtered False
  1000. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  1001. Blanks False
  1002. Drill 9621 "Nach Kundenart_neu" Inclusion Suppress Filtered False Suppressed True
  1003. PrimaryDrill True HideValue False
  1004. Levels 168637 "Kundenart" Blanks "( Leerstelle )" DateFunction None Generate None
  1005. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1006. Timerank 0 UniqueCategories False UniqueMove False Associations 168639
  1007. "Kundenart" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Kundenart"
  1008. Associations 1266903 "Kundenart" AssociationContext 9621 AssociationType Type_Query
  1009. AssociationRole Role_OrderBy AssociationReferenced "Kundenart" SortOrder Int16
  1010. SortAs Ascending
  1011. MapDrills
  1012. MapDrill 9621
  1013. ViewName 9623 "Alle Kategorien" Type All ViewCustomView 0
  1014. ViewName 9625 "Dimension auslassen" Type Omit ViewCustomView 0
  1015. Dimension 2481 "Fahrzeugart" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  1016. DimDefaultCategory 0
  1017. Categories
  1018. Root 2483 "Fahrzeugart" Inclusion Generate Lastuse 20210216 Filtered False
  1019. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  1020. Blanks False
  1021. Drill 2485 "Nach Fahrzeugart" Inclusion Suppress Filtered False Suppressed True
  1022. PrimaryDrill True HideValue False
  1023. Levels 2491 "Fahrzeugart" Blanks "( Leerstelle )" DateFunction None Generate None
  1024. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1025. Timerank 0 UniqueCategories False UniqueMove False Associations 2493 "Fahrzeugart"
  1026. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Fahrzeugart"
  1027. Levels 8327 "Fahrzeugtyp" Blanks "( Leerstelle )" DateFunction None Generate None
  1028. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1029. Timerank 0 UniqueCategories False UniqueMove False Associations 8329 "Fahrzeugtyp"
  1030. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Fahrzeugtyp"
  1031. Levels 168649 "Fahrzeugtyp_1" Blanks "( Leerstelle )" DateFunction None
  1032. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1033. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 168651
  1034. "Fahrzeugtyp" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Fahrzeugtyp"
  1035. Category 448387 "Neuwagen" Parent 2485 Levels 2491 Lastuse 20210216 SourceValue "Neuwagen"
  1036. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  1037. IsTruncated False Blanks False
  1038. Category 1029465 "N - Neuwagen" Parent 448387 Levels 8327 Lastuse 20210216
  1039. SourceValue "N - Neuwagen" Filtered False Suppressed False Sign False HideValue False
  1040. IsKeyOrphanage False IsTruncated False Blanks False
  1041. Category 1271087 "N - Neuwagen~167515" Parent 1029465 Levels 168649 Lastuse 20210216
  1042. SourceValue "N - Neuwagen" Filtered False Suppressed False Sign False HideValue False
  1043. IsKeyOrphanage False IsTruncated False Blanks False
  1044. Category 1025171 "V - Vorführwagen" Parent 448387 Levels 8327 Lastuse 20210216
  1045. SourceValue "V - Vorführwagen" Filtered False Suppressed False Sign False
  1046. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1047. Category 1267235 "V - Vorführwagen~166837" Parent 1025171 Levels 168649
  1048. Lastuse 20210216 SourceValue "V - Vorführwagen" Filtered False Suppressed False
  1049. Sign False HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1050. Category 1026507 "T - Tageszulassung" Parent 448387 Levels 8327 Lastuse 20210216
  1051. SourceValue "T - Tageszulassung" Filtered False Suppressed False Sign False
  1052. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1053. Category 1268471 "T - Tageszulassung~167032" Parent 1026507 Levels 168649
  1054. Lastuse 20210216 SourceValue "T - Tageszulassung" Filtered False Suppressed False
  1055. Sign False HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1056. Category 448693 "Gebrauchtwagen" Parent 2485 Levels 2491 Lastuse 20210216
  1057. SourceValue "Gebrauchtwagen" Filtered False Suppressed False Sign False
  1058. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1059. Category 1150773 "D - GW §25A UStG" Parent 448693 Levels 8327 Lastuse 20210216
  1060. SourceValue "D - GW §25A UStG" Filtered False Suppressed False Sign False
  1061. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1062. Category 1382473 "D - GW §25A UStG~187991" Parent 1150773 Levels 168649
  1063. Lastuse 20210216 SourceValue "D - GW §25A UStG" Filtered False Suppressed False
  1064. Sign False HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1065. Category 1024757 "R - GW regelbesteuert" Parent 448693 Levels 8327 Lastuse 20210216
  1066. SourceValue "R - GW regelbesteuert" Filtered False Suppressed False Sign False
  1067. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1068. Category 1266959 "R - GW regelbesteuert~166795" Parent 1024757 Levels 168649
  1069. Lastuse 20210216 SourceValue "R - GW regelbesteuert" Filtered False Suppressed False
  1070. Sign False HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1071. MapDrills
  1072. MapDrill 2485
  1073. ViewName 2487 "Alle Kategorien" Type All ViewCustomView 0
  1074. ViewName 2489 "Dimension auslassen" Type Omit ViewCustomView 0
  1075. Dimension 16463 "FZG Detail" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  1076. DimDefaultCategory 0
  1077. Categories
  1078. Root 16465 "Fahrzeugart~3369" Inclusion Generate Lastuse 20210216 Filtered False
  1079. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  1080. Blanks False
  1081. Drill 16467 "Nach Fahrzeugart~3369" Inclusion Suppress Filtered False Suppressed True
  1082. PrimaryDrill True HideValue False
  1083. Levels 1266909 "Fabrikat" Blanks "( Leer )" DateFunction None Generate None
  1084. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1085. Timerank 0 UniqueCategories False UniqueMove False Associations 1266911
  1086. "Fabrikat" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Fabrikat"
  1087. Associations 1266913 "Fabrikat" AssociationContext 16467 AssociationType Type_Query
  1088. AssociationRole Role_OrderBy AssociationReferenced "Fabrikat" SortOrder Text
  1089. SortAs Descending
  1090. Levels 16485 "Model" Blanks "( Leerstelle )" DateFunction None Generate None
  1091. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1092. Timerank 0 UniqueCategories False UniqueMove False Associations 16487 "Model"
  1093. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Model"
  1094. Associations 1266917 "Model" AssociationContext 16467 AssociationType Type_Query
  1095. AssociationRole Role_OrderBy AssociationReferenced "Model" SortOrder Text
  1096. SortAs Ascending
  1097. Levels 441535 "FZG_Detail" Blanks "( Leerstelle )" DateFunction None Generate None
  1098. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1099. Timerank 0 UniqueCategories False UniqueMove False Associations 441537
  1100. "FZG_Detail" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "FZG_Detail"
  1101. Levels 441539 "Einkäufer/Vorbesitzer" Blanks "( Leerstelle )" DateFunction None
  1102. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1103. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 441541
  1104. "Einkäufer/Vorbesitzer" AssociationType Type_Query AssociationRole Role_Source
  1105. AssociationReferenced "Einkäufer/Vorbesitzer"
  1106. Levels 445495 "Konto" Blanks "( Leerstelle )" DateFunction None Generate None
  1107. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1108. Timerank 0 UniqueCategories False UniqueMove False Associations 445497
  1109. "Konto" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Konto"
  1110. Associations 445499 "Nr" AssociationContext 16467 AssociationType Type_Query
  1111. AssociationRole Role_OrderBy AssociationReferenced "Nr" SortOrder Int16
  1112. SortAs Ascending
  1113. Levels 445491 "Buch_Text" Blanks "( Leerstelle )" DateFunction None Generate None
  1114. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1115. Timerank 0 UniqueCategories False UniqueMove False Associations 445493
  1116. "Buch_Text" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Buch_Text"
  1117. Category 1619125 "Fremdfabrikat" Parent 16467 Levels 1266909 OrderBy Drill 16467
  1118. Value "Fremdfabrikat" Lastuse 20210216 SourceValue "Fremdfabrikat" Filtered False
  1119. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  1120. Blanks False
  1121. MapDrills
  1122. MapDrill 16467
  1123. ViewName 16469 "Alle Kategorien" Type All ViewCustomView 0
  1124. ViewName 16471 "Dimension auslassen" Type Omit ViewCustomView 0
  1125. Dimension 442371 "PLZ-Gebiete" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  1126. DimDefaultCategory 0
  1127. Categories
  1128. Root 442373 "PLZ_1" Inclusion Generate Lastuse 20210216 Filtered False
  1129. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  1130. Blanks False
  1131. Drill 442375 "Nach PLZ_1" Inclusion Suppress Filtered False Suppressed True
  1132. PrimaryDrill True HideValue False
  1133. Levels 442381 "PLZ_1_Stelle" Blanks "( Leerstelle )" DateFunction None
  1134. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1135. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 442383
  1136. "PLZ_1" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "PLZ_1"
  1137. Associations 1020677 "PLZ_1_Stelle" AssociationContext 442375 AssociationType Type_Query
  1138. AssociationRole Role_OrderBy AssociationReferenced "PLZ_1_Stelle" SortOrder Int16
  1139. SortAs Ascending
  1140. Levels 442385 "PLZ_2_Stelle" Blanks "( Leerstelle )" DateFunction None
  1141. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1142. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 442387
  1143. "PLZ_2" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "PLZ_2"
  1144. Associations 442407 "PLZ_2_Stelle" AssociationContext 442375 AssociationType Type_Query
  1145. AssociationRole Role_OrderBy AssociationReferenced "PLZ_2_Stelle" SortOrder Int16
  1146. SortAs Ascending
  1147. Levels 442389 "PLZ_3_Stelle" Blanks "( Leerstelle )" DateFunction None
  1148. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1149. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 442391
  1150. "PLZ_3" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "PLZ_3"
  1151. Associations 442409 "PLZ_3_Stelle" AssociationContext 442375 AssociationType Type_Query
  1152. AssociationRole Role_OrderBy AssociationReferenced "PLZ_3_Stelle" SortOrder Int16
  1153. SortAs Ascending
  1154. Levels 442393 "PLZ_4_Stelle" Blanks "( Leerstelle )" DateFunction None
  1155. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1156. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 442395
  1157. "PLZ_4" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "PLZ_4"
  1158. Associations 442411 "PLZ_4_Stelle" AssociationContext 442375 AssociationType Type_Query
  1159. AssociationRole Role_OrderBy AssociationReferenced "PLZ_4_Stelle" SortOrder Int16
  1160. SortAs Ascending
  1161. Levels 442397 "Zipcode" Blanks "( Leerstelle )" DateFunction None Generate None
  1162. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1163. Timerank 0 UniqueCategories False UniqueMove False Associations 442399
  1164. "PLZ Code_Deb" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "PLZ Code_Deb"
  1165. Associations 442413 "Zipcode" AssociationContext 442375 AssociationType Type_Query
  1166. AssociationRole Role_OrderBy AssociationReferenced "Zipcode" SortOrder Int16
  1167. SortAs Ascending
  1168. Levels 442401 "Kunde" Blanks "( Leerstelle )" DateFunction None Generate None
  1169. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1170. Timerank 0 UniqueCategories False UniqueMove False Associations 442403
  1171. "Kunde" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Kunde"
  1172. Associations 442415 "Name_Deb" AssociationContext 442375 AssociationType Type_Query
  1173. AssociationRole Role_OrderBy AssociationReferenced "Name_Deb" SortOrder Text
  1174. SortAs Ascending
  1175. Category 485971 "( Leerstelle )" Parent 442375 Levels 442381 OrderBy Drill 442375
  1176. Value "-999999999999999" Lastuse 20210216 SourceValue "( Leerstelle )"
  1177. Filtered False Suppressed False Sign False HideValue False IsKeyOrphanage False
  1178. IsTruncated False Blanks True
  1179. Category 627267 "I" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1180. Lastuse 20181011 SourceValue "I" Filtered False Suppressed False Sign False
  1181. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1182. Category 600821 "H" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1183. Lastuse 20181011 SourceValue "H" Filtered False Suppressed False Sign False
  1184. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1185. Category 651467 "D" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1186. Lastuse 20210216 SourceValue "D" Filtered False Suppressed False Sign False
  1187. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1188. Category 561989 "C" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1189. Lastuse 20181011 SourceValue "C" Filtered False Suppressed False Sign False
  1190. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1191. Category 651227 "B" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1192. Lastuse 20181011 SourceValue "B" Filtered False Suppressed False Sign False
  1193. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1194. Category 545573 "A" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1195. Lastuse 20210216 SourceValue "A" Filtered False Suppressed False Sign False
  1196. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1197. Category 506761 "X" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1198. Lastuse 20181011 SourceValue "X" Filtered False Suppressed False Sign False
  1199. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1200. Category 557889 "U" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1201. Lastuse 20181011 SourceValue "U" Filtered False Suppressed False Sign False
  1202. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1203. Category 501015 "L" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "-999999999999999"
  1204. Lastuse 20210216 SourceValue "L" Filtered False Suppressed False Sign False
  1205. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1206. Category 450027 "0" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "0"
  1207. Lastuse 20210216 SourceValue "0" Filtered False Suppressed False Sign False
  1208. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1209. Category 448403 "1" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "1"
  1210. Lastuse 20210216 SourceValue "1" Filtered False Suppressed False Sign False
  1211. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1212. Category 458611 "2" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "2"
  1213. Lastuse 20210216 SourceValue "2" Filtered False Suppressed False Sign False
  1214. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1215. Category 470733 "3" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "3"
  1216. Lastuse 20210216 SourceValue "3" Filtered False Suppressed False Sign False
  1217. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1218. Category 448649 "4" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "4"
  1219. Lastuse 20210216 SourceValue "4" Filtered False Suppressed False Sign False
  1220. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1221. Category 500277 "5" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "5"
  1222. Lastuse 20210216 SourceValue "5" Filtered False Suppressed False Sign False
  1223. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1224. Category 479101 "6" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "6"
  1225. Lastuse 20210216 SourceValue "6" Filtered False Suppressed False Sign False
  1226. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1227. Category 450311 "7" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "7"
  1228. Lastuse 20210216 SourceValue "7" Filtered False Suppressed False Sign False
  1229. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1230. Category 452065 "8" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "8"
  1231. Lastuse 20210216 SourceValue "8" Filtered False Suppressed False Sign False
  1232. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1233. Category 461969 "9" Parent 442375 Levels 442381 OrderBy Drill 442375 Value "9"
  1234. Lastuse 20210216 SourceValue "9" Filtered False Suppressed False Sign False
  1235. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1236. MapDrills
  1237. MapDrill 442375
  1238. ViewName 442377 "Alle Kategorien" Type All ViewCustomView 0
  1239. ViewName 442379 "Dimension auslassen" Type Omit ViewCustomView 0
  1240. Dimension 442461 "Lieferant" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  1241. DimDefaultCategory 0
  1242. Categories
  1243. Root 442463 "Name_Lieferant" Inclusion Generate Lastuse 20210216 Filtered False
  1244. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  1245. Blanks False
  1246. Drill 442465 "Nach Name_Lieferant" Inclusion Suppress Filtered False Suppressed True
  1247. PrimaryDrill True HideValue False
  1248. Levels 442471 "Name_Lieferant" Blanks "( Leerstelle )" DateFunction None
  1249. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1250. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 442473
  1251. "Name_Lieferant" AssociationType Type_Query AssociationRole Role_Source
  1252. AssociationReferenced "Name_Lieferant"
  1253. Associations 1266905 "Name_Lieferant" AssociationContext 442465 AssociationType Type_Query
  1254. AssociationRole Role_OrderBy AssociationReferenced "Name_Lieferant" SortOrder Text
  1255. SortAs Ascending
  1256. Levels 442489 "FZG_Detail" Blanks "( Leerstelle )" DateFunction None Generate None
  1257. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1258. Timerank 0 UniqueCategories False UniqueMove False Associations 442491
  1259. "FZG" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "FZG"
  1260. Associations 442493 "Standtage" AssociationContext 442465 AssociationType Type_Query
  1261. AssociationRole Role_OrderBy AssociationReferenced "Standtage" SortOrder Int16
  1262. SortAs Descending
  1263. Levels 442495 "Model" Blanks "( Leerstelle )" DateFunction None Generate None
  1264. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1265. Timerank 0 UniqueCategories False UniqueMove False Associations 442497
  1266. "Model" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Model"
  1267. Associations 1020369 "Model" AssociationContext 442465 AssociationType Type_Query
  1268. AssociationRole Role_OrderBy AssociationReferenced "Model" SortOrder Text
  1269. SortAs Ascending
  1270. MapDrills
  1271. MapDrill 442465
  1272. ViewName 442467 "Alle Kategorien" Type All ViewCustomView 0
  1273. ViewName 442469 "Dimension auslassen" Type Omit ViewCustomView 0
  1274. Dimension 442511 "DB1 kleiner/größer 0" DimType Regular NewCatsLock False
  1275. ExcludeAutoPartitioning False DimDefaultCategory 0
  1276. Categories
  1277. Root 442513 "DB1 < 0" Inclusion Generate Lastuse 20210216 Filtered False
  1278. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  1279. Blanks False
  1280. Drill 442515 "Nach DB1 < 0" Inclusion Suppress Filtered False Suppressed True
  1281. PrimaryDrill True HideValue False
  1282. Levels 442521 "DB1 < 0" Blanks "( Leerstelle )" DateFunction None Generate None
  1283. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1284. Timerank 0 UniqueCategories False UniqueMove False Associations 442523
  1285. "DB1 < 0" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "DB1 < 0"
  1286. Category 448421 "DB1 > 0" Parent 442515 Levels 442521 Lastuse 20210216
  1287. SourceValue "DB1 > 0" Filtered False Suppressed False Sign False HideValue False
  1288. IsKeyOrphanage False IsTruncated False Blanks False
  1289. Category 449001 "DB1 < 0~66" Parent 442515 Levels 442521 Lastuse 20210216
  1290. SourceValue "DB1 < 0" Current Filtered False Suppressed False Sign False
  1291. HideValue False IsKeyOrphanage False IsTruncated False Blanks False
  1292. MapDrills
  1293. MapDrill 442515
  1294. ViewName 442517 "Alle Kategorien" Type All ViewCustomView 0
  1295. ViewName 442519 "Dimension auslassen" Type Omit ViewCustomView 0
  1296. Dimension 444779 "Einkäufer" DimType Regular NewCatsLock False ExcludeAutoPartitioning False
  1297. DimDefaultCategory 0
  1298. Categories
  1299. Root 444781 "Name_Einkäufer" Inclusion Generate Lastuse 20210216 Filtered False
  1300. Suppressed False Sign False HideValue False IsKeyOrphanage False IsTruncated False
  1301. Blanks False
  1302. Drill 444783 "Nach Name_Einkäufer" Inclusion Suppress Filtered False Suppressed True
  1303. PrimaryDrill True HideValue False
  1304. Levels 444789 "Name_Einkäufer" Blanks "( Leerstelle )" DateFunction None
  1305. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1306. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 444791
  1307. "Name_Einkäufer" AssociationType Type_Query AssociationRole Role_Source
  1308. AssociationReferenced "Name_Einkäufer"
  1309. Associations 444793 "Einkäufer" AssociationContext 444783 AssociationType Type_Query
  1310. AssociationRole Role_OrderBy AssociationReferenced "Einkäufer" SortOrder Text
  1311. SortAs Ascending
  1312. Levels 444795 "Fabrikat" Blanks "( Leerstelle )" DateFunction None Generate None
  1313. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1314. Timerank 0 UniqueCategories False UniqueMove False Associations 444797
  1315. "Fabrikat" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Fabrikat"
  1316. Associations 1021307 "Fabrikat_Order_By" AssociationContext 444783 AssociationType Type_Query
  1317. AssociationRole Role_OrderBy AssociationReferenced "Fabrikat_Order_By"
  1318. SortOrder Int16 SortAs Ascending
  1319. Levels 444805 "Model" Blanks "( Leerstelle )" DateFunction None Generate None
  1320. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1321. Timerank 0 UniqueCategories False UniqueMove False Associations 444807
  1322. "Model" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Model"
  1323. Associations 1020371 "Model" AssociationContext 444783 AssociationType Type_Query
  1324. AssociationRole Role_OrderBy AssociationReferenced "Model" SortOrder Text
  1325. SortAs Ascending
  1326. Levels 444799 "Modell_Beschreibung" Blanks "( Leerstelle )" DateFunction None
  1327. Generate None RefreshLabel False RefreshDescription False RefreshShortName False
  1328. NewCatsLock False Timerank 0 UniqueCategories False UniqueMove False Associations 444801
  1329. "Modell_Beschreibung" AssociationType Type_Query AssociationRole Role_Source
  1330. AssociationReferenced "Modell_Beschreibung"
  1331. Associations 444803 "Modellbez" AssociationContext 444783 AssociationType Type_Query
  1332. AssociationRole Role_OrderBy AssociationReferenced "Modellbez" SortOrder Text
  1333. SortAs Ascending
  1334. Levels 444811 "FZG" Blanks "( Leerstelle )" DateFunction None Generate None
  1335. RefreshLabel False RefreshDescription False RefreshShortName False NewCatsLock False
  1336. Timerank 0 UniqueCategories False UniqueMove False Associations 444813
  1337. "FZG" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "FZG"
  1338. MapDrills
  1339. MapDrill 444783
  1340. ViewName 444785 "Alle Kategorien" Type All ViewCustomView 0
  1341. ViewName 444787 "Dimension auslassen" Type Omit ViewCustomView 0
  1342. Measure 242177 "Menge" Missing Zero IgnoreMissingValue False Storage Float64
  1343. OutPutScale 0 Decimals 5 ReverseSign False IsCurrency False IsFolder False
  1344. Format "#,##0~0" DrillThrough False EndList Associations 1266901 "Menge"
  1345. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Menge"
  1346. Measure 1024709 "Erlös FZG" Calc "Erlös FZG_ori@401481" + "Sonst Erlöse@1023465" + "Ums Fracht und Überf@1023453" - "Nachlass@1023457" Missing Zero
  1347. IgnoreMissingValue False Storage Float64 OutPutScale 0 Decimals 5 ReverseSign False
  1348. IsCurrency False IsFolder False Format "#,##0~0" DrillThrough False EndList
  1349. Measure 1023453 "Ums Fracht und Überf" Missing Zero Rollup Sum IgnoreMissingValue False
  1350. Storage Float64 OutPutScale 0 Decimals 8 ReverseSign False IsCurrency False
  1351. IsFolder False Format "#,##0~0" DrillThrough False EndList Associations 1023455
  1352. "Erlös Überf." AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Erlös Überf."
  1353. Measure 401485 "Einsatz FZG" Missing Zero IgnoreMissingValue False Storage Float64
  1354. OutPutScale 0 Decimals 3 ReverseSign False IsCurrency False IsFolder False
  1355. Format "#,##0~0" DrillThrough False EndList Associations 401487 "Einsatz FZG"
  1356. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Einsatz FZG"
  1357. Measure 242229 "DB 1" Calc "Erlös FZG_ori@401481" + "Sonst Erlöse@1023465" + "Ums Fracht und Überf@1023453" - "Nachlass@1023457" - "Provisionen@1023461" - "Einsatz FZG@401485" Missing Zero
  1358. IgnoreMissingValue False Storage Float64 OutPutScale 0 Decimals 3 ReverseSign False
  1359. IsCurrency False IsFolder False Format "#,##0~0" DrillThrough False EndList
  1360. Measure 242235 "DB 1 %" Calc "DB 1@242229" / "Gesamterlöse@401505" * 100 Missing Zero
  1361. Timing After_Rollup IgnoreMissingValue False Storage Default OutPutScale 2
  1362. Decimals 0 ReverseSign False IsCurrency False IsFolder False Format "0%~2"
  1363. DrillThrough False EndList
  1364. Measure 242233 "durchschn. DB 1" Calc "DB 1@242229" / "Menge@242177" Missing Zero
  1365. Timing After_Rollup IgnoreMissingValue False Storage Default OutPutScale 0
  1366. Decimals 0 ReverseSign False IsCurrency False IsFolder False Format "#,##0~0"
  1367. DrillThrough False EndList
  1368. Measure 401505 "Gesamterlöse" Calc "Erlös FZG_ori@401481" + "Sonst Erlöse@1023465" + "Ums Fracht und Überf@1023453" - "Nachlass@1023457" Missing Zero
  1369. IgnoreMissingValue False Storage Float64 OutPutScale 0 Decimals 3 ReverseSign False
  1370. IsCurrency False IsFolder False Format "#,##0~0" DrillThrough False EndList
  1371. Measure 1023457 "Nachlass" Missing Zero Rollup Sum IgnoreMissingValue False
  1372. Storage Float64 OutPutScale 0 Decimals 8 ReverseSign False IsCurrency False
  1373. IsFolder False Format "#,##0~0" DrillThrough False EndList Associations 1023459
  1374. "Nachlass" AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Nachlass"
  1375. Measure 1266907 "Nachlass %" Calc "Nachlass@1023457" / ( "Erlös FZG@1024709" + "Nachlass@1023457" ) * 100 Missing Zero
  1376. IgnoreMissingValue False Storage Float64 OutPutScale 0 Decimals 5 ReverseSign False
  1377. IsCurrency False IsFolder False Format "#,##0~2" DrillThrough False EndList
  1378. Measure 1023461 "Provisionen" Missing Zero IgnoreMissingValue False Storage Float64
  1379. OutPutScale 0 Decimals 8 ReverseSign False IsCurrency False IsFolder False
  1380. Format "#,##0~0" DrillThrough False EndList Associations 1023463 "Provisionen"
  1381. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Provisionen"
  1382. Measure 1023465 "Sonst Erlöse" Missing Zero Rollup Sum IgnoreMissingValue False
  1383. Storage Float64 OutPutScale 0 Decimals 8 ReverseSign False IsCurrency False
  1384. IsFolder False Format "#,##0~0" DrillThrough False EndList Associations 1023467
  1385. "Erlös Sonst." AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Erlös Sonst."
  1386. Measure 1023469 "FZG-Kosten" Missing Zero IgnoreMissingValue False Storage Float64
  1387. OutPutScale 0 Decimals 8 ReverseSign False IsCurrency False IsFolder False
  1388. Format "#,##0~0" DrillThrough False EndList Associations 1266897 "FZG-Kosten"
  1389. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "FZG-Kosten"
  1390. Measure 1023477 "EK Fahrzeug" Calc 0 IgnoreMissingValue False Storage Float64
  1391. OutPutScale 0 Decimals 8 ReverseSign False IsCurrency False IsFolder False
  1392. Format "0~8" DrillThrough False EndList
  1393. Measure 1023473 "Boni" Missing Zero IgnoreMissingValue False Storage Float64
  1394. OutPutScale 0 Decimals 8 ReverseSign False IsCurrency False IsFolder False
  1395. Format "#,##0~0" DrillThrough False EndList Associations 1266895 "VK_Hilfen"
  1396. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "VK_Hilfen"
  1397. Measure 1266899 "Standtage" Missing Zero Rollup Average IgnoreMissingValue False
  1398. Storage Float64 OutPutScale 0 Decimals 5 ReverseSign False IsCurrency False
  1399. IsFolder False Format "#,##0~0" WeightId 1266923 AverageCalcId 1266925
  1400. DrillThrough False EndList Associations 1266921 "Standtage" AssociationType Type_Query
  1401. AssociationRole Role_Source AssociationReferenced "Standtage"
  1402. Measure 1266919 "Erlös / Stk." Calc "Erlös FZG@1024709" / "Menge@242177" Missing Zero
  1403. IgnoreMissingValue False Storage Float64 OutPutScale 0 Decimals 5 ReverseSign False
  1404. IsCurrency False IsFolder False Format "#,##0~0" DrillThrough False EndList
  1405. Measure 441543 "Standtage_ori" Missing Zero Rollup Average IgnoreMissingValue False
  1406. Storage Float64 OutPutScale 0 Decimals 4 ReverseSign False IsCurrency False
  1407. IsFolder False Format "#,##0~0" WeightId 441547 AverageCalcId 443115 DrillThrough False
  1408. EndList Associations 441545 "Standtage" AssociationType Type_Query AssociationRole Role_Source
  1409. AssociationReferenced "Standtage"
  1410. Measure 401481 "Erlös FZG_ori" Missing Zero IgnoreMissingValue False Storage Float64
  1411. OutPutScale 0 Decimals 3 ReverseSign False IsCurrency False IsFolder False
  1412. Format "#,##0~0" DrillThrough False EndList Associations 401483 "Erlös FZG"
  1413. AssociationType Type_Query AssociationRole Role_Source AssociationReferenced "Erlös FZG"
  1414. Measure 1750061 "Ziel" Calc 0 IgnoreMissingValue False Storage Default
  1415. OutPutScale 0 Decimals 0 ReverseSign False IsCurrency False IsFolder False
  1416. DrillThrough False EndList
  1417. Signon 1021287 "GC_CARLO" UserId "gaps"
  1418. FullDb "" PromptForPassword False EncryptedPW "*1*01384231522E2F2F51602F5272596343637E4F37245A2E2D4CEC79DEF37CE99FC1A9"
  1419. "76649AF836EF3E" AutoLogon False SignonType "DataSource"
  1420. Signon 1021289 "Global1" UserId "Global1"
  1421. FullDb "" PromptForPassword False EncryptedPW "*1*013D30266F4A5661543662293529282D38685930422D7D285BD26EEB8B29849F0FEB"
  1422. "C422213E8A2A5D" AutoLogon True SignOnNamespace "GC" SignonType "Cognos"
  1423. Cube 765 "V_Verkauf" MdcFile "c:\globalcube\system\optima\cube_out\v_verkauf.mdc"
  1424. EncryptedPW "" Status OK CubeCreation On Optimize Default ConsolidatedRecords 10000000
  1425. PartitionSize 500000 PassesNumber 5 Compress False IncrementalUpdate False
  1426. ServerCube False CubeStamp 1613461545 CubeCycle 94 BlockParentTotals False
  1427. Caching False UseAlternateFileName False DeployType DeployToAvailableLocationsAutomatic
  1428. DeployLocations "c:\globalcube\cubes" EndList DeployCleanupEnabled True
  1429. DeployCleanupNumberOfCubes 2 DrillThrough False EndList DataSourceSignon False
  1430. PublishEnable True PublishStatus None PublishAllowNullSuppression True
  1431. PublishAllowMultiEdgeSuppression True PublishAllowAccessToSuppressionOptions True
  1432. DimensionView 669 "All Categories" DimensionView 727 "All Categories" DimensionView 2393
  1433. "All Categories" DimensionView 2423 "All Categories" DimensionView 2467
  1434. "All Categories" DimensionView 9617 "All Categories" DimensionView 2481
  1435. "All Categories" DimensionView 16463 "All Categories" DimensionView 442371
  1436. "All Categories" DimensionView 442461 "All Categories" DimensionView 442511
  1437. "All Categories" DimensionView 444779 "All Categories"
  1438. MeasureInclude 242177 Yes MeasureInclude 1024709 Yes MeasureInclude 1023453
  1439. Yes MeasureInclude 401485 Yes MeasureInclude 242229 Yes MeasureInclude 242235
  1440. Yes MeasureInclude 242233 Yes MeasureInclude 401505 Yes MeasureInclude 1023457
  1441. Yes MeasureInclude 1266907 Yes MeasureInclude 1023461 Yes MeasureInclude 1023465
  1442. Yes MeasureInclude 1023469 Yes MeasureInclude 1023477 Yes MeasureInclude 1023473
  1443. Yes MeasureInclude 1266899 Yes MeasureInclude 1266919 Yes MeasureInclude 441543
  1444. Yes MeasureInclude 401481 Yes MeasureInclude 1750061 Yes
  1445. AllocationAdd Measure 242177 Type Default
  1446. AllocationAdd Measure 1024709 Type Default
  1447. AllocationAdd Measure 1023453 Type Default
  1448. AllocationAdd Measure 401485 Type Default
  1449. AllocationAdd Measure 242229 Type Default
  1450. AllocationAdd Measure 242235 Type Default
  1451. AllocationAdd Measure 242233 Type Default
  1452. AllocationAdd Measure 401505 Type Default
  1453. AllocationAdd Measure 1023457 Type Default
  1454. AllocationAdd Measure 1266907 Type Default
  1455. AllocationAdd Measure 1023461 Type Default
  1456. AllocationAdd Measure 1023465 Type Default
  1457. AllocationAdd Measure 1023469 Type Default
  1458. AllocationAdd Measure 1023477 Type Default
  1459. AllocationAdd Measure 1023473 Type Default
  1460. AllocationAdd Measure 1266899 Type Default
  1461. AllocationAdd Measure 1266919 Type Default
  1462. AllocationAdd Measure 441543 Type Default
  1463. AllocationAdd Measure 401481 Type Default
  1464. AllocationAdd Measure 1750061 Type Default