Hello,
I have an attribute in a master file, but this attribute is not showed in a report's filter section; but wheter i can see it in a chart's filter section.

I need filtering data by this attribute
both in the report and in the chart.

Do you know what can happen?
Thanks.

This message has been edited. Last edited by: SPPC,

Please, at least share your master file.

Hello,
This is the master file code, the attribute is 'PERIODO' under 'DIM_TIEMPO'.
Thanks.

FILENAME=CLUSTER_EJECUCION_PROYECTOS, $
SEGMENT=FCT_EJECUCION_PROYECTOS, CRFILE=DB_SYSTEM_RECOP/MT_DWH/FCT_EJECUCION_PROYECTOS, CRINCLUDE=ALL, $
FIELDNAME=NUMERO_HORAS,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP2, $
FIELDNAME=INFORME_ACTIVIDAD,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP4, $
FIELDNAME=OBSERVACIONES,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP4, $
FIELDNAME=COSTO_HORA,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP1, $
FIELDNAME=COSTO_NIIF,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP1, $
FIELDNAME=NOMBRE_AREA,
WITHIN='*Hierarchy11',
TITLE='Area', $
FIELDNAME=HORAS_FACTURABLES,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP2, $
FIELDNAME=HORAS_PRODUCTIVAS,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP2,
TITLE='Horas Productivas', $
FIELDNAME=HORAS_NO_FACTURABLES,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP2, $
FIELDNAME=HORAS_PROD_NO_FACT,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP2, $
FIELDNAME=HORAS_NO_PRODUCTIVAS,
PROPERTY=MEASURE, MEASURE_GROUP=MEASGRP2, $
DEFINE CostoTotal/D20.2 MISSING ON ALL=COSTO_HORA * NUMERO_HORAS;
TITLE='Costo Total', MEASURE_GROUP=MEASGRP1,
PROPERTY=MEASURE, $
SEGMENT=DIM_CONTRATO, SEGTYPE=KU, PARENT=FCT_EJECUCION_PROYECTOS, CRFILE=DB_SYSTEM_RECOP/MT_DWH/DIM_CONTRATO, CRINCLUDE=ALL, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=FCT_EJECUCION_PROYECTOS.CONTRATO_ID EQ DIM_CONTRATO.CONTRATO_ID;,
DESCRIPTION='DIM_CONTRATO', $
FIELDNAME=CONTRATO_ID,
WITHIN='*DIM_CONTRATO', $
FIELDNAME=NUMERO_CONTRATO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=ANIO_CONTRATO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_GERENTE,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_LINEA,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=DESCRIPCION_LINEA,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_ORIGEN_PROYECTO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_TIPO_SERVICIO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_CONTRATO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=FECHA_CREACION,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=VIGENTE,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=CONTACTO_NOMBRE,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=CONTACTO_TELEFONO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=CONTACTO_EMAIL,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=VALOR,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=CLIENTE_FINAL,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_SUBLINEA,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_LINEA_SUBLINEA,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=DESC_LINEA_SUBLINEA,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=DESC_CONTRATO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_LIDER_TECNICO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=REGISTRA_HORA,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_CONTRATO_SIGLA,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE,
TITLE='Nombre Contrato con Sigla', $
FIELDNAME=SIGLA_NUM_NOMBRE_CONTRATO,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=CONTRATO_NUM,
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
SEGMENT=DIM_EMPLEADO, SEGTYPE=KU, PARENT=FCT_EJECUCION_PROYECTOS, CRFILE=DB_SYSTEM_RECOP/MT_DWH/DIM_EMPLEADO, CRINCLUDE=ALL, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=FCT_EJECUCION_PROYECTOS.EMPLEADO_ID EQ DIM_EMPLEADO.EMPLEADO_ID;, $
FIELDNAME=EMPLEADO_ID,
WITHIN='*DIM_EMPLEADO', $
FIELDNAME=NUMERO_IDENTIFICACION,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=TIPO_DOCUMENTO_DESC,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=ESTADO_LABORAL_DESC,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_LINEA_EMPLEADO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=DESCRIPCION_LINEA,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=APELLIDO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_COMPLETO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=FECHA_INGRESO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=EMAIL,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_AREA,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=RESPONSABLE_AREA,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=REGISTRA_HORAS,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=CIUDAD_EXPEDICION_DOC,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=TIPO_CONTRATO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=FECHA_NACIMIENTO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=CIUDAD_NACIMIENTO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=EDAD,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=TIPO_SANGRE,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=GENERO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=ESTADO_CIVIL,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=EMAIL_PERSONAL,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=DIRECCION_RESIDENCIA,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=CIUDAD_LOCALIDAD_BARRIO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=ESTRATO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=TELEFONO_CELULAR,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=TELEFONO_FIJO,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_ROL,
REFERENCE=DIM_EMPLEADO.EMPLEADO_ID, PROPERTY=ATTRIBUTE, $
SEGMENT=DIM_ACTIVIDAD, SEGTYPE=KU, PARENT=FCT_EJECUCION_PROYECTOS, CRFILE=DB_SYSTEM_RECOP/MT_DWH/DIM_ACTIVIDAD, CRINCLUDE=ALL, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=FCT_EJECUCION_PROYECTOS.ACTIVIDAD_ID EQ DIM_ACTIVIDAD.ACTIVIDAD_ID;, $
FIELDNAME=ACTIVIDAD_ID,
WITHIN='*DIM_ACTIVIDAD', $
FIELDNAME=NOMBRE_ACTIVIDAD,
REFERENCE=DIM_ACTIVIDAD.ACTIVIDAD_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=DESC_CENTRO_COSTO,
REFERENCE=DIM_ACTIVIDAD.ACTIVIDAD_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRODUCTIVA,
REFERENCE=DIM_ACTIVIDAD.ACTIVIDAD_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=FACTURABLE,
REFERENCE=DIM_ACTIVIDAD.ACTIVIDAD_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=ACTIVO,
REFERENCE=DIM_ACTIVIDAD.ACTIVIDAD_ID, PROPERTY=ATTRIBUTE, $
SEGMENT=DIM_CLIENTE, SEGTYPE=KU, PARENT=FCT_EJECUCION_PROYECTOS, CRFILE=DB_SYSTEM_RECOP/MT_DWH/DIM_CLIENTE, CRINCLUDE=ALL, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=FCT_EJECUCION_PROYECTOS.CLIENTE_ID EQ DIM_CLIENTE.CLIENTE_ID;, $
FIELDNAME=CLIENTE_ID,
WITHIN='*DIM_CLIENTE', $
FIELDNAME=TIPO_DOCUMENTO,
REFERENCE=DIM_CLIENTE.CLIENTE_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NUMERO_IDENTIFICACION,
REFERENCE=DIM_CLIENTE.CLIENTE_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=SIGLA,
REFERENCE=DIM_CLIENTE.CLIENTE_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_CLIENTE,
REFERENCE=DIM_CLIENTE.CLIENTE_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=FECHA_CREACION,
REFERENCE=DIM_CLIENTE.CLIENTE_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=SECTOR,
REFERENCE=DIM_CLIENTE.CLIENTE_ID, PROPERTY=ATTRIBUTE, $
DEFINE SIGLA_NUM_CONTRATO/A248V=SIGLA ||'-' || NUMERO_CONTRATO ||'-' || NOMBRE_CONTRATO;
TITLE='Sigla Num Contrato',
REFERENCE=DIM_CONTRATO.CONTRATO_ID, PROPERTY=ATTRIBUTE, $
SEGMENT=DIM_TIEMPO, SEGTYPE=KU, PARENT=FCT_EJECUCION_PROYECTOS, CRFILE=DB_SYSTEM_RECOP/MT_DWH/DIM_TIEMPO, CRINCLUDE=ALL, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=FECHA_EJECUCION EQ FECHA;, $
FIELDNAME=FECHA,
WITHIN=DIM_TIEMPO.SEMANA, $
FIELDNAME=NUMERO_DIA,
REFERENCE=DIM_TIEMPO.FECHA, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_DIA,
REFERENCE=DIM_TIEMPO.FECHA, PROPERTY=ATTRIBUTE, $
FIELDNAME=DIA_SEMANA,
REFERENCE=DIM_TIEMPO.SEMANA, PROPERTY=ATTRIBUTE, $
FIELDNAME=SEMANA,
WITHIN=DIM_TIEMPO.NOMBRE_MES, $
FIELDNAME=NUMERO_MES,
REFERENCE=DIM_TIEMPO.NOMBRE_MES, PROPERTY=ATTRIBUTE, $
FIELDNAME=NOMBRE_MES,
WITHIN=DIM_TIEMPO.ANO, $
FIELDNAME=ANO,
WITHIN='*DIM_TIEMPO', $
FIELDNAME=PERIODO,
REFERENCE=DIM_TIEMPO.NOMBRE_MES, PROPERTY=ATTRIBUTE, $
SEGMENT=DIM_ROL, SEGTYPE=KU, PARENT=FCT_EJECUCION_PROYECTOS, CRFILE=DB_SYSTEM_RECOP/MT_DWH/DIM_ROL, CRINCLUDE=ALL, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=FCT_EJECUCION_PROYECTOS.ROL_ID EQ DIM_ROL.ROL_ID;, $
FIELDNAME=ROL_ID,
WITHIN='*DIM_ROL', $
FIELDNAME=ROL,
REFERENCE=DIM_ROL.ROL_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=NIVEL,
REFERENCE=DIM_ROL.ROL_ID, PROPERTY=ATTRIBUTE, $
DIMENSION=DIM_TIEMPO, CAPTION='Dimensión Tiempo', $
HIERARCHY=DIM_TIEMPO, CAPTION='Tiempo Ejecución', HRY_DIMENSION=DIM_TIEMPO, $
DIMENSION=DIM_EMPLEADO, CAPTION='Dimensión Empleado', $
HIERARCHY=DIM_EMPLEADO, CAPTION='Empleado', HRY_DIMENSION=DIM_EMPLEADO, $
DIMENSION=DIM_CONTRATO, CAPTION='Dimensión Contrato', $
HIERARCHY=DIM_CONTRATO, CAPTION='Contrato', HRY_DIMENSION=DIM_CONTRATO, $
DIMENSION=DIM_ACTIVIDAD, CAPTION='Dimensión Actividad', $
HIERARCHY=DIM_ACTIVIDAD, CAPTION='Actividad', HRY_DIMENSION=DIM_ACTIVIDAD, $
DIMENSION=DIM_CLIENTE, CAPTION='Dimensión Cliente', $
HIERARCHY=DIM_CLIENTE, CAPTION='Cliente', HRY_DIMENSION=DIM_CLIENTE, $
DIMENSION=DIM_ROL, CAPTION='Dimensión Rol', $
HIERARCHY=DIM_ROL, CAPTION='Rol', HRY_DIMENSION=DIM_ROL, $
MEASUREGROUP=MEASGRP1, CAPTION='Costos', $
MEASUREGROUP=MEASGRP2, CAPTION='Horas Ejecutadas', $
MEASUREGROUP=MEASGRP4, CAPTION='Campos Degenerados', $
DIMENSION=Dimension1, CAPTION='Dimensión Perfil', $
HIERARCHY=Hierarchy1, CAPTION='Perfil', HRY_DIMENSION=Dimension1, $
MEASUREGROUP=MEASGRP3, CAPTION='Imprevistos', $
DIMENSION=Dimension11, CAPTION='Dimensión Área', $
HIERARCHY=Hierarchy11, CAPTION='Área', HRY_DIMENSION=Dimension11, $

