GlobalCube
/
GAPS


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220
							<?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>08.04.13 Umsatz_nach_Serviceberatern.ppx</TITLE>
  </HEAD>
  <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">
    <PPDSConnection Cube="aftersales.mdc" Path="\\Srvap02\gaps\Portal\System\Cube_out\">
      <DataPool>
        <CatExp ExpId="T16">
          <Op Code="/">
            <Ref RefId="62285"/>
            <Ref RefId="62529"/>
          </Op>
        </CatExp>
        <CatExp ExpId="T22">
          <Op Code="/">
            <Ref RefId="823"/>
            <Ref RefId="62285"/>
          </Op>
        </CatExp>
        <Dimension DimIdx="0" Code="Zeit"/>
        <Dimension DimIdx="14" Code="KENNZAHLEN"/>
        <Dimension DimIdx="1" Code="AH-Gruppe"/>
        <PPDSID DimIdx="0" Code="M bisher" CatId="773"/>
        <PPDSID DimIdx="0" Code="J bisher" CatId="785"/>
        <PPDSID DimIdx="1" Code="01" CatId="219025"/>
        <PPDSID DimIdx="1" Code="1" CatId="1607"/>
        <PPDSID DimIdx="1" Code="Zentrale" CatId="223821"/>
        <PPDSID DimIdx="1" Code="Henri Wetzel" CatId="224451"/>
        <PPDSID DimIdx="1" Code="Mandy Kreher" CatId="226351"/>
        <PPDSID DimIdx="1" Code="Matthias Jacob" CatId="227335"/>
        <PPDSID DimIdx="1" Code="Michael Meuser" CatId="229309"/>
        <Level LevelId="805" DimIdx="1" Code="Standort 3"/>
        <Level LevelId="809" DimIdx="1" Code="Serviceberater 4"/>
        <PPDSID DimIdx="1" Code="Hauptbetrieb" CatId="793"/>
        <PPDSID DimIdx="14" Code="KENNZAHLEN" CatId="4"/>
        <PPDSID DimIdx="14" Code="Umsatz gesamt" CatId="31677"/>
        <PPDSID DimIdx="14" Code="Umsatz Lohn" CatId="823"/>
        <PPDSID DimIdx="14" Code="Umsatz Teile Service" CatId="819"/>
        <PPDSID DimIdx="14" Code="DB 1 Teile Ser. %" CatId="98233"/>
        <PPDSID DimIdx="14" Code="Umsatz Sonstiges" CatId="62243"/>
        <PPDSID DimIdx="14" Code="verk. AW" CatId="62285"/>
        <PPDSID DimIdx="14" Code="Durchgänge (Auftrag)" CatId="62529"/>
      </DataPool>
      <custom_subsets/>
      <Filter RefIds="4,4"/>
    </PPDSConnection>
    <ReportSpecification>
      <ReportAxis Identifier="row">
        <NestGroup>
          <NestLevel Extent="48"/>
          <NestLevel/>
          <Category QueryKey="0"/>
          <Category Format="40" RefId="219025"/>
          <Category Format="26" RefId="1607"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis Identifier="col">
        <NestGroup>
          <NestLevel Extent="24"/>
          <Category Format="28" RefId="773"/>
          <Category Format="28" RefId="785"/>
        </NestGroup>
        <NestGroup>
          <NestLevel Extent="51"/>
          <Category Format="14" RefId="31677" ColExtent="64"/>
          <Category Format="15" RefId="823" ColExtent="64"/>
          <Category Format="15" RefId="819" ColExtent="64"/>
          <Category Format="21" RefId="98233" Label="DB 1 Teile %" ColExtent="42"/>
          <Category Format="15" RefId="62243" Label="Umsatz Sonst." ColExtent="51"/>
          <Category Format="22" RefId="62285" ColExtent="51"/>
          <Category DefaultLabel="Umsatz Lohn  /  verk. AW" Format="25" RefId="T22" Label="AW-    Satz" ColExtent="44"/>
          <Category Format="18" RefId="62529" Label="Durchg. (Auftr.)" ColExtent="48"/>
          <Category DefaultLabel="verk. AW  /  Durchg. (Auftr.)" Format="35" RefId="T16" Label="AW / DG" ColExtent="35"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis CurPos="0" Identifier="layer">
        <NestGroup>
          <NestLevel/>
          <Category RefId="1607"/>
        </NestGroup>
      </ReportAxis>
      <ReportSettings Suppression="zero-suppress-rows">
        <StandardReporting>
          <Set QueryKey="0" SetInsertAction="16" SetIndex="0" SetDimension="0" SetLevel="1">
            <SetFormatEntries Hidden="1" RefId="223821"/>
            <SetFormatEntries Hidden="1" RefId="224451"/>
            <SetFormatEntries Hidden="1" RefId="226351"/>
            <SetFormatEntries Hidden="1" RefId="227335"/>
            <SetFormatEntries Hidden="1" RefId="229309"/>
          </Set>
          <QueryList>
            <AdvancedSubset Dimension="1" Key="0" Alias="SC-Berater AH1">
              <Level RefId="805"/>
              <Level RefId="809"/>
              <IncludeCat RefId="219025"/>
              <IncludeDrilPath RefId="793"/>
            </AdvancedSubset>
          </QueryList>
        </StandardReporting>
        <FormatList>
          <DefaultFormat>
            <Font Height="-11"/>
            <NumberFormat OwnerStyle="2" RefId="0" Decimals="0" Identifier="Allgemein"/>
          </DefaultFormat>
          <Format Id="14">
            <FontRef RefId="6" Specifier="1"/>
            <PatternRef RefId="4" Specifier="1"/>
            <NumFormatRef RefId="22" Specifier="31677"/>
          </Format>
          <Format Id="15">
            <NumFormatRef RefId="22" Specifier="31677"/>
          </Format>
          <Format Id="18">
            <NumFormatRef RefId="22" Specifier="31677"/>
          </Format>
          <Format Id="21">
            <PatternRef RefId="3" Specifier="1"/>
          </Format>
          <Format Id="22">
            <PatternRef RefId="5" Specifier="1"/>
            <NumFormatRef RefId="22" Specifier="31677"/>
          </Format>
          <Format Id="25">
            <FontRef RefId="5" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
            <NumFormatRef RefId="21" Specifier="31677"/>
          </Format>
          <Format Id="26">
            <FontRef RefId="6" Specifier="0"/>
            <FontRef RefId="6" Specifier="1"/>
            <PatternRef RefId="5" Specifier="0"/>
            <PatternRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="28">
            <FontRef RefId="6" Specifier="1"/>
          </Format>
          <Format Id="35">
            <FontRef RefId="5" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
            <NumFormatRef RefId="20" Specifier="0"/>
          </Format>
          <Format Id="40">
            <FontRef RefId="6" Specifier="0"/>
            <FontRef RefId="6" 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 OwnerStyle="4294967293" RefId="0" Decimals="0" Type="numberformat" Id="20" Identifier="#,##0"/>
          <FormatAtom RefId="31677" Decimals="2" Type="numberformat" Id="21" Identifier="#,##0"/>
          <FormatAtom OwnerStyle="4294967293" RefId="31677" Decimals="0" Type="numberformat" Id="22" Identifier="#,##0"/>
          <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" Type="font" Id="5"/>
          <FormatAtom Height="-11" Weight="700" Type="font" Id="6"/>
          <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="1" 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;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>
    </TextFrame>
    <Deployment>
      <ReportStyle UseFontSubstitution="true" AxesAllPages="true"/>
    </Deployment>
  </PowerPlayReport>
</Document>