Skip to main content

Ayuda sobre productos BOLD:

Biblioteca de informes de tabla dinámica

Última modificación
byGustau Santos
0 out Of 5 Stars
5 Estrellas 0%
4 Estrellas 0%
3 Estrellas 0%
2 Estrellas 0%
1 Estrellas 0%
Página:
< Volver

ATENCIÓN: El siguiente contenido es de uso avanzado y su utilización puede ocasionar daños irreparables en la configuración del sistema

Para ver el formato general consultar el artículo: Formato xml informe dinámico

Nº de días de baja por empleado/contrato

<?xml version="1.0" encoding="ISO-8859-1" ?> 
 <IntContainerVector Count="1" >
  
  <UpdateFields UpdateAll="1"/>
 
  <BIDatacubeModel>
 
  <Name value="CuentaBajas" />
  <Description value="Cuenta el nº de días de baja de todos los empleados" />
    <ExtCode value="CuentaBajas" />
    <DataInputType value="4" /> <!-- Iterator_ByDay_ForPlanTasks  -->
    <ReportClass value="0" />   <!-- Cuando el origen de datos sea un informe nativo del sistema (DataInputType=0) -->
    <EnableAggregationStep value="1" />
    <Parent value="0" valueRef="" />
    
  <Definition>

  <InputFilter>
  <Expression>
    <![CDATA[ true ]]> 
  </Expression>
  </InputFilter>


        
  <X_Axis >
      <Axis Count="3" >
        <Rows>
      <BIDimension>
        <Name value="W" /><ShowName value="Empleado" /><Description value="" /><Visible value="True" /><Type valueEnum="refObj" /><Default value="0" /><EnumFamily value="" /><RefClass valueEnum="Worker" />  
        <Expression>
        <![CDATA[ WorkerPlan.ContractWorker.Worker ]]> 
        </Expression>
      </BIDimension> 
        </Rows>
      </Axis>
    </X_Axis>
    
  <Y_Axis/>
  
  <!-- Extra calculated input columns -->
    <Input_Axis >
      <Axis Count="1" >
        <Rows>
        </Rows>
      </Axis>
    </Input_Axis>
  <!-- Inner cell data rows -->
    <Cells >
      <DataCells Count="50" >
        <Rows>  
            <BIDataCellDimension>
              <Name value="Num" /><ShowName value="Num" /><Description value="" /><Visible value="True" /><Type valueEnum="int" /><Default value="" /><EnumFamily value="" /><RefClass value="0" />
              <EnumAggrFunc value="1" /> <!-- Sum -->
              <Expression>
                 <![CDATA[ IfElse(TimePeriod.Incidence != 0 && TimePeriod.Incidence.DiscountFrom == 5, 1, 0) ]]>
              </Expression>
            </BIDataCellDimension>          
        </Rows>
      </DataCells>
    </Cells>


  <!-- From aggregated output columns, additional calculated colums -->
    <Output_Axis >
      <Axis Count="75">
        <Rows>
            <BIDimension>      
               <Name value="Worker" /><ShowName value="Nombre Completo" /><Description value="" /><Visible value="True" /><Type valueEnum="string" /> <!-- string --><Default value="" />
               <Expression>
                 <![CDATA[W.FullName ]]>
               </Expression>
            </BIDimension>
        </Rows> 
      </Axis>
    </Output_Axis>
    </Definition>
  </BIDatacubeModel>    
 </IntContainerVector>

Plantilla Informe especial Contrato y Dia

<IntContainerVector Count="1">
<UpdateFields UpdateAll="1" />
<BIDatacubeModel>
<Name value="InformeHorasExtras" />
<ExtCode value="InformeHorasExtras" />
<Description value="Horas Extras" />
<DataInputType value="6" />
<ReportClass value="0" />
<EnableAggregationStep value="True" />
<Definition>
<BeforeExpression>
<Expression>
<![CDATA[
            ""
        ]]>
