Forum Discussion

Vanessa250919's avatar
Vanessa250919
Icon for Helper V rankHelper V
5 years ago
Solved

Oracle: ORA-00911 PowerBI Native Query SQL

Hello I try to make a native query in SQL in Pbi but I have one issue, in SQL Dev the query is ok . I don't understnd why ... 

 


SELECT
MRA_DM.FACT_GEO_ROUND_VOLUME.DISTRIBUTION_DATE_KEY,
  OPERATIONAL_PRODUCT.CODE,
  OPERATIONAL_PRODUCT.NAME_FR,
  DISTRIBUTION_ROUND.ROUND_NAME,
  OPERATIONAL_PRODUCT.APP_SOURCE,
  sum( MRA_DM.FACT_GEO_ROUND_VOLUME.EXACT_SUFFIX ) AS "EXACT_SUFFIX",
  sum( MRA_DM.FACT_GEO_ROUND_VOLUME.VENTILATED_PP ) AS  "VENTILATED_PP" ,
  sum( MRA_DM.FACT_GEO_ROUND_VOLUME.VENTILATED_STREET ) AS "VENTILATED_STREET",
  sum( MRA_DM.FACT_GEO_ROUND_VOLUME.VENTILATED_AREA ) AS "VENTILATED_AREA",
  MAIL_ACTIVITY_CENTER.POSTAL_LOCATION_CODE,
  MAIL_ACTIVITY_CENTER.POSTAL_LOCATION_NAME,
  MAILBOX_MRA.ROUND_NAME AS ROUND_NAME_MAILBOX

FROM

  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
WHERE
  ( DISTRIBUTION_ROUND.DISTRIBUTION_ROUND_KEY=MRA_DM.FACT_GEO_ROUND_VOLUME.DISTRIBUTION_ROUND_KEY  )
  AND  ( MAIL_ACTIVITY_CENTER.MAIL_ACTIVITY_CENTER_KEY=MRA_DM.FACT_GEO_ROUND_VOLUME.MAIL_ACTIVITY_CENTER_KEY  )
  AND  ( MRA_DM.FACT_GEO_ROUND_VOLUME.MAILBOX_KEY=MAILBOX_MRA.MAILBOX_KEY  )
  AND  ( MRA_DM.FACT_GEO_ROUND_VOLUME.OPERATIONAL_PRODUCT_KEY=OPERATIONAL_PRODUCT.OPERATIONAL_PRODUCT_KEY  )
  AND  
  (
   OPERATIONAL_PRODUCT.CODE  IN  ( 'GF MANU','GF','GF MECA','GF MECA PRIOR','GF MANU PRIOR','GF CBUNDLE','GF RS','ABO LBL','NF MANU','NF','NF MECA','NF MECA PRIOR','NF MANU PRIOR'  )
)

AND MRA_DM.FACT_GEO_ROUND_VOLUME.DISTRIBUTION_DATE_KEY = '20210301'
GROUP BY

MRA_DM.FACT_GEO_ROUND_VOLUME.DISTRIBUTION_DATE_KEY,
  OPERATIONAL_PRODUCT.CODE, 
  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;


Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Vanessa250919 , I am assuming you are using this advanced editor of connection?

     

    will it possible to get the query from oracle history what query was fired, this one seems fine, can be some character set conversion issue

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Vanessa250919 , I am assuming you are using this advanced editor of connection?

     

    will it possible to get the query from oracle history what query was fired, this one seems fine, can be some character set conversion issue