I can't see anything that seems wrong but it's difficult since we don't have the table definition.

Try using the "Check" feature on the master file.

Right click on master file's name, then select "Check".
You will then have the result of the master file validity.

Maybe an error will be displayed.

Thanks Martin.
This is the check result:

0 NUMBER OF ERRORS= 0
NUMBER OF SEGMENTS= 7 ( REAL= 0 VIRTUAL= 7 )
NUMBER OF FIELDS= 113 INDEXES= 0 FILES= 7
NUMBER OF DEFINES= 4
TOTAL LENGTH OF ALL FIELDS= 5992

Is no there errors.

quote:

PERIODO

Please provide a screenshot of where you are expecting to see the filter for PERIODO? Is this in AppStudio or InfoAssist in the BI Portal?

Do you see other fields in the report's filter section?

To post an image go to FAQ's and scroll to **Post an image.

This might help us get a better understanding of what you see and don't see?

Thank your for participating in the Focal Point Forum.
Tamra Colangelo
Focal Point Moderator

Information Builders

Tamra, it's in AppStudio.
The attribute "periodo" is the only one i can´t see from the filter report, but i can see it from filter chart.
I send you the images.

https://s23.postimg.org/704ilrror/periodo_YES.png
https://s23.postimg.org/704ilrror/periodo_NO.png

Thanks a lot.

SPPC, both link refer to the same image...

By the way, a lot of companies seem to be banning access to image storage sites like postimg and tinypic. Where I work, I can't even access Dropbox or SugarSync.

I now use Cloudinary.com as suggested by GavinL in 2016. It is a commercial tool that probably won't be added to any "bad" site list. It's very powerful, but easy to use and free for the type of things we want to do.

quote:

The attribute "periodo" is the only one i can´t see from the filter report, but i can see it from filter chart.

Both the report and chart are referencing the same exact Master? You don't have two versions of CLUSTER_EJECUCION_PROYECTOS?

Sorry, these are the images links:
https://postimg.org/image/miy045vtx/dc734835/
https://postimg.org/image/cqi26yzax/196233ee/

yes, it's the same master file.
tnks.

Hello Everyone,
I could resolve the issue... although the attribute isn´t visible to chose it, i choose another and then i rewrite the name correct in the filter.
It worked and my data is filtred by this field.

Thanks Everyone.