1_3_Kostenstellenbericht NEU.ppx 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387
  1. <?xml version="1.0" encoding="windows-1252" standalone="yes"?>
  2. <Document xmlns="http://www.cognos.com">
  3. <HEAD xmlns="http://www.w3.org/TR/REC-html40">
  4. <TITLE>1_3_Kostenstellenbericht NEU.ppx</TITLE>
  5. </HEAD>
  6. <PowerPlayReport xmlns="http://www.cognos.com/powerplay/report" Product_version="7.4.3101.0" Author="PPWIN" Version="1.3">
  7. <PPDSConnection Cube="belege.mdc" Path="D:\Gaps\Portal\System\Cube_out\">
  8. <DataPool>
  9. <CatExp ExpId="T1469909">
  10. <Op Code="-">
  11. <Ref RefId="4379637"/>
  12. <Ref RefId="4394047"/>
  13. </Op>
  14. </CatExp>
  15. <CatExp ExpId="T46" StaticBase="true">
  16. <Op Code="p">
  17. <Ref RefId="11805"/>
  18. <Ref RefId="28389"/>
  19. </Op>
  20. </CatExp>
  21. <CatExp ExpId="T42" StaticBase="true">
  22. <Op Code="p">
  23. <Ref RefId="373"/>
  24. <Ref RefId="28389"/>
  25. </Op>
  26. </CatExp>
  27. <CatExp ExpId="T1141415">
  28. <Op Code="-">
  29. <Ref RefId="4331939"/>
  30. <Ref RefId="4379495"/>
  31. </Op>
  32. </CatExp>
  33. <CatExp ExpId="T1078034">
  34. <Op Code="-">
  35. <Ref RefId="4331517"/>
  36. <Ref RefId="4379211"/>
  37. </Op>
  38. </CatExp>
  39. <CatExp ExpId="T981751">
  40. <Op Code="-">
  41. <Ref RefId="4330395"/>
  42. <Ref RefId="4379079"/>
  43. </Op>
  44. </CatExp>
  45. <CatExp ExpId="T1372899">
  46. <Op Code="-">
  47. <Ref RefId="4391331"/>
  48. <Ref RefId="4377363"/>
  49. </Op>
  50. </CatExp>
  51. <CatExp ExpId="T1602803">
  52. <Op Code="-">
  53. <Ref RefId="4394047"/>
  54. <Ref RefId="4379637"/>
  55. </Op>
  56. </CatExp>
  57. <CatExp ExpId="T865157">
  58. <Op Code="-">
  59. <Ref RefId="4327809"/>
  60. <Ref RefId="4376345"/>
  61. </Op>
  62. </CatExp>
  63. <CatExp ExpId="T1206830">
  64. <Op Code="+">
  65. <Ref RefId="T1078034"/>
  66. <Ref RefId="T1141415"/>
  67. </Op>
  68. </CatExp>
  69. <CatExp ExpId="T792332">
  70. <Op Code="-">
  71. <Ref RefId="4309575"/>
  72. <Ref RefId="4368449"/>
  73. </Op>
  74. </CatExp>
  75. <Dimension DimIdx="2" Code="Konten"/>
  76. <Dimension DimIdx="0" Code="Zeit"/>
  77. <Dimension DimIdx="10" Code="KENNZAHLEN"/>
  78. <Dimension DimIdx="3" Code="Kostenstelle"/>
  79. <Dimension DimIdx="1" Code="AH-Gruppe"/>
  80. <PPDSID DimIdx="0" Code="20150101-20150131" CatId="4625403"/>
  81. <PPDSID DimIdx="0" Code="20150201-20150228" CatId="4625467"/>
  82. <PPDSID DimIdx="0" Code="20150301-20150331" CatId="4625525"/>
  83. <PPDSID DimIdx="0" Code="20150401-20150430" CatId="4625591"/>
  84. <PPDSID DimIdx="0" Code="20150501-20150531" CatId="4625653"/>
  85. <PPDSID DimIdx="0" Code="20150601-20150630" CatId="4625717"/>
  86. <PPDSID DimIdx="0" Code="20150701-20150731" CatId="4625781"/>
  87. <PPDSID DimIdx="0" Code="20150801-20150831" CatId="4625845"/>
  88. <PPDSID DimIdx="0" Code="20150901-20150930" CatId="4625909"/>
  89. <PPDSID DimIdx="0" Code="20151001-20151031" CatId="4625973"/>
  90. <PPDSID DimIdx="0" Code="20151101-20151130" CatId="4626037"/>
  91. <PPDSID DimIdx="0" Code="20151201-20151231" CatId="4626099"/>
  92. <PPDSID DimIdx="0" Code="20150101-20151231" CatId="4625399"/>
  93. <PPDSID DimIdx="0" Code="55821" CatId="55821"/>
  94. <Level LevelId="279" DimIdx="0" Code="Monat 4"/>
  95. <PPDSID DimIdx="0" Code="Q bisher" CatId="301"/>
  96. <PPDSID DimIdx="1" Code="1" CatId="11587"/>
  97. <Level LevelId="327" DimIdx="1" Code="Betrieb 3"/>
  98. <PPDSID DimIdx="1" Code="Rechtseinheit" CatId="315"/>
  99. <PPDSID DimIdx="2" Code="Neuwagen~2524" CatId="4445059"/>
  100. <PPDSID DimIdx="2" Code="Gebrauchtwagen~3195" CatId="4463283"/>
  101. <PPDSID DimIdx="2" Code="Service~3236" CatId="4465867"/>
  102. <PPDSID DimIdx="2" Code="Umsatzerlöse" CatId="28389"/>
  103. <PPDSID DimIdx="2" Code="Neuwagen~29" CatId="4309575"/>
  104. <PPDSID DimIdx="2" Code="Gebrauchtwagen~744" CatId="4327809"/>
  105. <PPDSID DimIdx="2" Code="Service" CatId="4330393"/>
  106. <PPDSID DimIdx="2" Code="Mechanik" CatId="4330395"/>
  107. <PPDSID DimIdx="2" Code="Karosserie" CatId="4331517"/>
  108. <PPDSID DimIdx="2" Code="Lack" CatId="4331939"/>
  109. <PPDSID DimIdx="2" Code="Teile~2289" CatId="4391331"/>
  110. <PPDSID DimIdx="2" Code="Tankstelle~2451" CatId="4394047"/>
  111. <PPDSID DimIdx="2" Code="4484933" CatId="4484933"/>
  112. <PPDSID DimIdx="2" Code="Einsatzwerte" CatId="24713"/>
  113. <PPDSID DimIdx="2" Code="Neuwagen~1342" CatId="4368449"/>
  114. <PPDSID DimIdx="2" Code="Gebrauchtwagen~2037" CatId="4376345"/>
  115. <PPDSID DimIdx="2" Code="Service~2195" CatId="4379077"/>
  116. <PPDSID DimIdx="2" Code="Mechanik~2196" CatId="4379079"/>
  117. <PPDSID DimIdx="2" Code="Karosserie~2210" CatId="4379211"/>
  118. <PPDSID DimIdx="2" Code="Lack~2235" CatId="4379495"/>
  119. <PPDSID DimIdx="2" Code="Teile" CatId="4377363"/>
  120. <PPDSID DimIdx="2" Code="4484935" CatId="4484935"/>
  121. <PPDSID DimIdx="2" Code="Tankstelle" CatId="4379637"/>
  122. <PPDSID DimIdx="2" Code="2029389" CatId="2029389"/>
  123. <PPDSID DimIdx="2" Code="Variable Kosten" CatId="24089"/>
  124. <PPDSID DimIdx="2" Code="Direkte Kosten" CatId="22415"/>
  125. <PPDSID DimIdx="2" Code="2227701" CatId="2227701"/>
  126. <PPDSID DimIdx="2" Code="Indirekte Kosten" CatId="22403"/>
  127. <PPDSID DimIdx="2" Code="2734471" CatId="2734471"/>
  128. <PPDSID DimIdx="2" Code="Neutrales Ergebnis" CatId="2226211"/>
  129. <PPDSID DimIdx="2" Code="2734475" CatId="2734475"/>
  130. <PPDSID DimIdx="3" Code="Kostenstelle" CatId="373"/>
  131. <PPDSID DimIdx="3" Code="( Leerstelle )" CatId="1944337"/>
  132. <PPDSID DimIdx="3" Code="9" CatId="11805"/>
  133. <PPDSID DimIdx="10" Code="KENNZAHLEN" CatId="4"/>
  134. <PPDSID DimIdx="10" Code="Ist" CatId="399"/>
  135. </DataPool>
  136. <custom_subsets/>
  137. <Filter RefIds="4,4"/>
  138. </PPDSConnection>
  139. <ReportSpecification>
  140. <ReportAxis CurPos="24" Identifier="row">
  141. <NestGroup>
  142. <NestLevel Extent="128"/>
  143. <Category RefId="4445059"/>
  144. <Category RefId="4463283"/>
  145. <Category RefId="4465867">
  146. <Blank RowExtent="12"/>
  147. </Category>
  148. <Category Format="63" RefId="28389"/>
  149. <Category Format="63" RefId="4309575"/>
  150. <Category Format="63" RefId="4327809"/>
  151. <Category Format="63" RefId="4330393"/>
  152. <Category Format="63" RefId="4330395"/>
  153. <Category Format="63" RefId="4331517"/>
  154. <Category Format="63" RefId="4331939"/>
  155. <Category Format="63" RefId="4391331"/>
  156. <Category Format="63" RefId="4394047"/>
  157. <Category DefaultLabel="Tankstelle - Tankstelle" Format="166" RefId="T1469909" Label="BE I Tankstelle"/>
  158. <Category Format="63" RefId="4484933"/>
  159. <Category Format="63" RefId="24713"/>
  160. <Category Format="63" RefId="4368449"/>
  161. <Category Format="63" RefId="4376345"/>
  162. <Category Format="63" RefId="4379077"/>
  163. <Category Format="63" RefId="4379079"/>
  164. <Category Format="63" RefId="4379211"/>
  165. <Category Format="63" RefId="4379495"/>
  166. <Category Format="63" RefId="4377363"/>
  167. <Category Format="63" RefId="4484935"/>
  168. <Category Format="63" RefId="4379637"/>
  169. <Category DefaultLabel="Neuwagen - Neuwagen" Format="159" RefId="T792332" Label="BE I Neuwagen"/>
  170. <Category DefaultLabel="Gebrauchtwagen - Gebrauchtwagen" Format="160" RefId="T865157" Label="BE I Gebrauchtwagen"/>
  171. <Category DefaultLabel="Teile - Teile" Format="165" RefId="T1372899" Label="BE I Teile"/>
  172. <Category DefaultLabel="Mechanik - Mechanik" Format="161" RefId="T981751" Label="BE I Mechanik"/>
  173. <Category DefaultLabel="1 + 2" Format="164" RefId="T1206830" Label="BE I Unfall"/>
  174. <Category DefaultLabel="Tankstelle - Tankstelle" Format="167" RefId="T1602803" Label="BE I Tankstelle"/>
  175. <Category Format="144" RefId="2029389"/>
  176. <Category Format="63" RefId="24089"/>
  177. <Category Format="63" RefId="22415"/>
  178. <Category Format="145" RefId="2227701"/>
  179. <Category Format="63" RefId="22403"/>
  180. <Category Format="143" RefId="2734471">
  181. <Blank RowExtent="14"/>
  182. </Category>
  183. <Category Format="63" RefId="2226211"/>
  184. <Category Format="142" RefId="2734475"/>
  185. </NestGroup>
  186. </ReportAxis>
  187. <ReportAxis Identifier="col">
  188. <NestGroup>
  189. <NestLevel Extent="30"/>
  190. <Category RefId="4625403"/>
  191. <Category RefId="4625467"/>
  192. <Category RefId="4625525"/>
  193. <Category RefId="4625591"/>
  194. <Category RefId="4625653"/>
  195. <Category RefId="4625717"/>
  196. <Category RefId="4625781"/>
  197. <Category RefId="4625845"/>
  198. <Category RefId="4625909"/>
  199. <Category RefId="4625973"/>
  200. <Category RefId="4626037"/>
  201. <Category RefId="4626099"/>
  202. <Category RefId="4625399"/>
  203. </NestGroup>
  204. <NestGroup>
  205. <NestLevel/>
  206. <Category Format="129" RefId="373" Label="Gesamt- geschäft" ColExtent="62"/>
  207. <Category Precedence="true" DefaultLabel="PrztVonBasis(Summe, Umsatzerlöse)" Format="149" RefId="T42" Label="%" ColExtent="1"/>
  208. <Category RefId="1944337" ColExtent="69"/>
  209. <Category Precedence="true" DefaultLabel="PrztVonBasis(9 - KST9, Umsatzerlöse)" Format="158" RefId="T46" Label="%" ColExtent="38"/>
  210. </NestGroup>
  211. </ReportAxis>
  212. <ReportAxis CurPos="0" Identifier="layer">
  213. <NestGroup>
  214. <NestLevel/>
  215. <Category Format="63" RefId="11587"/>
  216. <Category QueryKey="0"/>
  217. </NestGroup>
  218. </ReportAxis>
  219. <ReportSettings Suppression="zero-suppress-cols">
  220. <StandardReporting>
  221. <Set QueryKey="0" SetInsertAction="16" Format="63" SetIndex="1" SetDimension="2" SetLevel="0"/>
  222. <QueryList>
  223. <AdvancedSubset CatDrillPath="55821" Dimension="0" QualifyDrillPath="55821" Key="1" Alias="Vormonat">
  224. <Level RefId="279"/>
  225. <IncludeCat RefId="55821"/>
  226. <IncludeDrilPath RefId="301"/>
  227. </AdvancedSubset>
  228. <AdvancedSubset Dimension="1" Key="0" Alias="AH-Gruppe">
  229. <Level RefId="327"/>
  230. <IncludeDrilPath RefId="315"/>
  231. </AdvancedSubset>
  232. </QueryList>
  233. </StandardReporting>
  234. <FormatList>
  235. <DefaultFormat>
  236. <Font Height="-11"/>
  237. <NumberFormat RefId="0" Identifier="$#,##0"/>
  238. </DefaultFormat>
  239. <Format Id="63">
  240. <FontRef RefId="7" Specifier="0"/>
  241. <FontRef RefId="7" Specifier="1"/>
  242. </Format>
  243. <Format Id="129">
  244. <PatternRef RefId="3" Specifier="1"/>
  245. </Format>
  246. <Format Id="142">
  247. <FontRef RefId="6" Specifier="0"/>
  248. <FontRef RefId="6" Specifier="1"/>
  249. <PatternRef RefId="4" Specifier="0"/>
  250. <PatternRef RefId="4" Specifier="1"/>
  251. <NumFormatRef RefId="11" Specifier="0"/>
  252. </Format>
  253. <Format Id="143">
  254. <FontRef RefId="6" Specifier="0"/>
  255. <FontRef RefId="6" Specifier="1"/>
  256. <PatternRef RefId="4" Specifier="0"/>
  257. <PatternRef RefId="4" Specifier="1"/>
  258. <NumFormatRef RefId="12" Specifier="0"/>
  259. </Format>
  260. <Format Id="144">
  261. <FontRef RefId="6" Specifier="0"/>
  262. <FontRef RefId="6" Specifier="1"/>
  263. <PatternRef RefId="4" Specifier="0"/>
  264. <PatternRef RefId="4" Specifier="1"/>
  265. <NumFormatRef RefId="14" Specifier="0"/>
  266. </Format>
  267. <Format Id="145">
  268. <FontRef RefId="6" Specifier="0"/>
  269. <FontRef RefId="6" Specifier="1"/>
  270. <PatternRef RefId="4" Specifier="0"/>
  271. <PatternRef RefId="4" Specifier="1"/>
  272. <NumFormatRef RefId="13" Specifier="0"/>
  273. </Format>
  274. <Format Id="149">
  275. <FontRef RefId="5" Specifier="0"/>
  276. <NumFormatRef RefId="10" Specifier="0"/>
  277. <NumFormatRef RefId="9" Specifier="399"/>
  278. </Format>
  279. <Format Id="158">
  280. <FontRef RefId="5" Specifier="0"/>
  281. <NumFormatRef RefId="10" Specifier="0"/>
  282. <NumFormatRef RefId="9" Specifier="399"/>
  283. </Format>
  284. <Format Id="159">
  285. <FontRef RefId="2" Specifier="0"/>
  286. <FontRef RefId="2" Specifier="1"/>
  287. </Format>
  288. <Format Id="160">
  289. <FontRef RefId="2" Specifier="0"/>
  290. <FontRef RefId="2" Specifier="1"/>
  291. </Format>
  292. <Format Id="161">
  293. <FontRef RefId="2" Specifier="0"/>
  294. <FontRef RefId="2" Specifier="1"/>
  295. </Format>
  296. <Format Id="164">
  297. <FontRef RefId="2" Specifier="0"/>
  298. <FontRef RefId="2" Specifier="1"/>
  299. </Format>
  300. <Format Id="165">
  301. <FontRef RefId="2" Specifier="0"/>
  302. <FontRef RefId="2" Specifier="1"/>
  303. </Format>
  304. <Format Id="166">
  305. <FontRef RefId="2" Specifier="0"/>
  306. <FontRef RefId="2" Specifier="1"/>
  307. </Format>
  308. <Format Id="167">
  309. <FontRef RefId="2" Specifier="0"/>
  310. <FontRef RefId="2" Specifier="1"/>
  311. </Format>
  312. <Style Shared="true" Name="Hohe automat. Ausnahmen">
  313. <FontRef RefId="3" Specifier="0"/>
  314. <FontRef RefId="3" Specifier="1"/>
  315. <PatternRef RefId="1" Specifier="0"/>
  316. <PatternRef RefId="1" Specifier="1"/>
  317. <AlignRef RefId="1" Specifier="0"/>
  318. </Style>
  319. <Style Shared="true" Name="Niedrige automat. Ausnahmen">
  320. <FontRef RefId="4" Specifier="0"/>
  321. <FontRef RefId="4" Specifier="1"/>
  322. <PatternRef RefId="2" Specifier="0"/>
  323. <PatternRef RefId="2" Specifier="1"/>
  324. <AlignRef RefId="2" Specifier="0"/>
  325. </Style>
  326. <FormatAtom Type="alignment" Id="2"/>
  327. <FormatAtom Type="alignment" Id="1"/>
  328. <FormatAtom RefId="399" Decimals="1" Type="numberformat" Id="9" Identifier="0%"/>
  329. <FormatAtom RefId="0" Decimals="2" Type="numberformat" Id="10" Identifier="0%"/>
  330. <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="11" Identifier="#,##0"/>
  331. <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="12" Identifier="#,##0"/>
  332. <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="13" Identifier="#,##0"/>
  333. <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="14" Identifier="#,##0"/>
  334. <FormatAtom Weight="700" Type="font" Id="4">
  335. <Color R="255"/>
  336. </FormatAtom>
  337. <FormatAtom Weight="700" Type="font" Id="3">
  338. <Color G="128"/>
  339. </FormatAtom>
  340. <FormatAtom Height="-9" Type="font" Id="5"/>
  341. <FormatAtom Height="-11" Weight="700" Type="font" Id="6"/>
  342. <FormatAtom Height="-11" Type="font" Id="2"/>
  343. <FormatAtom Height="-11" Type="font" Id="7"/>
  344. <FormatAtom Type="pattern" Id="2"/>
  345. <FormatAtom Type="pattern" Id="1"/>
  346. <FormatAtom Type="pattern" Id="3" Style="4">
  347. <Color G="192" R="192" B="192" Identifier="foreground"/>
  348. </FormatAtom>
  349. <FormatAtom Type="pattern" Id="4" Style="5">
  350. <Color G="255" R="255" Identifier="foreground"/>
  351. </FormatAtom>
  352. </FormatList>
  353. </ReportSettings>
  354. </ReportSpecification>
  355. <ChartLayout TileStyle="3" AutoFitMode="2">
  356. <CustomColor Idx="0" Value="10485760"/>
  357. <CustomColor Idx="1" Value="65535"/>
  358. <CustomColor Idx="2" Value="255"/>
  359. <CustomColor Idx="3" Value="16776960"/>
  360. <CustomColor Idx="4" Value="32512"/>
  361. <CustomColor Idx="5" Value="127"/>
  362. <CustomColor Idx="6" Value="8355584"/>
  363. <CustomColor Idx="7" Value="32767"/>
  364. <CustomColor Idx="8" Value="65280"/>
  365. <CustomColor Idx="9" Value="8323199"/>
  366. <CustomColor Idx="10" Value="32639"/>
  367. <CustomColor Idx="11" Value="16777087"/>
  368. <CustomColor Idx="12" Value="16711680"/>
  369. <CustomColor Idx="13" Value="16711935"/>
  370. <CustomColor Idx="14" Value="4243648"/>
  371. <CustomColor Idx="15" Value="12599360"/>
  372. <Crosstab FirstRow="14"/>
  373. <PageLayout>
  374. <MarginInfo B="134" T="134"/>
  375. <PageInfo PageOrientation="2" PageHeight="2970" PaperSource="1" PageWidth="2100" PageTypeID="9"/>
  376. <ReportStyle UseFontSubstitution="true" AxesAllPages="true"/>
  377. <ReportRange AllRows="1" Type="2" AllLayers="1"/>
  378. </PageLayout>
  379. </ChartLayout>
  380. <TextFrame Type="title" AppendPDFTitle="false">
  381. <Text>&lt;P&gt;&lt;Span Style="font: 10pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;Controlling &lt;/B&gt;&lt;/Span&gt;&lt;Span Style="font: 10pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;&lt;Var&gt;CURRENT LAYER&lt;/Var&gt;&lt;/B&gt;&lt;/Span&gt;&lt;Span Style="font: 10pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt; &amp;amp;#009;&amp;amp;#009;&amp;amp;#009;&amp;amp;#009;&lt;/B&gt;&lt;/Span&gt;&lt;Span Style="font: 8pt Arial; font-weight: normal; color: rgb(0,0,0); charset: 0"&gt;Stand: &lt;/Span&gt;&lt;Span Style="font: 8pt Arial; font-weight: normal; color: rgb(0,0,0); charset: 0"&gt;&lt;Var&gt;CURRENT PERIOD&lt;/Var&gt;&lt;/Span&gt;&lt;/P&gt;&lt;P&gt;&lt;Span Style="font: 10pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;Finanzbericht nach Kostenstellen&amp;amp;#009;&amp;amp;#009;&amp;amp;#009;&lt;/B&gt;&lt;/Span&gt;&lt;/P&gt;</Text>
  382. </TextFrame>
  383. <Deployment>
  384. <ReportStyle UseFontSubstitution="true" AxesAllPages="true"/>
  385. </Deployment>
  386. </PowerPlayReport>
  387. </Document>