</Expression>
</BeforeExpression>
<AfterExpression>
<Expression>
<![CDATA[
              ""
]]>
</Expression>
</AfterExpression>
<InputFilter>
<Expression>
<![CDATA[
    PL_NumPeriods(PL_Interval(W_GetIncidencesAsPL(Worker.ID), ActSched.AssignedDay, ActSched.AssignedDay+2, true, true)) > 0
]]>
</Expression>
</InputFilter>
<InputFilterByWorker>
<Expression>
<![CDATA[
  true
]]>
</Expression>
</InputFilterByWorker>
<X_Axis>
<Axis Count="2" >
<Rows>
<BIDimension>
<Name value="StartDate" />
<ShowName value="Inicio" />
<Description value="" />
<Visible value="True" />
<Type value="8" />
<Default value="0" />
<EnumFamily value="" />
<RefClass value="0" />
<ShowFormat value="" />
<ShowType value="19" />
<ReverseShowFormat value="" />
<Expression>
<![CDATA[
                ActSched.AssignedDay
    ]]>
</Expression>
</BIDimension>
<BIDimension>
<Name value="IdCW" />
<ShowName value="Contrato" />
<Description value="" />
<Visible value="True" />
<Type valueEnum="refObj" />
<Default value="0" />
<EnumFamily value="" />
<RefClass valueEnum="ContractWorker" />
<Expression>
<![CDATA[
                    WorkerPlan.ContractWorker
    ]]>
</Expression>
</BIDimension>
</Rows>
</Axis>
</X_Axis>
<Y_Axis>
<Axis Count="0" >
<Rows>
</Rows>
</Axis>
</Y_Axis>
<Cells>

</Cells>
<Input_Axis>
<Axis Count="0" >
<Rows>
</Rows>
</Axis>
</Input_Axis>
<Output_Axis>
<Axis Count="243" >
<Rows>
<BIDimension>
<Name value="WorkerName" /><ShowName value="Empleado" /><Type valueEnum="string" /><Description value="" /><Visible value="True" /><Default value="" />
<Expression>
<![CDATA[
  IdCW.Worker.Name
]]>
</Expression>
</BIDimension>
</Rows>
</Axis>
</Output_Axis>
</Definition>
</BIDatacubeModel>
</IntContainerVector>

Nº Mañanas / Tardes y Noches por empleado

