GUV.ppx 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210
  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>GUV.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="C:\Gaps\Portal\System\Cube_out\">
  8. <DataPool>
  9. <CatExp ExpId="T482">
  10. <Op Code="+">
  11. <Ref RefId="1718563"/>
  12. <Ref RefId="4008895"/>
  13. </Op>
  14. </CatExp>
  15. <Dimension DimIdx="5" Code="Mandant"/>
  16. <Dimension DimIdx="0" Code="Zeit"/>
  17. <Dimension DimIdx="11" Code="KENNZAHLEN"/>
  18. <Dimension DimIdx="7" Code="GuV"/>
  19. <Dimension DimIdx="1" Code="AH-Gruppe"/>
  20. <PPDSID DimIdx="0" Code="20180101-20181231" CatId="3843755"/>
  21. <PPDSID DimIdx="0" Code="55821" CatId="55821"/>
  22. <Level LevelId="279" DimIdx="0" Code="Monat 4"/>
  23. <PPDSID DimIdx="0" Code="M bisher gruppiert" CatId="299"/>
  24. <PPDSID DimIdx="1" Code="1" CatId="11587"/>
  25. <Level LevelId="327" DimIdx="1" Code="Betrieb 3"/>
  26. <PPDSID DimIdx="1" Code="Rechtseinheit" CatId="315"/>
  27. <PPDSID DimIdx="5" Code="deop01" CatId="1718563"/>
  28. <PPDSID DimIdx="5" Code="deop03" CatId="4008895"/>
  29. <PPDSID DimIdx="7" Code="1. Umsatzerlöse" CatId="2697231"/>
  30. <PPDSID DimIdx="7" Code="2. Erhöhung oder Verminderung des Bestands an fertigen und unfertigen Erzeugnissen" CatId="2647365"/>
  31. <PPDSID DimIdx="7" Code="2734347" CatId="2734347"/>
  32. <PPDSID DimIdx="7" Code="4. Sonstige betriebliche Erträge" CatId="2646263"/>
  33. <PPDSID DimIdx="7" Code="5. Materialaufwand" CatId="2663201"/>
  34. <PPDSID DimIdx="7" Code="6. Personalaufwand" CatId="2657381"/>
  35. <PPDSID DimIdx="7" Code="7. Abschreibungen" CatId="2644907"/>
  36. <PPDSID DimIdx="7" Code="8. Sonstige betriebliche Aufwendungen" CatId="2659289"/>
  37. <PPDSID DimIdx="7" Code="9. Zinsen und ähnliche Erträge" CatId="2734349"/>
  38. <PPDSID DimIdx="7" Code="10. Zinsen und ähnliche Aufwendungen" CatId="2646705"/>
  39. <PPDSID DimIdx="7" Code="2734431" CatId="2734431"/>
  40. <PPDSID DimIdx="7" Code="12. Außerordentliche Erträge" CatId="2647121"/>
  41. <PPDSID DimIdx="7" Code="13. Außerordentliche Aufwendungen" CatId="2644597"/>
  42. <PPDSID DimIdx="7" Code="14. Steuern vom Einkommen und vom Ertrag" CatId="2647039"/>
  43. <PPDSID DimIdx="7" Code="15. sonstige Steuern" CatId="2645749"/>
  44. <PPDSID DimIdx="7" Code="2734433" CatId="2734433"/>
  45. <PPDSID DimIdx="11" Code="Ist" CatId="399"/>
  46. <PPDSID DimIdx="11" Code="Menge" CatId="2008517"/>
  47. </DataPool>
  48. <custom_subsets/>
  49. <Filter RefIds="399,399"/>
  50. </PPDSConnection>
  51. <ReportSpecification>
  52. <ReportAxis Identifier="row">
  53. <NestGroup>
  54. <NestLevel Extent="463"/>
  55. <Category RefId="2697231"/>
  56. <Category RefId="2647365"/>
  57. <Category Format="35" RefId="2734347"/>
  58. <Category RefId="2646263"/>
  59. <Category RefId="2663201"/>
  60. <Category RefId="2657381"/>
  61. <Category RefId="2644907"/>
  62. <Category RefId="2659289"/>
  63. <Category RefId="2734349"/>
  64. <Category RefId="2646705"/>
  65. <Category Format="36" RefId="2734431"/>
  66. <Category RefId="2647121"/>
  67. <Category RefId="2644597"/>
  68. <Category RefId="2647039"/>
  69. <Category RefId="2645749"/>
  70. <Category Format="37" RefId="2734433"/>
  71. </NestGroup>
  72. </ReportAxis>
  73. <ReportAxis CurPos="2" Identifier="col">
  74. <NestGroup>
  75. <NestLevel Extent="30"/>
  76. <NestLevel/>
  77. <Category RefId="3843755">
  78. <Category Format="41" RefId="1718563" Label="Opel"/>
  79. <Category Format="41" RefId="4008895" Label="Iveco"/>
  80. <Category DefaultLabel="Opel + Iveco" Format="40" RefId="T482" Label="Gesamt"/>
  81. </Category>
  82. </NestGroup>
  83. </ReportAxis>
  84. <ReportAxis CurPos="0" Identifier="layer">
  85. <NestGroup>
  86. <NestLevel/>
  87. <Category RefId="11587"/>
  88. </NestGroup>
  89. </ReportAxis>
  90. <ReportSettings>
  91. <StandardReporting>
  92. <QueryList>
  93. <AdvancedSubset Dimension="1" Key="1" Alias="AH-Gruppe">
  94. <Level RefId="327"/>
  95. <IncludeCat RefId="11587"/>
  96. <IncludeDrilPath RefId="315"/>
  97. </AdvancedSubset>
  98. <AdvancedSubset CatDrillPath="55821" Dimension="0" QualifyDrillPath="55821" Key="0" Alias="Vormonat (-1)">
  99. <Level RefId="279"/>
  100. <IncludeCat RefId="55821"/>
  101. <IncludeDrilPath RefId="299"/>
  102. </AdvancedSubset>
  103. </QueryList>
  104. </StandardReporting>
  105. <FormatList>
  106. <DefaultFormat>
  107. <Font Height="-11"/>
  108. <NumberFormat OwnerStyle="2" RefId="0" Decimals="0" Identifier="$#,##0"/>
  109. <NumberFormat OwnerStyle="2" RefId="0" Decimals="0" Identifier="Allgemein"/>
  110. <NumberFormat OwnerStyle="2" RefId="0" Decimals="0" Identifier="$#,##0"/>
  111. <NumberFormat RefId="2008517" Decimals="2" Identifier="0"/>
  112. </DefaultFormat>
  113. <Format Id="35">
  114. <FontRef RefId="8" Specifier="0"/>
  115. <FontRef RefId="8" Specifier="1"/>
  116. <PatternRef RefId="6" Specifier="0"/>
  117. <PatternRef RefId="6" Specifier="1"/>
  118. <NumFormatRef RefId="15" Specifier="0"/>
  119. </Format>
  120. <Format Id="36">
  121. <FontRef RefId="8" Specifier="0"/>
  122. <FontRef RefId="8" Specifier="1"/>
  123. <PatternRef RefId="6" Specifier="0"/>
  124. <PatternRef RefId="6" Specifier="1"/>
  125. <NumFormatRef RefId="16" Specifier="0"/>
  126. </Format>
  127. <Format Id="37">
  128. <FontRef RefId="8" Specifier="0"/>
  129. <FontRef RefId="8" Specifier="1"/>
  130. <PatternRef RefId="6" Specifier="0"/>
  131. <PatternRef RefId="6" Specifier="1"/>
  132. <NumFormatRef RefId="17" Specifier="0"/>
  133. </Format>
  134. <Format Id="40">
  135. <FontRef RefId="1" Specifier="0"/>
  136. <FontRef RefId="1" Specifier="1"/>
  137. <NumFormatRef RefId="5" Specifier="399"/>
  138. </Format>
  139. <Format Id="41">
  140. <NumFormatRef RefId="5" Specifier="399"/>
  141. </Format>
  142. <Style Shared="true" Name="Hohe automat. Ausnahmen">
  143. <FontRef RefId="7" Specifier="0"/>
  144. <FontRef RefId="7" Specifier="1"/>
  145. <PatternRef RefId="5" Specifier="0"/>
  146. <PatternRef RefId="5" Specifier="1"/>
  147. <AlignRef RefId="5" Specifier="0"/>
  148. </Style>
  149. <Style Shared="true" Name="Niedrige automat. Ausnahmen">
  150. <FontRef RefId="6" Specifier="0"/>
  151. <FontRef RefId="6" Specifier="1"/>
  152. <PatternRef RefId="4" Specifier="0"/>
  153. <PatternRef RefId="4" Specifier="1"/>
  154. <AlignRef RefId="4" Specifier="0"/>
  155. </Style>
  156. <FormatAtom Type="alignment" Id="4"/>
  157. <FormatAtom Type="alignment" Id="5"/>
  158. <FormatAtom RefId="399" Decimals="2" Type="numberformat" Id="5" Identifier="#,##0"/>
  159. <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="15" Identifier="#,##0"/>
  160. <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="17" Identifier="#,##0"/>
  161. <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="16" Identifier="#,##0"/>
  162. <FormatAtom Weight="700" Type="font" Id="6">
  163. <Color R="255"/>
  164. </FormatAtom>
  165. <FormatAtom Weight="700" Type="font" Id="7">
  166. <Color G="128"/>
  167. </FormatAtom>
  168. <FormatAtom Height="-11" Type="font" Id="1"/>
  169. <FormatAtom Height="-11" Weight="700" Type="font" Id="8"/>
  170. <FormatAtom Type="pattern" Id="4"/>
  171. <FormatAtom Type="pattern" Id="5"/>
  172. <FormatAtom Type="pattern" Id="6" Style="5">
  173. <Color G="255" R="255" Identifier="foreground"/>
  174. </FormatAtom>
  175. </FormatList>
  176. </ReportSettings>
  177. </ReportSpecification>
  178. <ChartLayout TileStyle="3" AutoFitMode="2">
  179. <CustomColor Idx="0" Value="10485760"/>
  180. <CustomColor Idx="1" Value="65535"/>
  181. <CustomColor Idx="2" Value="255"/>
  182. <CustomColor Idx="3" Value="16776960"/>
  183. <CustomColor Idx="4" Value="32512"/>
  184. <CustomColor Idx="5" Value="127"/>
  185. <CustomColor Idx="6" Value="8355584"/>
  186. <CustomColor Idx="7" Value="32767"/>
  187. <CustomColor Idx="8" Value="65280"/>
  188. <CustomColor Idx="9" Value="8323199"/>
  189. <CustomColor Idx="10" Value="32639"/>
  190. <CustomColor Idx="11" Value="16777087"/>
  191. <CustomColor Idx="12" Value="16711680"/>
  192. <CustomColor Idx="13" Value="16711935"/>
  193. <CustomColor Idx="14" Value="4243648"/>
  194. <CustomColor Idx="15" Value="12599360"/>
  195. <Crosstab/>
  196. <PageLayout>
  197. <MarginInfo L="57" R="57"/>
  198. <PageInfo PageHeight="2970" PaperSource="1" PageWidth="2100" PageTypeID="9"/>
  199. <ReportStyle UseFontSubstitution="true"/>
  200. <ReportRange Row8="8" Row9="9" AllRows="1" Row10="10" Row11="11" Row12="12" Row13="13" Row14="14" RowCount="16" Row15="15" Row0="0" Type="2" Row1="1" Row2="2" Row3="3" Row4="4" Row5="5" Row6="6" Row7="7" AllLayers="1"/>
  201. </PageLayout>
  202. </ChartLayout>
  203. <TextFrame Type="title" AppendPDFTitle="false">
  204. <Text>&lt;P&gt;&lt;Span Style="font: 12pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;GuV &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;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;&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;Span Style="font: 10pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;&amp;amp;#009;&lt;/B&gt;&lt;/Span&gt;&lt;/P&gt;&lt;P&gt;&lt;Span Style="font: 10pt Arial; font-weight: normal; color: rgb(0,0,0); charset: 0"&gt;&lt;/Span&gt;&lt;/P&gt;</Text>
  205. </TextFrame>
  206. <Deployment>
  207. <ReportStyle UseFontSubstitution="true"/>
  208. </Deployment>
  209. </PowerPlayReport>
  210. </Document>