GlobalCube
/
GAPS


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
							<?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>7_14_Nachlass_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="C:\Gaps\Portal\System\Cube_out\">
      <DataPool>
        <Dimension DimIdx="6" Code="Auftragsart"/>
        <Dimension DimIdx="0" Code="Zeit"/>
        <Dimension DimIdx="16" Code="KENNZAHLEN"/>
        <Dimension DimIdx="1" Code="AH-Gruppe"/>
        <PPDSID DimIdx="0" Code="221679" CatId="221679"/>
        <PPDSID DimIdx="0" Code="M bisher" CatId="773"/>
        <PPDSID DimIdx="1" Code="01" CatId="219025"/>
        <PPDSID DimIdx="1" Code="02" CatId="219027"/>
        <PPDSID DimIdx="1" Code="1" CatId="1607"/>
        <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="6" Code="Service" CatId="31769"/>
        <PPDSID DimIdx="16" Code="KENNZAHLEN" CatId="4"/>
        <PPDSID DimIdx="16" Code="Umsatz gesamt" CatId="31677"/>
        <PPDSID DimIdx="16" Code="Umsatz Lohn" CatId="823"/>
        <PPDSID DimIdx="16" Code="Umsatz Teile Service" CatId="819"/>
        <PPDSID DimIdx="16" Code="Nachlass" CatId="221675"/>
        <PPDSID DimIdx="16" Code="Nachlass Teile Service" CatId="221703"/>
        <PPDSID DimIdx="16" Code="Nachlass Lohn" CatId="221707"/>
        <PPDSID DimIdx="16" Code="Umsatz Sonstiges" CatId="62243"/>
        <PPDSID DimIdx="16" Code="Nachlass Sonst." CatId="221711"/>
      </DataPool>
      <custom_subsets/>
      <Filter RefIds="31769,4,4"/>
    </PPDSConnection>
    <ReportSpecification>
      <ReportAxis Identifier="row">
        <NestGroup>
          <NestLevel Extent="48"/>
          <NestLevel Extent="113"/>
          <Category QueryKey="0"/>
          <Category Format="40" RefId="219025"/>
          <Category QueryKey="1"/>
          <Category Format="40" RefId="219027"/>
          <Category Format="26" RefId="1607"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis Identifier="col">
        <NestGroup>
          <NestLevel Extent="24"/>
          <Category Format="52" RefId="221679"/>
          <Category Format="28" RefId="773"/>
        </NestGroup>
        <NestGroup>
          <NestLevel Extent="51"/>
          <Category Format="50" RefId="31677" ColExtent="58"/>
          <Category Format="15" Hidden="1" RefId="823" ColExtent="64"/>
          <Category Format="15" Hidden="1" RefId="819" ColExtent="64"/>
          <Category Format="49" RefId="221675" Label="Nach- lass Gesamt" ColExtent="51"/>
          <Category Format="51" RefId="819" ColExtent="58"/>
          <Category Format="49" RefId="221703" Label="Nach- lass Teile Service" ColExtent="49"/>
          <Category Format="51" RefId="823" ColExtent="58"/>
          <Category Format="49" RefId="221707" Label="Nach- lass Lohn" ColExtent="49"/>
          <Category Format="51" RefId="62243" Label="Umsatz Sonst." ColExtent="58"/>
          <Category Format="49" RefId="221711" Label="Nach- lass Sonst." ColExtent="49"/>
          <Category Format="15" Hidden="1" RefId="62243" Label="Umsatz Sonst." ColExtent="51"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis CurPos="0" Identifier="layer">
        <NestGroup>
          <NestLevel/>
          <Category RefId="1607"/>
          <Category RefId="219025"/>
          <Category RefId="219027"/>
        </NestGroup>
      </ReportAxis>
      <ReportSettings Suppression="zero-suppress-rows">
        <StandardReporting>
          <Set QueryKey="0" SetInsertAction="16" SetIndex="0" SetDimension="0" SetLevel="1"/>
          <Set QueryKey="1" SetInsertAction="16" SetIndex="25" SetDimension="0" SetLevel="1"/>
          <QueryList>
            <AdvancedSubset Dimension="1" Key="1" Alias="SC-Berater AH2">
              <Level RefId="805"/>
              <Level RefId="809"/>
              <IncludeCat RefId="219027"/>
              <IncludeDrilPath RefId="793"/>
            </AdvancedSubset>
            <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="15">
            <NumFormatRef RefId="32" Specifier="31677"/>
          </Format>
          <Format Id="26">
            <FontRef RefId="5" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
            <PatternRef RefId="4" Specifier="0"/>
            <PatternRef RefId="4" Specifier="1"/>
          </Format>
          <Format Id="28">
            <FontRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="40">
            <FontRef RefId="5" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
          </Format>
          <Format Id="49">
            <FontRef RefId="5" Specifier="1"/>
            <NumFormatRef RefId="33" Specifier="31677"/>
          </Format>
          <Format Id="50">
            <FontRef RefId="5" Specifier="1"/>
            <PatternRef RefId="3" Specifier="0"/>
            <PatternRef RefId="3" Specifier="1"/>
            <NumFormatRef RefId="33" Specifier="31677"/>
          </Format>
          <Format Id="51">
            <FontRef RefId="5" Specifier="1"/>
            <PatternRef RefId="3" Specifier="0"/>
            <PatternRef RefId="3" Specifier="1"/>
            <NumFormatRef RefId="33" Specifier="31677"/>
          </Format>
          <Format Id="52">
            <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 OwnerStyle="4294967293" RefId="31677" Decimals="0" Type="numberformat" Id="32" Identifier="#,##0"/>
          <FormatAtom RefId="31677" Decimals="0" Type="numberformat" Id="33" Identifier="#,##0"/>
          <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="3">
            <Color G="255" R="255" Identifier="background"/>
            <Color G="255" R="255" B="255" Identifier="foreground"/>
          </FormatAtom>
          <FormatAtom Type="pattern" Id="4" 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 Nachlässe 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>