<?xml version="1.0" encoding="ISO-8859-1" ?>
 
 <IntContainerVector Count="1" >
  
  <UpdateFields UpdateAll="1"/>
 
  <BIDatacubeModel>
 
  <Name value="InformeWorker_MTN" />
    <ExtCode value="InformeWorker_MTN" />
    <DataInputType value="4" /> <!-- Cada una de las tareas del plan. Objetos de tipo TaskContextObject.           -->
    <ReportClass value="0" />   <!-- Cuando el origen de datos sea un informe nativo del sistema (DataInputType=0) -->
    <EnableAggregationStep value="1" />
    <Parent value="0" valueRef="" />
    
  <Definition>

     
  <X_Axis >
      <Axis Count="2" >
        <Rows>
          <BIDimension>
            <Name value="Contract" /><ShowName value="Contract" /><Description value="" /><Visible value="True" /><Type valueEnum="refObj" /><Default value="0" /><EnumFamily value="" /><RefClass valueEnum="ContractWorker" />  
            <Expression>
              <![CDATA[ Contract ]]> 
            </Expression>
          </BIDimension>
          <BIDimension>
            <Name value="Worker" /><ShowName value="Worker" /><Description value="" /><Visible value="True" /><Type valueEnum="refObj" /><Default value="0" /><EnumFamily value="" /><RefClass valueEnum="Worker" />  
            <Expression>
              <![CDATA[ Worker ]]> 
            </Expression>
          </BIDimension>          
        </Rows>
      </Axis>
    </X_Axis>
    
  <Y_Axis/>
  
  <!-- Extra calculated input columns -->
    <Input_Axis />
  
  <!-- Inner cell data rows -->
    <Cells >
      <DataCells Count="30" >
        <Rows>
      <BIDataCellDimension>        
        <Name value="Inicio" /><ShowName value="Inicio del perido calculo" /><Description value="" /><Visible value="True" /><Type valueEnum="dateTime" /><Default value="" /><EnumFamily value="" /><RefClass value="0" />
        <EnumAggrFunc value="2" /> <!-- Max -->
        <Expression>
           <![CDATA[ From ]]>
        </Expression>
      </BIDataCellDimension>  
      <BIDataCellDimension>      
        <Name value="Fin" /><ShowName value="Fin del perido calculo" /><Description value="" /><Visible value="True" /><Type valueEnum="dateTime" /><Default value="" /><EnumFamily value="" /><RefClass value="0" />
        <EnumAggrFunc value="2" /> <!-- Max -->
        <Expression>
           <![CDATA[ To ]]>
        </Expression>
      </BIDataCellDimension>    
      <BIDataCellDimension>      
        <Name value="Noche" /><ShowName value="Dias Noche" /><Description value="" /><Visible value="True" /><Type valueEnum="int" /><Default value="" /><EnumFamily value="" /><RefClass value="0" />
        <EnumAggrFunc value="1" /> 
        <Expression>
           <![CDATA[ 
               IfElse (PL_NumPeriods(PL_Intersection(ActSched.PeriodList,  PL_PatternBetweenDates(From, To,"1111111","22-2")))>0 , 1, 0)
           ]]>
        </Expression>
      </BIDataCellDimension>   
      <BIDataCellDimension>      
        <Name value="Tarde" /><ShowName value="Dias Tarde" /><Description value="" /><Visible value="True" /><Type valueEnum="int" /><Default value="" /><EnumFamily value="" /><RefClass value="0" />
        <EnumAggrFunc value="1" />
        <Expression>
           <![CDATA[ 
               IfElse (PL_NumPeriods(PL_Intersection(ActSched.PeriodList,  PL_PatternBetweenDates(From, To,"1111111","22-2")))>0, 0,
                  IfElse (PL_NumPeriods(PL_Intersection(ActSched.PeriodList,  PL_PatternBetweenDates(From, To,"1111111","16-20")))>0 , 1, 0)
               )
           ]]>
        </Expression>
      </BIDataCellDimension>     
      <BIDataCellDimension>      
        <Name value="Manana" /><ShowName value="Dias Mañana" /><Description value="" /><Visible value="True" /><Type valueEnum="int" /><Default value="" /><EnumFamily value="" /><RefClass value="0" />
        <EnumAggrFunc value="1" /> 
        <Expression>
           <![CDATA[
               IfElse (PL_NumPeriods(PL_Intersection(ActSched.PeriodList,  PL_PatternBetweenDates(From, To,"1111111","22-2")))>0 OR 
               PL_NumPeriods(PL_Intersection(ActSched.PeriodList,  PL_PatternBetweenDates(From, To,"1111111","16-20")))>0, 0,
                  IfElse (PL_NumPeriods(PL_Intersection(ActSched.PeriodList,  PL_PatternBetweenDates(From, To,"1111111","8-12")))>0 , 1, 0)
               )
           ]]>
        </Expression>
      </BIDataCellDimension>           
     
        </Rows>
      </DataCells>
    </Cells>

  <!-- From aggregated output columns, additional calculated colums -->
    <Output_Axis >
      <Axis Count="75">
        <Rows>  
          <BIDimension>
            <Name value="Nombre" /><ShowName value="Nombre Completo" /><Description value="" /><Visible value="True" /><Type valueEnum="string" /><Default value="" /> 
              <Expression>
              <![CDATA[ Worker.FullName]]>
              </Expression>
          </BIDimension>  
          <BIDimension>
            <Name value="Name" /><ShowName value="Codigo" /><Description value="" /><Visible value="True" /><Type valueEnum="string" /><Default value="" /> 
              <Expression>
              <![CDATA[ Worker.Name]]>
              </Expression>
          </BIDimension> 
          <BIDimension>
            <Name value="ContractStart" /><ShowName value="ContractStart" /><Description value="" /><Visible value="True" /><Type valueEnum="dateTime" /><Default value="" /> 
              <Expression>
              <![CDATA[ Contract.ContractStart]]>
              </Expression>
          </BIDimension>                     
          <BIDimension>
            <Name value="ContractEnd" /><ShowName value="ContractEnd" /><Description value="" /><Visible value="True" /><Type valueEnum="dateTime" /><Default value="" /> 
              <Expression>
              <![CDATA[ Contract.ContractEnd]]>
              </Expression>
          </BIDimension>  
          <BIDimension>
            <Name value="AdminStart" /><ShowName value="AdminStart" /><Description value="" /><Visible value="True" /><Type valueEnum="dateTime" /><Default value="" /> 
              <Expression>
              <![CDATA[ Contract.AdminStart]]>
              </Expression>
          </BIDimension>                     
          <BIDimension>
            <Name value="AdminEnd" /><ShowName value="AdminEnd" /><Description value="" /><Visible value="True" /><Type valueEnum="dateTime" /><Default value="" /> 
              <Expression>
              <![CDATA[ Contract.AdminEnd]]>
              </Expression>
          </BIDimension>           
          <BIDimension>
            <Name value="PlanArea" /><ShowName value="PlanArea" /><Description value="" /><Visible value="True" /><Type valueEnum="string" /><Default value="" /> 
              <Expression>
              <![CDATA[ Contract.PlanArea.Name]]>
              </Expression>
          </BIDimension> 
          <BIDimension>
            <Name value="Pwork" /><ShowName value="% contrato" /><Description value="" /><Visible value="True" /><Type valueEnum="double" /><Default value="" /> 
              <Expression>
              <![CDATA[ Contract.PWork]]>
              </Expression>
          </BIDimension> 			  
          <BIDimension>
            <Name value="Inicio_Periodo" /><ShowName value="Inicio_Periodo" /><Description value="" /><Visible value="False" /><Type valueEnum="dateTime" /><Default value="" /> 
              <Expression>
              <![CDATA[ IfElse(ContractStart<Inicio, Inicio, ContractStart)]]>
              </Expression>
          </BIDimension>                     
          <BIDimension>
            <Name value="Fin_Periodo" /><ShowName value="Fin_Periodo" /><Description value="" /><Visible value="False" /><Type valueEnum="dateTime" /><Default value="" /> 
              <Expression>
              <![CDATA[IfElse(ContractEnd<Fin, ContractEnd, Fin)]]>
              </Expression>
          </BIDimension>           
          <BIDimension>
            <Name value="CatProfesional" /><ShowName value="Categoria Profesional" /><Description value="" /><Visible value="True" /><Type valueEnum="string" /><Default value="" /> 
              <Expression>
              <![CDATA[ Contract.ProfessionalCategory.Name]]>
              </Expression>
          </BIDimension>  
         
        </Rows>  
      </Axis>
    </Output_Axis>
    </Definition>
  </BIDatacubeModel>    
 </IntContainerVector>

Nº de horas de trabajo por area contractual y categoría profesional

   Area Categoría XXXX (iterador tareas)

Nº de horas de incidencia por area contractual y categoría profesional

   Area Categoría XXXX (iterador tareas)

Los empleados con más de 40h extras en el año en curso

   Empleado XXXX (iterador de empleados)
Was this article helpful?
0 out Of 5 Stars
5 Estrellas 0%
4 Estrellas 0%
3 Estrellas 0%
2 Estrellas 0%
1 Estrellas 0%
5
How can we improve this article?
How Can We Improve This Article?
Etiquetas:

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Contenido