GlobalCube
/
GAPS


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264
							<?xml version="1.0" encoding="windows-1252" standalone="yes"?>
<Document xmlns="http://www.cognos.com">
  <HEAD xmlns="http://www.w3.org/TR/REC-html40">
    <TITLE>TEK_GW_Graf.ppx</TITLE>
  </HEAD>
  <PowerPlayReport xmlns="http://www.cognos.com/powerplay/report" Product_version="7.4.3101.0" Author="PPWIN" Version="1.3">
    <PPDSConnection Cube="nw_gw_vk.mdc" Path="\\GAPSDE444441\GAPS\Portal\System\Cube_out\">
      <DataPool>
        <Dimension DimIdx="6" Code="Fahrzeugart"/>
        <Dimension DimIdx="11" Code="Mandant"/>
        <Dimension DimIdx="0" Code="Zeit"/>
        <Dimension DimIdx="15" Code="KENNZAHLEN"/>
        <Dimension DimIdx="1" Code="AH-Gruppe"/>
        <PPDSID DimIdx="0" Code="Aktueller Tag" CatId="705"/>
        <PPDSID DimIdx="0" Code="J bisher" CatId="721"/>
        <PPDSID DimIdx="1" Code="1" CatId="1599"/>
        <Level LevelId="741" DimIdx="1" Code="Standort 3"/>
        <Level LevelId="745" DimIdx="1" Code="Verkäufer 4"/>
        <PPDSID DimIdx="1" Code="Hauptbetrieb" CatId="729"/>
        <PPDSID DimIdx="1" Code="05" CatId="1681"/>
        <PPDSID DimIdx="1" Code="04" CatId="1601"/>
        <PPDSID DimIdx="1" Code="03" CatId="1631"/>
        <PPDSID DimIdx="1" Code="02" CatId="1785"/>
        <PPDSID DimIdx="1" Code="01" CatId="1611"/>
        <PPDSID DimIdx="6" Code="Gebrauchtwagen" CatId="5221"/>
        <PPDSID DimIdx="11" Code="deop01" CatId="174305"/>
        <PPDSID DimIdx="11" Code="deop02" CatId="196103"/>
        <PPDSID DimIdx="11" Code="deop03" CatId="196105"/>
        <PPDSID DimIdx="11" Code="deop04" CatId="196107"/>
        <PPDSID DimIdx="11" Code="deop05" CatId="193003"/>
        <PPDSID DimIdx="11" Code="deop06" CatId="194107"/>
        <PPDSID DimIdx="11" Code="deop07" CatId="195265"/>
        <PPDSID DimIdx="11" Code="deop08" CatId="195731"/>
        <PPDSID DimIdx="11" Code="defo04" CatId="196109"/>
        <PPDSID DimIdx="11" Code="deho02" CatId="185613"/>
        <PPDSID DimIdx="11" Code="deni02" CatId="191881"/>
        <PPDSID DimIdx="11" Code="deop10" CatId="196111"/>
        <PPDSID DimIdx="11" Code="deop22" CatId="387205"/>
        <PPDSID DimIdx="11" Code="deop23" CatId="387207"/>
        <PPDSID DimIdx="11" Code="392277" CatId="392277"/>
        <PPDSID DimIdx="11" Code="deop19" CatId="393105"/>
        <PPDSID DimIdx="11" Code="400617" CatId="400617"/>
        <PPDSID DimIdx="11" Code="400619" CatId="400619"/>
        <PPDSID DimIdx="15" Code="KENNZAHLEN" CatId="4"/>
        <PPDSID DimIdx="15" Code="Erlös" CatId="771"/>
        <PPDSID DimIdx="15" Code="Ums. Fracht und Überf." CatId="775"/>
        <PPDSID DimIdx="15" Code="Einsatz" CatId="783"/>
        <PPDSID DimIdx="15" Code="Menge" CatId="767"/>
        <PPDSID DimIdx="15" Code="Gesamterlös (FZG u. Fracht)" CatId="11623"/>
        <PPDSID DimIdx="15" Code="Nachlass" CatId="779"/>
        <PPDSID DimIdx="15" Code="Bruttoertrag" CatId="11147"/>
        <PPDSID DimIdx="15" Code="Bruttoertrag %" CatId="11151"/>
        <PPDSID DimIdx="15" Code="durchschn. Bruttoertrag" CatId="11149"/>
      </DataPool>
      <custom_subsets/>
      <Filter RefIds="5221,4,4"/>
    </PPDSConnection>
    <ReportSpecification>
      <ReportAxis RankOrSort="Sort" Identifier="row">
        <NestGroup>
          <NestLevel Extent="158"/>
          <Category QueryKey="8"/>
          <Category Format="35" RefId="1599"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis Identifier="col">
        <NestGroup>
          <NestLevel/>
          <NestLevel/>
          <Category Hidden="1" RefId="771" ColExtent="77"/>
          <Category Hidden="1" RefId="775" ColExtent="77"/>
          <Category Hidden="1" RefId="783" ColExtent="71"/>
          <Category Format="36" RefId="705" Label="Gestern">
            <Category Format="33" RefId="767" ColExtent="64"/>
            <Category Format="31" RefId="11623" Label="Erlös Gesamt" ColExtent="71"/>
            <Category RefId="779" ColExtent="71"/>
            <Category Format="32" RefId="11147" Label="DB 1" ColExtent="71"/>
            <Category RefId="11151" Label="DB 1 in %" ColExtent="71"/>
            <Category RefId="11149" ColExtent="71"/>
          </Category>
          <Category Format="11" RefId="721">
            <Category Hidden="1" RefId="771" ColExtent="77"/>
            <Category Hidden="1" RefId="775" ColExtent="77"/>
            <Category Hidden="1" RefId="783" ColExtent="71"/>
          </Category>
        </NestGroup>
      </ReportAxis>
      <ReportAxis CurPos="0" Identifier="layer">
        <NestGroup>
          <NestLevel/>
          <Category RefId="1599"/>
          <Category RefId="174305"/>
          <Category RefId="196103"/>
          <Category RefId="196105"/>
          <Category RefId="196107"/>
          <Category RefId="193003"/>
          <Category RefId="194107"/>
          <Category RefId="195265"/>
          <Category RefId="195731"/>
          <Category RefId="196109"/>
          <Category RefId="185613"/>
          <Category RefId="191881"/>
          <Category RefId="196111"/>
          <Category RefId="387205"/>
          <Category RefId="387207"/>
          <Category RefId="392277"/>
          <Category RefId="393105"/>
          <Category RefId="400617"/>
          <Category RefId="400619"/>
        </NestGroup>
      </ReportAxis>
      <ReportSettings>
        <StandardReporting>
          <Set QueryKey="8" SetInsertAction="16" SetIndex="0" SetDimension="0" SetLevel="0"/>
          <QueryList>
            <AdvancedSubset Dimension="1" Key="7" Alias="Verkäufer AH9">
              <Level RefId="741"/>
              <Level RefId="745"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="6" Alias="Verkäufer AH6">
              <Level RefId="741"/>
              <Level RefId="745"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="5" Alias="Verkäufer AH5">
              <Level RefId="741"/>
              <Level RefId="745"/>
              <IncludeCat RefId="1681"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="4" Alias="Verkäufer AH4">
              <Level RefId="741"/>
              <Level RefId="745"/>
              <IncludeCat RefId="1601"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="3" Alias="Verkäufer AH3">
              <Level RefId="741"/>
              <Level RefId="745"/>
              <IncludeCat RefId="1631"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="2" Alias="Verkäufer AH2">
              <Level RefId="741"/>
              <Level RefId="745"/>
              <IncludeCat RefId="1785"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="1" Alias="Verkäufer AH1">
              <Level RefId="741"/>
              <Level RefId="745"/>
              <IncludeCat RefId="1611"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="0" Alias="Verkäufer">
              <Level RefId="741"/>
              <Level RefId="745"/>
              <IncludeCat RefId="1599"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="8" Alias="AH-Gruppe">
              <Level RefId="741"/>
              <IncludeCat RefId="1599"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
          </QueryList>
        </StandardReporting>
        <FormatList>
          <DefaultFormat>
            <Font Height="-11"/>
            <NumberFormat OwnerStyle="3" RefId="0" Decimals="0" Identifier="$#,##0"/>
          </DefaultFormat>
          <Format Id="11">
            <FontRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="31">
            <PatternRef RefId="3" Specifier="1"/>
          </Format>
          <Format Id="32">
            <PatternRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="33">
            <PatternRef RefId="4" Specifier="1"/>
          </Format>
          <Format Id="35">
            <FontRef RefId="5" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
            <PatternRef RefId="5" Specifier="0"/>
            <PatternRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="36">
            <FontRef RefId="5" Specifier="1"/>
          </Format>
          <Style Shared="true" Name="Niedrige automat. Ausnahmen">
            <FontRef RefId="3" Specifier="0"/>
            <FontRef RefId="3" Specifier="1"/>
            <PatternRef RefId="1" Specifier="0"/>
            <PatternRef RefId="1" Specifier="1"/>
            <AlignRef RefId="1" Specifier="0"/>
          </Style>
          <Style Shared="true" Name="Hohe automat. Ausnahmen">
            <FontRef RefId="4" Specifier="0"/>
            <FontRef RefId="4" Specifier="1"/>
            <PatternRef RefId="2" Specifier="0"/>
            <PatternRef RefId="2" Specifier="1"/>
            <AlignRef RefId="2" Specifier="0"/>
          </Style>
          <FormatAtom Type="alignment" Id="2"/>
          <FormatAtom Type="alignment" Id="1"/>
          <FormatAtom Weight="700" Type="font" Id="4">
            <Color G="128"/>
          </FormatAtom>
          <FormatAtom Weight="700" Type="font" Id="3">
            <Color R="255"/>
          </FormatAtom>
          <FormatAtom Height="-11" Weight="700" Type="font" Id="5"/>
          <FormatAtom Type="pattern" Id="2"/>
          <FormatAtom Type="pattern" Id="1"/>
          <FormatAtom Type="pattern" Id="3" Style="4">
            <Color G="255" B="255" Identifier="foreground"/>
          </FormatAtom>
          <FormatAtom Type="pattern" Id="4" Style="4">
            <Color G="192" R="192" B="192" Identifier="foreground"/>
          </FormatAtom>
          <FormatAtom Type="pattern" Id="5" Style="4">
            <Color G="255" R="255" Identifier="foreground"/>
          </FormatAtom>
        </FormatList>
      </ReportSettings>
    </ReportSpecification>
    <ChartLayout TileStyle="3" AutoFitMode="2">
      <CustomColor Idx="0" Value="10485760"/>
      <CustomColor Idx="1" Value="65535"/>
      <CustomColor Idx="2" Value="255"/>
      <CustomColor Idx="3" Value="16776960"/>
      <CustomColor Idx="4" Value="32512"/>
      <CustomColor Idx="5" Value="127"/>
      <CustomColor Idx="6" Value="8355584"/>
      <CustomColor Idx="7" Value="32767"/>
      <CustomColor Idx="8" Value="65280"/>
      <CustomColor Idx="9" Value="8323199"/>
      <CustomColor Idx="10" Value="32639"/>
      <CustomColor Idx="11" Value="16777087"/>
      <CustomColor Idx="12" Value="16711680"/>
      <CustomColor Idx="13" Value="16711935"/>
      <CustomColor Idx="14" Value="4243648"/>
      <CustomColor Idx="15" Value="12599360"/>
      <Crosstab/>
      <PageLayout>
        <MarginInfo B="134" T="134"/>
        <PageInfo PageOrientation="2" PageHeight="2970" PaperSource="15" PageWidth="2100" PageTypeID="9"/>
        <ReportStyle UseFontSubstitution="true" AxesAllPages="true"/>
        <ReportRange AllRows="1" Type="2" AllLayers="1"/>
      </PageLayout>
    </ChartLayout>
    <TextFrame Type="title" AppendPDFTitle="false">
      <Text>&lt;P&gt;&lt;Span Style="font: 12pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;Rechnungsausgänge &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;DIMENSION7&lt;/Var&gt;&lt;/B&gt;&lt;/Span&gt;&lt;Span Style="font: 12pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt; nach Verkäufern 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;CURRENT PERIOD&lt;/Var&gt;&lt;/B&gt;&lt;/Span&gt;&lt;/P&gt;</Text>
    </TextFrame>
    <Deployment>
      <ReportStyle UseFontSubstitution="true"/>
    </Deployment>
  </PowerPlayReport>
</Document>