Kezdőlap Felfedezés Súgó
Regisztráció Bejelentkezés
GlobalCube
/
GAPS
3
0
Másolás 0
Fájlok Problémák 0 Beolvasztási kérések 0 Wiki
Branch: Optima/König_Berlin
Branch-ok Tag-ek
GAPS
/
Portal
/
System
/
Report
/
HBV_dere09_Servicekennzahlen.ppx

HBV_dere09_Servicekennzahlen.ppx 12 KB
Állandó hivatkozás Előzmények Nyers

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257 
  1. <?xml version="1.0" encoding="windows-1252" standalone="yes"?>
    2. 

  2. <Document xmlns="http://www.cognos.com">
    3. 

  3.   <HEAD xmlns="http://www.w3.org/TR/REC-html40">
    4. 

  4.     <TITLE>HBV_dere09_Servicekennzahlen_.ppx</TITLE>
    5. 

  5.   </HEAD>
    6. 

  6.   <PowerPlayReport xmlns="http://www.cognos.com/powerplay/report" Product_version="7.4.3101.0;7.4.2075.0;7.4.3101.0" Author="PPWIN" Version="1.3">
    7. 

  7.     <PPDSConnection Cube="aftersales_dere09.mdc" Path="\\172.17.210.95\Gaps\Portal\System\Cube_out\">
    8. 

  8.       <DataPool>
    9. 

  9.         <CatExp ExpId="T70">
    10. 

  10.           <Op Code="/">
    11. 

  11.             <Ref RefId="823"/>
    12. 

  12.             <Ref RefId="831"/>
    13. 

  13.           </Op>
    14. 

  14.         </CatExp>
    15. 

  15.         <CatExp ExpId="T76">
    16. 

  16.           <Op Code="+">
    17. 

  17.             <Ref RefId="227779"/>
    18. 

  18.             <Ref RefId="228249"/>
    19. 

  19.           </Op>
    20. 

  20.         </CatExp>
    21. 

  21.         <CatExp ExpId="T82">
    22. 

  22.           <Op Code="+">
    23. 

  23.             <Ref RefId="225487"/>
    24. 

  24.             <Ref RefId="225489"/>
    25. 

  25.           </Op>
    26. 

  26.         </CatExp>
    27. 

  27.         <CatExp ExpId="T88">
    28. 

  28.           <Op Code="+">
    29. 

  29.             <Ref RefId="227779"/>
    30. 

  30.             <Ref RefId="228249"/>
    31. 

  31.           </Op>
    32. 

  32.         </CatExp>
    33. 

  33.         <Dimension DimIdx="6" Code="Auftragsart"/>
    34. 

  34.         <Dimension DimIdx="5" Code="Umsatzart"/>
    35. 

  35.         <Dimension DimIdx="15" Code="Repair Code_GC"/>
    36. 

  36.         <Dimension DimIdx="0" Code="Zeit"/>
    37. 

  37.         <Dimension DimIdx="16" Code="KENNZAHLEN"/>
    38. 

  38.         <Dimension DimIdx="3" Code="Kostenstelle"/>
    39. 

  39.         <Dimension DimIdx="1" Code="AH-Gruppe"/>
    40. 

  40.         <PPDSID DimIdx="0" Code="225601" CatId="225601"/>
    41. 

  41.         <Level LevelId="757" DimIdx="0" Code="Monat 4"/>
    42. 

  42.         <PPDSID DimIdx="0" Code="Gestern" CatId="771"/>
    43. 

  43.         <PPDSID DimIdx="0" Code="225599" CatId="225599"/>
    44. 

  44.         <PPDSID DimIdx="0" Code="225615" CatId="225615"/>
    45. 

  45.         <PPDSID DimIdx="0" Code="Aktueller Tag" CatId="769"/>
    46. 

  46.         <PPDSID DimIdx="1" Code="1" CatId="1607"/>
    47. 

  47.         <Level LevelId="805" DimIdx="1" Code="Standort 3"/>
    48. 

  48.         <PPDSID DimIdx="1" Code="Hauptbetrieb" CatId="793"/>
    49. 

  49.         <PPDSID DimIdx="3" Code="4" CatId="31761"/>
    50. 

  50.         <PPDSID DimIdx="3" Code="41" CatId="225487"/>
    51. 

  51.         <PPDSID DimIdx="3" Code="42" CatId="225489"/>
    52. 

  52.         <PPDSID DimIdx="5" Code="extern" CatId="31765"/>
    53. 

  53.         <PPDSID DimIdx="5" Code="GWL" CatId="31823"/>
    54. 

  54.         <PPDSID DimIdx="5" Code="intern" CatId="31793"/>
    55. 

  55.         <PPDSID DimIdx="5" Code="Umsatzart" CatId="31711"/>
    56. 

  56.         <PPDSID DimIdx="6" Code="Service" CatId="31769"/>
    57. 

  57.         <PPDSID DimIdx="15" Code="M" CatId="227295"/>
    58. 

  58.         <PPDSID DimIdx="15" Code="K" CatId="227779"/>
    59. 

  59.         <PPDSID DimIdx="15" Code="L" CatId="228249"/>
    60. 

  60.         <PPDSID DimIdx="16" Code="KENNZAHLEN" CatId="4"/>
    61. 

  61.         <PPDSID DimIdx="16" Code="Umsatz Lohn" CatId="823"/>
    62. 

  62.         <PPDSID DimIdx="16" Code="verk. Stunden" CatId="831"/>
    63. 

  63.         <PPDSID DimIdx="16" Code="benutzte Zeit (Auftrag)" CatId="839"/>
    64. 

  64.         <PPDSID DimIdx="16" Code="Durchgänge (Auftrag)" CatId="62529"/>
    65. 

  65.         <PPDSID DimIdx="16" Code="Umsatz gesamt" CatId="31677"/>
    66. 

  66.       </DataPool>
    67. 

  67.       <custom_subsets/>
    68. 

  68.       <Filter RefIds="31769,4,4"/>
    69. 

  69.     </PPDSConnection>
    70. 

  70.     <ReportSpecification>
    71. 

  71.       <ReportAxis CurPos="0" Identifier="row">
    72. 

  72.         <NestGroup>
    73. 

  73.           <NestLevel/>
    74. 

  74.           <Category QueryKey="3"/>
    75. 

  75.           <Category QueryKey="2"/>
    76. 

  76.         </NestGroup>
    77. 

  77.         <NestGroup>
    78. 

  78.           <NestLevel Extent="89"/>
    79. 

  79.           <NestLevel/>
    80. 

  80.           <Category Format="15" RefId="823" ColExtent="57">
    81. 

  81.             <Category Format="50" RefId="227295" Label="Mechanik"/>
    82. 

  82.             <Category DefaultLabel="Karosserie  +  Lack" Format="49" RefId="T76" Label="Kar. +  Lack"/>
    83. 

  83.           </Category>
    84. 

  84.           <Category DefaultLabel="Umsatz Lohn  /  verk. Stunden" Format="39" RefId="T70" Label="Std. Satz" ColExtent="47">
    85. 

  85.             <Category Format="50" RefId="227295" Label="Mechanik"/>
    86. 

  86.             <Category DefaultLabel="Karosserie  +  Lack" Format="49" RefId="T88" Label="Kar. +  Lack"/>
    87. 

  87.           </Category>
    88. 

  88.           <Category Format="45" RefId="831" ColExtent="51">
    89. 

  89.             <Category Format="50" RefId="227295" Label="Mechanik"/>
    90. 

  90.             <Category DefaultLabel="Karosserie  +  Lack" Format="49" RefId="T88" Label="Kar. +  Lack"/>
    91. 

  91.           </Category>
    92. 

  92.           <Category Format="45" RefId="839" Label="gearbeitete Std." ColExtent="51">
    93. 

  93.             <Category Format="50" RefId="227295" Label="Mechanik"/>
    94. 

  94.             <Category DefaultLabel="Karosserie  +  Lack" Format="49" RefId="T88" Label="Kar. +  Lack"/>
    95. 

  95.           </Category>
    96. 

  96.           <Category Format="18" RefId="62529" Label="Durchg. (Auftr.)" ColExtent="48">
    97. 

  97.             <Category Format="50" RefId="31761" Label="Mechanik"/>
    98. 

  98.             <Category DefaultLabel="4 - Karosserie + 5 - Lack" Format="50" RefId="T82" Label="Kar. + Lack"/>
    99. 

  99.           </Category>
    100. 

  100.         </NestGroup>
    101. 

  101.       </ReportAxis>
    102. 

  102.       <ReportAxis Identifier="col">
    103. 

  103.         <NestGroup>
    104. 

  104.           <NestLevel Extent="31"/>
    105. 

  105.           <Category RefId="31765" ColExtent="68"/>
    106. 

  106.           <Category RefId="31823" ColExtent="68"/>
    107. 

  107.           <Category RefId="31793" ColExtent="68"/>
    108. 

  108.           <Category Format="46" RefId="31711" Label="Gesamt" ColExtent="73"/>
    109. 

  109.         </NestGroup>
    110. 

  110.       </ReportAxis>
    111. 

  111.       <ReportAxis CurPos="0" Identifier="layer">
    112. 

  112.         <NestGroup>
    113. 

  113.           <NestLevel/>
    114. 

  114.           <Category RefId="1607"/>
    115. 

  115.           <Category QueryKey="0"/>
    116. 

  116.         </NestGroup>
    117. 

  117.       </ReportAxis>
    118. 

  118.       <ReportSettings>
    119. 

  119.         <StandardReporting>
    120. 

  120.           <Set QueryKey="0" SetInsertAction="16" SetIndex="1" SetDimension="2" SetLevel="0"/>
    121. 

  121.           <Set QueryKey="2" SetInsertAction="16" SetIndex="10" SetDimension="0" SetLevel="2"/>
    122. 

  122.           <Set QueryKey="3" SetInsertAction="16" SetIndex="0" SetDimension="0" SetLevel="2"/>
    123. 

  123.           <QueryList>
    124. 

  124.             <AdvancedSubset CatDrillPath="225601" Dimension="0" QualifyDrillPath="225601" Key="3" Alias="Vormonat (2)">
    125. 

  125.               <Level RefId="757"/>
    126. 

  126.               <IncludeCat RefId="225601"/>
    127. 

  127.               <IncludeDrilPath RefId="771"/>
    128. 

  128.             </AdvancedSubset>
    129. 

  129.             <AdvancedSubset CatDrillPath="225599" Dimension="0" QualifyDrillPath="225599" Key="2" Alias="Vormonat (-1)">
    130. 

  130.               <Level RefId="757"/>
    131. 

  131.               <IncludeCat RefId="225599"/>
    132. 

  132.               <IncludeDrilPath RefId="771"/>
    133. 

  133.             </AdvancedSubset>
    134. 

  134.             <AdvancedSubset CatDrillPath="225615" Dimension="0" QualifyDrillPath="225615" Key="1" Alias="aktuelles Jahr">
    135. 

  135.               <Level RefId="757"/>
    136. 

  136.               <IncludeCat RefId="225615"/>
    137. 

  137.               <IncludeDrilPath RefId="769"/>
    138. 

  138.             </AdvancedSubset>
    139. 

  139.             <AdvancedSubset Dimension="1" Key="0" Alias="AH Gruppe">
    140. 

  140.               <Level RefId="805"/>
    141. 

  141.               <IncludeCat RefId="1607"/>
    142. 

  142.               <IncludeDrilPath RefId="793"/>
    143. 

  143.             </AdvancedSubset>
    144. 

  144.           </QueryList>
    145. 

  145.         </StandardReporting>
    146. 

  146.         <FormatList>
    147. 

  147.           <DefaultFormat>
    148. 

  148.             <Font Height="-11"/>
    149. 

  149.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    150. 

  150.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    151. 

  151.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    152. 

  152.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    153. 

  153.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    154. 

  154.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    155. 

  155.             <NumberFormat OwnerStyle="2" RefId="0" Decimals="0" Identifier="Allgemein"/>
    156. 

  156.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    157. 

  157.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    158. 

  158.             <NumberFormat RefId="0" Identifier="#,##0"/>
    159. 

  159.             <NumberFormat RefId="0" Identifier="#,##0"/>
    160. 

  160.             <NumberFormat RefId="0" Identifier="#,##0"/>
    161. 

  161.             <NumberFormat Decimals="1" RefId="0" Identifier="#,##0"/>
    162. 

  162.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    163. 

  163.             <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
    164. 

  164.           </DefaultFormat>
    165. 

  165.           <Format Id="15">
    166. 

  166.             <NumFormatRef RefId="16" Specifier="31677"/>
    167. 

  167.           </Format>
    168. 

  168.           <Format Id="18">
    169. 

  169.             <NumFormatRef RefId="16" Specifier="31677"/>
    170. 

  170.           </Format>
    171. 

  171.           <Format Id="39">
    172. 

  172.             <FontRef RefId="1" Specifier="0"/>
    173. 

  173.             <FontRef RefId="1" Specifier="1"/>
    174. 

  174.             <NumFormatRef RefId="39" Specifier="0"/>
    175. 

  175.           </Format>
    176. 

  176.           <Format Id="45">
    177. 

  177.             <NumFormatRef RefId="40" Specifier="31677"/>
    178. 

  178.           </Format>
    179. 

  179.           <Format Id="46">
    180. 

  180.             <FontRef RefId="8" Specifier="0"/>
    181. 

  181.             <FontRef RefId="8" Specifier="1"/>
    182. 

  182.           </Format>
    183. 

  183.           <Format Id="49">
    184. 

  184.             <FontRef RefId="1" Specifier="0"/>
    185. 

  185.             <FontRef RefId="1" Specifier="1"/>
    186. 

  186.             <NumFormatRef RefId="41" Specifier="0"/>
    187. 

  187.             <NumFormatRef RefId="40" Specifier="31677"/>
    188. 

  188.           </Format>
    189. 

  189.           <Format Id="50">
    190. 

  190.             <NumFormatRef RefId="40" Specifier="31677"/>
    191. 

  191.           </Format>
    192. 

  192.           <Style Shared="true" Name="Hohe automat. Ausnahmen">
    193. 

  193.             <FontRef RefId="7" Specifier="0"/>
    194. 

  194.             <FontRef RefId="7" Specifier="1"/>
    195. 

  195.             <PatternRef RefId="5" Specifier="0"/>
    196. 

  196.             <PatternRef RefId="5" Specifier="1"/>
    197. 

  197.             <AlignRef RefId="5" Specifier="0"/>
    198. 

  198.           </Style>
    199. 

  199.           <Style Shared="true" Name="Niedrige automat. Ausnahmen">
    200. 

  200.             <FontRef RefId="6" Specifier="0"/>
    201. 

  201.             <FontRef RefId="6" Specifier="1"/>
    202. 

  202.             <PatternRef RefId="4" Specifier="0"/>
    203. 

  203.             <PatternRef RefId="4" Specifier="1"/>
    204. 

  204.             <AlignRef RefId="4" Specifier="0"/>
    205. 

  205.           </Style>
    206. 

  206.           <FormatAtom Type="alignment" Id="4"/>
    207. 

  207.           <FormatAtom Type="alignment" Id="5"/>
    208. 

  208.           <FormatAtom OwnerStyle="4294967293" RefId="31677" Decimals="0" Type="numberformat" Id="16" Identifier="#,##0"/>
    209. 

  209.           <FormatAtom Weight="700" Type="font" Id="6">
    210. 

  210.             <Color R="255"/>
    211. 

  211.           </FormatAtom>
    212. 

  212.           <FormatAtom Weight="700" Type="font" Id="7">
    213. 

  213.             <Color G="128"/>
    214. 

  214.           </FormatAtom>
    215. 

  215.           <FormatAtom Height="-11" Weight="700" Type="font" Id="8"/>
    216. 

  216.           <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="39" Identifier="#,##0"/>
    217. 

  217.           <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="41" Identifier="#,##0"/>
    218. 

  218.           <FormatAtom Height="-11" Type="font" Id="1"/>
    219. 

  219.           <FormatAtom RefId="31677" Decimals="0" Type="numberformat" Id="40" Identifier="#,##0"/>
    220. 

  220.           <FormatAtom Type="pattern" Id="4"/>
    221. 

  221.           <FormatAtom Type="pattern" Id="5"/>
    222. 

  222.         </FormatList>
    223. 

  223.       </ReportSettings>
    224. 

  224.     </ReportSpecification>
    225. 

  225.     <ChartLayout TileStyle="3" AutoFitMode="2">
    226. 

  226.       <CustomColor Idx="0" Value="10485760"/>
    227. 

  227.       <CustomColor Idx="1" Value="65535"/>
    228. 

  228.       <CustomColor Idx="2" Value="255"/>
    229. 

  229.       <CustomColor Idx="3" Value="16776960"/>
    230. 

  230.       <CustomColor Idx="4" Value="32512"/>
    231. 

  231.       <CustomColor Idx="5" Value="127"/>
    232. 

  232.       <CustomColor Idx="6" Value="8355584"/>
    233. 

  233.       <CustomColor Idx="7" Value="32767"/>
    234. 

  234.       <CustomColor Idx="8" Value="65280"/>
    235. 

  235.       <CustomColor Idx="9" Value="8323199"/>
    236. 

  236.       <CustomColor Idx="10" Value="32639"/>
    237. 

  237.       <CustomColor Idx="11" Value="16777087"/>
    238. 

  238.       <CustomColor Idx="12" Value="16711680"/>
    239. 

  239.       <CustomColor Idx="13" Value="16711935"/>
    240. 

  240.       <CustomColor Idx="14" Value="4243648"/>
    241. 

  241.       <CustomColor Idx="15" Value="12599360"/>
    242. 

  242.       <Crosstab/>
    243. 

  243.       <PageLayout>
    244. 

  244.         <MarginInfo B="134" T="134"/>
    245. 

  245.         <PageInfo PageHeight="2970" PaperSource="1" PageWidth="2100" PageTypeID="9"/>
    246. 

  246.         <ReportStyle UseFontSubstitution="true" AxesAllPages="true"/>
    247. 

  247.         <ReportRange AllRows="1" Type="2" AllLayers="1"/>
    248. 

  248.       </PageLayout>
    249. 

  249.     </ChartLayout>
    250. 

  250.     <TextFrame Type="title" AppendPDFTitle="false">
    251. 

  251.       <Text>&lt;P&gt;&lt;Span Style="font: 12pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;Service Umsätze nach SC-Beratern per &lt;/B&gt;&lt;/Span&gt;&lt;Span Style="font: 12pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;&lt;Var&gt;MDC FILE DATE(dd.MM.yyyy)&lt;/Var&gt;&lt;/B&gt;&lt;/Span&gt;&lt;/P&gt;&lt;P&gt;&lt;Span Style="font: 8pt Arial; font-weight: normal; color: rgb(0,0,0); charset: 0"&gt;&lt;Var&gt;DIMENSION LINE&lt;/Var&gt;&lt;/Span&gt;&lt;/P&gt;</Text>
    252. 

  252.     </TextFrame>
    253. 

  253.     <Deployment>
    254. 

  254.       <ReportStyle UseFontSubstitution="true" AxesAllPages="true"/>
    255. 

  255.     </Deployment>
    256. 

  256.   </PowerPlayReport>
    257. 

  257. </Document>
    258.