GlobalCube
/
GAPS


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242
							<?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>NW_VK_Verkaeuferbericht_Det.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="J bisher" CatId="721"/>
        <PPDSID DimIdx="0" Code="M bisher" CatId="709"/>
        <PPDSID DimIdx="1" Code="01" CatId="1611"/>
        <PPDSID DimIdx="1" Code="02" CatId="1785"/>
        <PPDSID DimIdx="1" Code="03" CatId="1631"/>
        <PPDSID DimIdx="1" Code="04" CatId="1601"/>
        <Level LevelId="741" DimIdx="1" Code="Standort 3"/>
        <PPDSID DimIdx="1" Code="1" CatId="1599"/>
        <PPDSID DimIdx="1" Code="Hauptbetrieb" CatId="729"/>
        <Level LevelId="745" DimIdx="1" Code="Verkäufer 4"/>
        <Level LevelId="749" DimIdx="1" Code="Fabrikat 5"/>
        <Level LevelId="753" DimIdx="1" Code="Model 6"/>
        <PPDSID DimIdx="6" Code="Neuwagen" CatId="2617"/>
        <Level LevelId="168403" DimIdx="11" Code="Standort 3"/>
        <Level LevelId="196305" DimIdx="11" Code="Verkäufer 4"/>
        <PPDSID DimIdx="11" Code="Mandant" CatId="168391"/>
        <PPDSID DimIdx="15" Code="KENNZAHLEN" CatId="4"/>
        <PPDSID DimIdx="15" Code="Menge" CatId="767"/>
        <PPDSID DimIdx="15" Code="Gesamterlös (FZG u. Fracht)" CatId="11623"/>
        <PPDSID DimIdx="15" Code="Nachlass u. OSP" CatId="16459"/>
        <PPDSID DimIdx="15" Code="Bruttoertrag" CatId="11147"/>
        <PPDSID DimIdx="15" Code="Bruttoertrag %" CatId="11151"/>
        <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"/>
      </DataPool>
      <custom_subsets/>
      <Filter RefIds="2617,4,4"/>
    </PPDSConnection>
    <ReportSpecification>
      <ReportAxis RankOrSort="Sort" Identifier="row">
        <NestGroup>
          <NestLevel Extent="90"/>
          <NestLevel Extent="64"/>
          <NestLevel Extent="146"/>
          <NestLevel Extent="196"/>
          <Category QueryKey="1"/>
          <Category Format="45" Hidden="4" RefId="1611"/>
          <Category QueryKey="2"/>
          <Category Format="46" Hidden="4" RefId="1785"/>
          <Category QueryKey="3"/>
          <Category Format="46" Hidden="4" RefId="1631"/>
          <Category QueryKey="4"/>
          <Category Format="46" Hidden="4" RefId="1601"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis Identifier="col">
        <NestGroup>
          <NestLevel Extent="28"/>
          <Category Format="50" RefId="721" Label="Jahr bisher"/>
        </NestGroup>
        <NestGroup>
          <NestLevel/>
          <NestLevel Extent="5"/>
          <Category Format="51" RefId="767" ColExtent="64"/>
          <Category Format="53" RefId="11623" Label="Erlös (FZG u. Fracht)" ColExtent="71"/>
          <Category RefId="16459" ColExtent="70"/>
          <Category Format="54" RefId="11147" Label="DB 1" ColExtent="71"/>
          <Category RefId="11151" Label="DB 1 in %" ColExtent="71"/>
          <Category Format="11" RefId="709">
            <Category Hidden="1" RefId="771" ColExtent="77"/>
            <Category Hidden="1" RefId="775" ColExtent="77"/>
            <Category Hidden="1" RefId="783" 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/>
          <NestLevel/>
          <Category QueryKey="0"/>
        </NestGroup>
      </ReportAxis>
      <ReportSettings Suppression="zero-suppress-rows">
        <StandardReporting>
          <Set QueryKey="1" SetInsertAction="16" SetIndex="0" SetDimension="0" SetLevel="3"/>
          <Set QueryKey="2" SetInsertAction="16" SetIndex="1310" SetDimension="0" SetLevel="3"/>
          <Set QueryKey="3" SetInsertAction="16" SetIndex="1683" SetDimension="0" SetLevel="3"/>
          <Set QueryKey="4" SetInsertAction="16" SetIndex="2062" SetDimension="0" SetLevel="3"/>
          <Set QueryKey="0" SetInsertAction="16" SetIndex="0" SetDimension="2" SetLevel="1"/>
          <QueryList>
            <AdvancedSubset Dimension="1" Key="8" Alias="AH-Gruppe">
              <Level RefId="741"/>
              <IncludeCat RefId="1599"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="4" Alias="Verkäufer AH4">
              <Level RefId="745"/>
              <Level RefId="749"/>
              <Level RefId="753"/>
              <Level RefId="0"/>
              <IncludeCat RefId="1601"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="3" Alias="Verkäufer AH3">
              <Level RefId="745"/>
              <Level RefId="749"/>
              <Level RefId="753"/>
              <Level RefId="0"/>
              <IncludeCat RefId="1631"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="2" Alias="Verkäufer AH2">
              <Level RefId="745"/>
              <Level RefId="749"/>
              <Level RefId="753"/>
              <Level RefId="0"/>
              <IncludeCat RefId="1785"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="1" Alias="Verkäufer AH1">
              <Level RefId="745"/>
              <Level RefId="749"/>
              <Level RefId="753"/>
              <Level RefId="0"/>
              <IncludeCat RefId="1611"/>
              <IncludeDrilPath RefId="729"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="11" Key="0" Alias="Verkäufer">
              <Level RefId="168403"/>
              <Level RefId="196305"/>
              <IncludeCat RefId="168391"/>
              <IncludeDrilPath RefId="168391"/>
            </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="45">
            <FontRef RefId="5" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="46">
            <FontRef RefId="5" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="50">
            <FontRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="51">
            <PatternRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="53">
            <PatternRef RefId="4" Specifier="1"/>
          </Format>
          <Format Id="54">
            <PatternRef RefId="3" Specifier="1"/>
          </Format>
          <Style Shared="true" Name="Hohe 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="Niedrige 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 R="255"/>
          </FormatAtom>
          <FormatAtom Weight="700" Type="font" Id="3">
            <Color G="128"/>
          </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" R="255" Identifier="foreground"/>
          </FormatAtom>
          <FormatAtom Type="pattern" Id="4" Style="4">
            <Color G="255" B="255" Identifier="foreground"/>
          </FormatAtom>
          <FormatAtom Type="pattern" Id="5" Style="4">
            <Color G="192" R="192" B="192" 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" RowCount="0" Type="2" LayerCount="0" 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; &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: 12pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt; 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;&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>
    </TextFrame>
    <Deployment>
      <ReportStyle UseFontSubstitution="true"/>
    </Deployment>
  </PowerPlayReport>
</Document>