GlobalCube
/
GAPS


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188
							<?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>Service_Gutschriften.ppx</TITLE>
  </HEAD>
  <PowerPlayReport xmlns="http://www.cognos.com/powerplay/report" Product_version="7.4.3101.0" Author="PPWIN" Version="1.3">
    <PPDSConnection Cube="gutschriften.mdc" Path="\\192.168.5.8\GAPS\Portal\System\Cube_out\">
      <DataPool>
        <Dimension DimIdx="0" Code="Zeit"/>
        <Dimension DimIdx="8" Code="KENNZAHLEN"/>
        <Dimension DimIdx="7" Code="Verteilung für Gutschriften"/>
        <Dimension DimIdx="1" Code="AH-Gruppe"/>
        <PPDSID DimIdx="0" Code="722725" CatId="722725"/>
        <PPDSID DimIdx="1" Code="Hauptbetrieb" CatId="793"/>
        <Level LevelId="739007" DimIdx="1" Code="Mandant 2"/>
        <PPDSID DimIdx="7" Code="Teile" CatId="723611"/>
        <PPDSID DimIdx="7" Code="723621" CatId="723621"/>
        <PPDSID DimIdx="7" Code="723623" CatId="723623"/>
        <PPDSID DimIdx="7" Code="723625" CatId="723625"/>
        <PPDSID DimIdx="7" Code="Service" CatId="723609"/>
        <PPDSID DimIdx="7" Code="723627" CatId="723627"/>
        <PPDSID DimIdx="7" Code="723629" CatId="723629"/>
        <PPDSID DimIdx="7" Code="723631" CatId="723631"/>
        <Level LevelId="219063" DimIdx="7" Code="Serviceberater 4"/>
        <Level LevelId="718273" DimIdx="7" Code="Kunde_fuer_Gutschriften 5"/>
        <PPDSID DimIdx="7" Code="Verteilung für Gutschriften" CatId="219051"/>
        <PPDSID DimIdx="8" Code="Umsatz gesamt" CatId="31677"/>
        <PPDSID DimIdx="8" Code="Durchgänge (Aufträge)" CatId="723645"/>
      </DataPool>
      <custom_subsets/>
      <Filter RefIds="31677,31677"/>
    </PPDSConnection>
    <ReportSpecification>
      <ReportAxis Identifier="row">
        <NestGroup>
          <NestLevel Extent="118"/>
          <NestLevel Extent="371"/>
          <Category Format="7" RefId="793" Label="Serviceberater | Order No. | Händler | Kunden Nr. | Kunde | Rechnungsdatum"/>
          <Category QueryKey="0"/>
          <Category Format="5" RefId="793" Label="Gesamt"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis Identifier="col">
        <NestGroup>
          <NestLevel Extent="29"/>
          <Category Format="3" RefId="722725"/>
        </NestGroup>
        <NestGroup>
          <NestLevel Extent="22"/>
          <NestLevel Extent="23"/>
          <Category Format="4" RefId="723611">
            <Category Format="9" RefId="723621" ColExtent="40"/>
            <Category RefId="723623"/>
            <Category Format="9" RefId="723625" ColExtent="40"/>
          </Category>
          <Category Format="4" RefId="723609">
            <Category Format="9" RefId="723627" ColExtent="46"/>
            <Category Format="9" RefId="723629" ColExtent="40"/>
            <Category Format="9" RefId="723631" ColExtent="40"/>
          </Category>
          <Category Format="10" RefId="723645" Label="DG" ColExtent="26"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis CurPos="0" Identifier="layer">
        <NestGroup>
          <NestLevel/>
          <Category RefId="793" Label="Dresen GmbH Gesamt"/>
          <Category QueryKey="1"/>
        </NestGroup>
      </ReportAxis>
      <ReportSettings AutoExceptSensitivity="-50" Suppression="zero">
        <StandardReporting>
          <Set QueryKey="0" SetInsertAction="16" SetIndex="1" SetDimension="0" SetLevel="1"/>
          <Set QueryKey="1" SetInsertAction="16" SetIndex="1" SetDimension="2" SetLevel="0"/>
          <QueryList>
            <AdvancedSubset Dimension="7" Key="0" Alias="Aufträge">
              <Level RefId="219063"/>
              <Level RefId="718273"/>
              <IncludeCat RefId="219051"/>
              <IncludeDrilPath RefId="219051"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="1" Key="1" Alias="AH-Gruppe">
              <Level RefId="739007"/>
              <IncludeCat RefId="793"/>
              <IncludeDrilPath RefId="793"/>
            </AdvancedSubset>
          </QueryList>
        </StandardReporting>
        <FormatList>
          <DefaultFormat>
            <Font Height="-11"/>
          </DefaultFormat>
          <Format Id="3">
            <FontRef RefId="5" Specifier="1"/>
            <NumFormatRef RefId="19" Specifier="31677"/>
          </Format>
          <Format Id="4">
            <FontRef RefId="5" Specifier="1"/>
            <NumFormatRef RefId="19" Specifier="31677"/>
          </Format>
          <Format Id="5">
            <FontRef RefId="5" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
            <PatternRef RefId="3" Specifier="0"/>
            <PatternRef RefId="3" Specifier="1"/>
            <NumFormatRef RefId="19" Specifier="31677"/>
          </Format>
          <Format Id="7">
            <FontRef RefId="6" Specifier="0"/>
            <FontRef RefId="5" Specifier="1"/>
            <NumFormatRef RefId="19" Specifier="31677"/>
          </Format>
          <Format Id="9">
            <FontRef RefId="5" Specifier="1"/>
            <NumFormatRef RefId="19" Specifier="31677"/>
          </Format>
          <Format Id="10">
            <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 RefId="31677" Decimals="0" Type="numberformat" Id="19" 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" Weight="700" Type="font" Id="5"/>
          <FormatAtom Height="-11" Type="font" Id="6">
            <Color G="255" R="255" B="255"/>
          </FormatAtom>
          <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>
        </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 PageHeight="2970" PaperSource="15" PageWidth="2100" PageTypeID="9"/>
        <ReportStyle UseFontSubstitution="true"/>
        <ReportRange AllRows="1" Type="2" AllLayers="1"/>
      </PageLayout>
    </ChartLayout>
    <TextFrame Type="title" AppendPDFTitle="false">
      <Text>&lt;P&gt;&lt;Span Style="font: 10pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;Controlling &lt;/B&gt;&lt;/Span&gt;&lt;Span Style="font: 10pt 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;&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;DATE(dddd, d. MMMM yyyy)&lt;/Var&gt;&lt;/Span&gt;&lt;/P&gt;&lt;P&gt;&lt;Span Style="font: 10pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;Gutschriften nach SB - Letzte 7 Tage&lt;/B&gt;&lt;/Span&gt;&lt;/P&gt;</Text>
    </TextFrame>
    <Deployment>
      <ReportStyle UseFontSubstitution="true"/>
    </Deployment>
  </PowerPlayReport>
</Document>