Hola intento hacer una consulta nativa en SQL en Pbi pero tengo un problema, en SQL Dev la consulta está bien . No entiendo por qué ...
escoger
MRA_DM.FACT_GEO_ROUND_VOLUME. DISTRIBUTION_DATE_KEY,
OPERATIONAL_PRODUCT. código
OPERATIONAL_PRODUCT.NAME_FR,
DISTRIBUTION_ROUND. ROUND_NAME,
OPERATIONAL_PRODUCT. APP_SOURCE,
sum( MRA_DM.FACT_GEO_ROUND_VOLUME. EXACT_SUFFIX) como "EXACT_SUFFIX",
sum( MRA_DM.FACT_GEO_ROUND_VOLUME. VENTILATED_PP) como "VENTILATED_PP" ,
sum( MRA_DM.FACT_GEO_ROUND_VOLUME. VENTILATED_STREET) como "VENTILATED_STREET",
sum( MRA_DM.FACT_GEO_ROUND_VOLUME. VENTILATED_AREA) como "VENTILATED_AREA",
MAIL_ACTIVITY_CENTER. POSTAL_LOCATION_CODE,
MAIL_ACTIVITY_CENTER. POSTAL_LOCATION_NAME,
MAILBOX_MRA. ROUND_NAME como ROUND_NAME_MAILBOX
De
MRA_DM.DIM_OPERATIONAL_PRODUCT OPERATIONAL_PRODUCT,
MRA_DM.DIM_DISTRIBUTION_ROUND DISTRIBUTION_ROUND,
MRA_DM.FACT_GEO_ROUND_VOLUME,
MRA_DM.DIM_MAIL_ACTIVITY_CENTER MAIL_ACTIVITY_CENTER,
MRA_DM.DIM_MAILBOX_MRA MAILBOX_MRA
Dónde
(DISTRIBUTION_ROUND. DISTRIBUTION_ROUND_KEY=MRA_DM.FACT_GEO_ROUND_VOLUME. DISTRIBUTION_ROUND_KEY)
y (MAIL_ACTIVITY_CENTER. MAIL_ACTIVITY_CENTER_KEY=MRA_DM.FACT_GEO_ROUND_VOLUME. MAIL_ACTIVITY_CENTER_KEY)
y ( MRA_DM.FACT_GEO_ROUND_VOLUME. MAILBOX_KEY=MAILBOX_MRA. MAILBOX_KEY)
y ( MRA_DM.FACT_GEO_ROUND_VOLUME. OPERATIONAL_PRODUCT_KEY=OPERATIONAL_PRODUCT. OPERATIONAL_PRODUCT_KEY)
y
(
OPERATIONAL_PRODUCT. código en ( 'GF MANU','GF','GF MECA','GF MECA PRIOR','GF MANU PRIOR','CBUNDLE de GF','GF RS','ABO LBL','NF MANU','NF','NF MECA','NF MECA PRIOR','NF MANU PRIOR' )
)
y MRA_DM.FACT_GEO_ROUND_VOLUME. DISTRIBUTION_DATE_KEY = '20210301'
grupo por
MRA_DM.FACT_GEO_ROUND_VOLUME. DISTRIBUTION_DATE_KEY,
OPERATIONAL_PRODUCT. código
OPERATIONAL_PRODUCT.NAME_FR,
DISTRIBUTION_ROUND. ROUND_NAME,
OPERATIONAL_PRODUCT. APP_SOURCE,
MAIL_ACTIVITY_CENTER. POSTAL_LOCATION_CODE,
MAIL_ACTIVITY_CENTER. POSTAL_LOCATION_NAME,
MAILBOX_MRA. ROUND_NAME;
