GlobalCube
/
GAPS


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367
							<?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>1_Vorbereitung_Plan_2023.ppx</TITLE>
  </HEAD>
  <PowerPlayReport xmlns="http://www.cognos.com/powerplay/report" Product_version="7.4.3101.0" Author="PPWIN" Version="1.3">
    <PPDSConnection Cube="belege.mdc" Path="\\Gapsde444441\GAPS\Portal\System\Cube_Out\">
      <DataPool>
        <CatExp ExpId="T8454">
          <Op Code="+">
            <Ref RefId="5880281"/>
            <Ref RefId="4707635"/>
            <Ref RefId="5881077"/>
          </Op>
        </CatExp>
        <CatExp ExpId="T178473">
          <Op Code="+">
            <Ref RefId="22403"/>
            <Ref RefId="567131"/>
          </Op>
        </CatExp>
        <CatExp ExpId="T68" StaticBase="true">
          <Op Code="p">
            <Ref RefId="11591"/>
            <Ref RefId="28389"/>
          </Op>
        </CatExp>
        <CatExp ExpId="T90" StaticBase="true">
          <Op Code="p">
            <Ref RefId="55907"/>
            <Ref RefId="55597"/>
          </Op>
        </CatExp>
        <CatExp ExpId="T100501">
          <Op Code="+">
            <Ref RefId="5880855"/>
            <Ref RefId="5880661"/>
            <Ref RefId="5880471"/>
            <Ref RefId="5880283"/>
          </Op>
        </CatExp>
        <CatExp ExpId="T135179">
          <Op Code="+">
            <Ref RefId="11625"/>
            <Ref RefId="11805"/>
          </Op>
        </CatExp>
        <Dimension DimIdx="2" Code="Konten"/>
        <Dimension DimIdx="5" Code="Mandant"/>
        <Dimension DimIdx="0" Code="Zeit"/>
        <Dimension DimIdx="8" Code="KENNZAHLEN"/>
        <Dimension DimIdx="3" Code="Kostenstelle"/>
        <PPDSID DimIdx="0" Code="55819" CatId="55819"/>
        <Level LevelId="279" DimIdx="0" Code="Monat 4"/>
        <PPDSID DimIdx="0" Code="Aktueller Tag" CatId="291"/>
        <PPDSID DimIdx="0" Code="20220101-20221231" CatId="5880281"/>
        <PPDSID DimIdx="0" Code="20200101-20201231" CatId="4707635"/>
        <PPDSID DimIdx="0" Code="20210101-20211231" CatId="5881077"/>
        <PPDSID DimIdx="0" Code="20221001-20221031" CatId="5880855"/>
        <PPDSID DimIdx="0" Code="20220701-20220930" CatId="5880661"/>
        <PPDSID DimIdx="0" Code="20220401-20220630" CatId="5880471"/>
        <PPDSID DimIdx="0" Code="20220101-20220331" CatId="5880283"/>
        <PPDSID DimIdx="2" Code="65593" CatId="65593"/>
        <PPDSID DimIdx="2" Code="Gebrauchtwagen" CatId="59009"/>
        <PPDSID DimIdx="2" Code="Service" CatId="309315"/>
        <PPDSID DimIdx="2" Code="Umsatzerlöse" CatId="28389"/>
        <PPDSID DimIdx="2" Code="Einsatzwerte" CatId="24713"/>
        <PPDSID DimIdx="2" Code="55597" CatId="55597"/>
        <PPDSID DimIdx="2" Code="46653" CatId="46653"/>
        <PPDSID DimIdx="2" Code="Variable Kosten" CatId="24089"/>
        <PPDSID DimIdx="2" Code="Direkte Kosten" CatId="22415"/>
        <PPDSID DimIdx="2" Code="55637" CatId="55637"/>
        <PPDSID DimIdx="2" Code="Indirekte Kosten" CatId="22403"/>
        <PPDSID DimIdx="2" Code="55677" CatId="55677"/>
        <PPDSID DimIdx="2" Code="Raumkosten" CatId="567131"/>
        <PPDSID DimIdx="2" Code="55745" CatId="55745"/>
        <PPDSID DimIdx="2" Code="Neutraler Ertrag" CatId="22139"/>
        <PPDSID DimIdx="2" Code="Neutraler Aufwand" CatId="22103"/>
        <PPDSID DimIdx="2" Code="55749" CatId="55749"/>
        <PPDSID DimIdx="3" Code="Kostenstelle" CatId="373"/>
        <PPDSID DimIdx="3" Code="0" CatId="11591"/>
        <PPDSID DimIdx="3" Code="1" CatId="11597"/>
        <PPDSID DimIdx="3" Code="2" CatId="11613"/>
        <PPDSID DimIdx="3" Code="562165" CatId="562165"/>
        <PPDSID DimIdx="3" Code="6" CatId="11615"/>
        <PPDSID DimIdx="3" Code="8" CatId="55907"/>
        <PPDSID DimIdx="3" Code="7" CatId="11625"/>
        <PPDSID DimIdx="3" Code="9" CatId="11805"/>
        <PPDSID DimIdx="5" Code="deho02" CatId="1705329"/>
        <PPDSID DimIdx="5" Code="deop10" CatId="1705335"/>
        <PPDSID DimIdx="5" Code="deop11" CatId="1705337"/>
        <PPDSID DimIdx="5" Code="deop12" CatId="1705339"/>
        <PPDSID DimIdx="5" Code="deop13" CatId="1705341"/>
        <PPDSID DimIdx="5" Code="deop14" CatId="1705343"/>
        <PPDSID DimIdx="5" Code="deop15" CatId="1705345"/>
        <PPDSID DimIdx="5" Code="deop16" CatId="1705347"/>
        <PPDSID DimIdx="5" Code="deop17" CatId="1705349"/>
        <PPDSID DimIdx="5" Code="deop18" CatId="1705351"/>
        <PPDSID DimIdx="5" Code="deop20" CatId="2931349"/>
        <PPDSID DimIdx="5" Code="deop21" CatId="2936381"/>
        <PPDSID DimIdx="5" Code="deop23" CatId="2937291"/>
        <PPDSID DimIdx="5" Code="deop24" CatId="3108763"/>
        <PPDSID DimIdx="5" Code="deop25" CatId="3108765"/>
        <PPDSID DimIdx="5" Code="deop19" CatId="3108303"/>
        <PPDSID DimIdx="5" Code="deop22" CatId="2937289"/>
        <PPDSID DimIdx="5" Code="3109001" CatId="3109001"/>
        <PPDSID DimIdx="5" Code="4080231" CatId="4080231"/>
        <PPDSID DimIdx="5" Code="4080239" CatId="4080239"/>
        <PPDSID DimIdx="5" Code="deop29" CatId="5199223"/>
        <PPDSID DimIdx="5" Code="( Leerstelle )~148" CatId="3708265"/>
        <Level LevelId="1357987" DimIdx="5" Code="Mandant 2"/>
        <PPDSID DimIdx="5" Code="Mandant" CatId="1357979"/>
        <PPDSID DimIdx="8" Code="Ist" CatId="399"/>
      </DataPool>
      <custom_subsets/>
      <Filter RefIds="399,399"/>
    </PPDSConnection>
    <ReportSpecification>
      <ReportAxis Identifier="row">
        <NestGroup>
          <NestLevel Extent="155"/>
          <Category RefId="65593" Label="Neuwagen Stk."/>
          <Category RefId="59009" Label="Gebrauchtwagen Stk.">
            <Blank RowExtent="6"/>
          </Category>
          <Category Format="25" RefId="309315" Label="Service AW gesamt">
            <Blank RowExtent="5"/>
          </Category>
          <Category RefId="28389"/>
          <Category RefId="24713">
            <Blank RowExtent="8"/>
          </Category>
          <Category Format="3" Hidden="1" RefId="55597"/>
          <Category Format="19" RefId="46653">
            <Blank RowExtent="8"/>
          </Category>
          <Category RefId="24089"/>
          <Category RefId="22415">
            <Blank RowExtent="8"/>
          </Category>
          <Category Format="20" RefId="55637">
            <Blank RowExtent="8"/>
          </Category>
          <Category RefId="22403">
            <Blank RowExtent="8"/>
          </Category>
          <Category Format="21" RefId="55677">
            <Blank RowExtent="8"/>
          </Category>
          <Category RefId="567131"/>
          <Category DefaultLabel="Indirekte Kosten  +  Raumkosten" Format="30" RefId="T178473" Label="Indirekte Kosten  +  Raumkosten"/>
          <Category Format="22" RefId="55745">
            <Blank RowExtent="8"/>
          </Category>
          <Category RefId="22139"/>
          <Category RefId="22103">
            <Blank RowExtent="8"/>
          </Category>
          <Category Format="23" RefId="55749"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis CurPos="16" Identifier="col">
        <NestGroup>
          <NestLevel Extent="26"/>
          <Category DefaultLabel="2022 + 2020 + 2021" RefId="T8454" Label="2022 + 2020 + 2021"/>
          <Category DefaultLabel="Okt./2022 + 3. Q. 2022 + 2. Q. 2022 + 1. Q. 2022" RefId="T100501" Label="Okt./2022 + 3. Q. 2022 + 2. Q. 2022 + 1. Q. 2022"/>
        </NestGroup>
        <NestGroup>
          <NestLevel/>
          <Category Format="18" RefId="373" Label="Summe" ColExtent="67"/>
          <Category Format="27" RefId="11591" Label="0 - Ges.gesch." ColExtent="61"/>
          <Category Precedence="true" DefaultLabel="PrztVonBasis(0 - Gesamtgeschäft, Umsatzerlöse)" Format="26" RefId="T68" Label="%" ColExtent="40"/>
          <Category Format="18" RefId="11597" Label="1 - NW" ColExtent="67"/>
          <Category Format="18" RefId="11613" Label="2 - GW" ColExtent="67"/>
          <Category RefId="562165"/>
          <Category Format="18" RefId="11615" ColExtent="67"/>
          <Category Format="18" RefId="55907" Label="8 - Tankst." ColExtent="69"/>
          <Category Precedence="true" DefaultLabel="PrztVonBasis(8 - Tankst., Umsatzerlöse Gesamt)" Format="24" RefId="T90" Label="%" ColExtent="41"/>
          <Category DefaultLabel="7 - Sonst.  +  9 - KST9" Format="29" RefId="T135179" Label="SONST"/>
        </NestGroup>
      </ReportAxis>
      <ReportAxis CurPos="1" Identifier="layer">
        <NestGroup>
          <NestLevel/>
          <Category RefId="1705329"/>
          <Category RefId="1705335"/>
          <Category RefId="1705337"/>
          <Category RefId="1705339"/>
          <Category RefId="1705341"/>
          <Category RefId="1705343"/>
          <Category RefId="1705345"/>
          <Category RefId="1705347"/>
          <Category RefId="1705349"/>
          <Category RefId="1705351"/>
          <Category RefId="2931349"/>
          <Category RefId="2936381"/>
          <Category RefId="2937291"/>
          <Category RefId="3108763"/>
          <Category RefId="3108765"/>
          <Category RefId="3108303"/>
          <Category RefId="2937289"/>
          <Category RefId="3109001"/>
          <Category RefId="4080231"/>
          <Category RefId="4080239"/>
          <Category RefId="5199223"/>
          <Category RefId="3708265"/>
        </NestGroup>
      </ReportAxis>
      <ReportSettings>
        <StandardReporting>
          <QueryList>
            <AdvancedSubset CatDrillPath="55819" Dimension="0" QualifyDrillPath="55819" Key="0" Alias="Aktueller Monat">
              <Level RefId="279"/>
              <IncludeCat RefId="55819"/>
              <IncludeDrilPath RefId="291"/>
            </AdvancedSubset>
            <AdvancedSubset Dimension="5" Key="1" Alias="AH-Gruppe">
              <Level RefId="1357987"/>
              <IncludeCat RefId="1357979"/>
              <IncludeDrilPath RefId="1357979"/>
            </AdvancedSubset>
          </QueryList>
        </StandardReporting>
        <FormatList>
          <DefaultFormat>
            <Font Height="-11"/>
            <NumberFormat Decimals="3" RefId="0" Identifier="0"/>
          </DefaultFormat>
          <Format Id="3">
            <NumFormatRef RefId="7" Specifier="0"/>
          </Format>
          <Format Id="18">
            <PatternRef RefId="6" Specifier="1"/>
          </Format>
          <Format Id="19">
            <FontRef RefId="9" Specifier="0"/>
            <FontRef RefId="9" Specifier="1"/>
            <PatternRef RefId="7" Specifier="0"/>
            <PatternRef RefId="7" Specifier="1"/>
          </Format>
          <Format Id="20">
            <FontRef RefId="9" Specifier="0"/>
            <FontRef RefId="9" Specifier="1"/>
            <PatternRef RefId="7" Specifier="0"/>
            <PatternRef RefId="7" Specifier="1"/>
            <NumFormatRef RefId="10" Specifier="0"/>
          </Format>
          <Format Id="21">
            <FontRef RefId="9" Specifier="0"/>
            <FontRef RefId="9" Specifier="1"/>
            <PatternRef RefId="7" Specifier="0"/>
            <PatternRef RefId="7" Specifier="1"/>
            <NumFormatRef RefId="13" Specifier="0"/>
          </Format>
          <Format Id="22">
            <FontRef RefId="9" Specifier="0"/>
            <FontRef RefId="9" Specifier="1"/>
            <PatternRef RefId="7" Specifier="0"/>
            <PatternRef RefId="7" Specifier="1"/>
            <NumFormatRef RefId="15" Specifier="0"/>
          </Format>
          <Format Id="23">
            <FontRef RefId="9" Specifier="0"/>
            <FontRef RefId="9" Specifier="1"/>
            <PatternRef RefId="7" Specifier="0"/>
            <PatternRef RefId="7" Specifier="1"/>
            <NumFormatRef RefId="17" Specifier="0"/>
          </Format>
          <Format Id="24">
            <FontRef RefId="8" Specifier="0"/>
            <NumFormatRef RefId="6" Specifier="0"/>
            <NumFormatRef RefId="20" Specifier="399"/>
          </Format>
          <Format Id="25">
            <FontRef RefId="9" Specifier="1"/>
          </Format>
          <Format Id="26">
            <NumFormatRef RefId="6" Specifier="0"/>
          </Format>
          <Format Id="27">
            <PatternRef RefId="6" Specifier="1"/>
          </Format>
          <Format Id="29">
            <FontRef RefId="1" Specifier="0"/>
            <FontRef RefId="1" Specifier="1"/>
            <PatternRef RefId="6" Specifier="1"/>
          </Format>
          <Format Id="30">
            <FontRef RefId="1" Specifier="0"/>
            <FontRef RefId="1" Specifier="1"/>
          </Format>
          <Style Shared="true" Name="Hohe automat. Ausnahmen">
            <FontRef RefId="7" Specifier="0"/>
            <FontRef RefId="7" Specifier="1"/>
            <PatternRef RefId="5" Specifier="0"/>
            <PatternRef RefId="5" Specifier="1"/>
            <AlignRef RefId="5" Specifier="0"/>
          </Style>
          <Style Shared="true" Name="Niedrige automat. Ausnahmen">
            <FontRef RefId="6" Specifier="0"/>
            <FontRef RefId="6" Specifier="1"/>
            <PatternRef RefId="4" Specifier="0"/>
            <PatternRef RefId="4" Specifier="1"/>
            <AlignRef RefId="4" Specifier="0"/>
          </Style>
          <FormatAtom Type="alignment" Id="4"/>
          <FormatAtom Type="alignment" Id="5"/>
          <FormatAtom RefId="0" Decimals="2" Type="numberformat" Id="6" Identifier="0%"/>
          <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="15" Identifier="#,##0"/>
          <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="13" Identifier="#,##0"/>
          <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="10" Identifier="#,##0"/>
          <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="7" Identifier="#,##0"/>
          <FormatAtom RefId="399" Decimals="1" Type="numberformat" Id="20" Identifier="0%"/>
          <FormatAtom OwnerStyle="4294967294" RefId="0" Decimals="0" Type="numberformat" Id="17" Identifier="#,##0"/>
          <FormatAtom Weight="700" Type="font" Id="6">
            <Color R="255"/>
          </FormatAtom>
          <FormatAtom Weight="700" Type="font" Id="7">
            <Color G="128"/>
          </FormatAtom>
          <FormatAtom Height="-9" Type="font" Id="8"/>
          <FormatAtom Height="-11" Type="font" Id="1"/>
          <FormatAtom Height="-11" Weight="700" Type="font" Id="9"/>
          <FormatAtom Type="pattern" Id="4"/>
          <FormatAtom Type="pattern" Id="5"/>
          <FormatAtom Type="pattern" Id="6" Style="4">
            <Color G="192" R="192" B="192" Identifier="foreground"/>
          </FormatAtom>
          <FormatAtom Type="pattern" Id="7" Style="2">
            <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"/>
        <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;&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;CURRENT PERIOD&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;Finanzbericht nach Kostenstellen&amp;amp;#009;&amp;amp;#009;&amp;amp;#009;&lt;/B&gt;&lt;/Span&gt;&lt;/P&gt;</Text>
    </TextFrame>
    <Deployment>
      <ReportStyle UseFontSubstitution="true"/>
    </Deployment>
  </PowerPlayReport>
</Document>