Visões dinâmicas - Waapi
Las vistas dinámicas son características de XPlatform que permiten consultar y exportar datos en forma de informes.
Estos datos pueden ser usados también para construir una visión gerencial personalizada, usando el Analytics Studio.
Usar las visiones dinámicas para emitir reportes
Los datos son agrupados por visiones (views), siendo que cada visión sirve para buscar tipos diferentes de informaciones.
Las visiones pueden ser seleccionadas en la pantalla de registro de las visiones dinámicas, en:
- Tecnología > Customización > Reportes > Visiones dinámicas
Después de seleccionarlos,
También es posible automatizar la ejecución de esos reportes, haciendo clic en Programar Ejecución. La programación permite seleccionar el formato deseado (PDF, XLS, entre otros) y la forma de entrega (vía notificación de la plataforma o por e-mail).
Para aprender todo lo que puede hacer con las vistas, visite la documentación de Vistas dinámicas en el manual. XPlatform .
Usar los datos de las visiones con el Analytics Studio
El Analytics Studio permite cruzar las informaciones contenidas en las tablas de las visiones, con la finalidad de crear gráficos y visiones gerenciales de esas informaciones. Esta herramienta auxilia en el análisis de los datos y en la tomada de decisión.
Para aprender a hacer referencias cruzadas de esta información y crear gráficos, acceda a la documentación de Analytics Studio en el manual de Analytics. XPlatform .
Views disponíveis para o Waapi
Serviço: hcm-happiness_index
Índice de felicidad (v_happiness_index)
Informações de humor registradas pelos colaboradores no Diário de humor do Waapi.
Campos que se pueden mostrar
| Nombre traducido (editor visual) | Nombre en base (Editor SQL) | Campo-chave Campos-chave são aqueles que podem ser usados para fazer a ligação entre as tabelas da visão dinâmica |
|---|---|---|
| Identificador de departamento | id_departamento | |
| cita de sentimiento | fecha_estado de ánimo | |
| Filtrar por fecha | estado de ánimo_filtro_fecha | |
| Sentimiento (enumeración) | estado de ánimo_enum | |
| Sentimiento (descripción) | descripción_estado de ánimo | |
| notas de sentimiento | notas_de_estado de ánimo | |
| Razones del sentimiento | descripción_razón | |
| Filtro de jerarquía | filtro_jerarquía |
Criar visões gerenciais do Waapi
Usando recursos deEstudio de análisis, puede crear un panel de administración convisiones para gerentes EsProfesionales de RRHH monitorear el estado de ánimo de los empleados de la empresa.
Con esto es posible obtener resultados como este:
Cómo crear Landing Pages para la visión de gestión
- Usando as consultas (queries) sugeridas abaixo, crie conjuntos de dados (datasets) na XPlatform. Para criar os datasets:
- Acesse o menu na XPlatform: Tecnologia > Administração > Dataset > Novo dataset
- Clique em Editor SQL.
- Para cada query: copie o código abaixo, cole no editor e clique em Salvar.
- Crie widgets usando os datasets que foram criados no passo anterior, em: Tecnologia > Customização > Analytics Studio > Novo widget analytics.
Esses widgets ficarão disponíveis para serem selecionados como componentes no passo seguinte. - Por fim, crie as páginas contendo os widgets do passo anterior, em Tecnologia > Customização > Páginas > Nova página.
Diario de humor - vista de recursos humanos
select d.code as "Código do departamento", d.name as "Nome do departamento", hi.mood_date as "Data do sentimento", hi.mood_description as "Sentimento", hi.mood_notes as "Notas do sentimento", hi.reason_description "Razões do Sentimento" from "hcm-happiness_index".v_happiness_index hi, "hcm-report".v_department d where hi.department_id = d.id group by d.code, d.name, hi.mood_date, hi.mood_description, hi.mood_notes, hi.department_id, hi.mood_date_filter, hi.reason_description order by hi.department_id, hi.mood_date_filter |
Diario de humor - Vista de recursos humanos (mes actual)
select d.code as "Código do departamento", d.name as "Nome do departamento", hi.mood_date as "Data do sentimento", hi.mood_description as "Sentimento", hi.mood_notes as "Notas do sentimento", hi.reason_description "Razões do Sentimento" from "hcm-happiness_index".v_happiness_index hi, "hcm-report".v_department d where hi.department_id = d.id and hi.mood_date_filter >= :FIRST_DATE_MONTH and hi.mood_date_filter <= :LAST_DATE_MONTH group by d.code, d.name, hi.mood_date, hi.mood_description, hi.mood_notes, hi.department_id, hi.mood_date_filter, hi.reason_description order by hi.department_id, hi.mood_date_filter |
Quantidade de sentimentos - Visão do RH
select hi.mood_description as "sentimento", extract(month from hi.mood_date_filter) || '/' || extract(year from hi.mood_date_filter) as "mês sentimento", count(*) as "quantidade" from "hcm-happiness_index".v_happiness_index hi, "hcm-report".v_department d where hi.department_id = d.id group by extract(month from hi.mood_date_filter), extract(year from hi.mood_date_filter), hi.mood_description order by extract(month from hi.mood_date_filter); |
Quantidade de sentimentos por mês - Visão do RH
select hi.mood_description as "sentimento", extract(month from hi.mood_date_filter) || '/' || extract(year from hi.mood_date_filter) as "mês sentimento", count(*) as "quantidade" from "hcm-happiness_index".v_happiness_index hi, "hcm-report".v_department d where hi.mood_date_filter >= :first_date_month and hi.mood_date_filter <= :last_date_month and hi.department_id = d.id group by extract(month from hi.mood_date_filter), extract(year from hi.mood_date_filter), hi.mood_description order by extract(month from hi.mood_date_filter); |
Diario de humor: visión del gerente (todos los empleados)
select d.code as "Código do departamento", d.name as "Nome do departamento", hi.mood_date as "Data do sentimento", hi.mood_description as "Sentimento", hi.mood_notes as "Notas do sentimento", hi.reason_description "Razões do Sentimento" from "hcm-happiness_index".v_happiness_index hi, "hcm-report".v_department d where hi.department_id = d.id and hi.hierarchy_filter like :hcm.analytics.descendantsFilter.string group by d.code, d.name, hi.mood_date, hi.mood_description, hi.mood_notes, hi.department_id, hi.mood_date_filter, hi.reason_description order by hi.department_id, hi.mood_date_filter |
Diario de humor: vista del gerente (todos los empleados [mes actual])
select d.code as "Código do departamento", d.name as "Nome do departamento", hi.mood_date as "Data do sentimento", hi.mood_description as "Sentimento", hi.mood_notes as "Notas do sentimento", hi.reason_description "Razões do Sentimento" from "hcm-happiness_index".v_happiness_index hi, "hcm-report".v_department d where hi.department_id = d.id and hi.hierarchy_filter like :hcm.analytics.descendantsFilter.string and hi.mood_date_filter >= :FIRST_DATE_MONTH and hi.mood_date_filter <= :LAST_DATE_MONTH group by d.code, d.name, hi.mood_date, hi.mood_description, hi.mood_notes, hi.department_id, hi.mood_date_filter, hi.reason_description order by hi.department_id, hi.mood_date_filter |
Quantidade de sentimentos - Visão do gestor
select hi.mood_description as "sentimento", extract(month from hi.mood_date_filter) || '/' || extract(year from hi.mood_date_filter) as "mês sentimento", count(*) as "quantidade" from "hcm-happiness_index".v_happiness_index hi, "hcm-report".v_department d where hi.department_id = d.id and hi.hierarchy_filter like :hcm.analytics.descendantsfilter.string group by extract(month from hi.mood_date_filter), extract(year from hi.mood_date_filter), hi.mood_description order by extract(month from hi.mood_date_filter); |
Quantidade de sentimentos por mês - Visão do gestor
select hi.mood_description as "sentimento", extract(month from hi.mood_date_filter) || '/' || extract(year from hi.mood_date_filter) as "mês sentimento", count(*) as "quantidade" from "hcm-happiness_index".v_happiness_index hi, "hcm-report".v_department d where hi.mood_date_filter >= :first_date_month and hi.mood_date_filter <= :last_date_month and hi.department_id = d.id and hi.hierarchy_filter like :hcm.analytics.descendantsfilter.string group by extract(month from hi.mood_date_filter), extract(year from hi.mood_date_filter), hi.mood_description order by extract(month from hi.mood_date_filter); |
Para conocer más detalles sobre este procedimiento, o si tiene dificultades para crear la vista de gestión, consulte eltutorial disponible en la documentación de Analytics Studio.
English
Español
