Rajesh Gurram - BI — Oracle Analytics

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Rajesh Gurram - BI Rank 1 - Community Starter

Comments

  • Debug yourself by taking the sql generated and run on a database client tool to find the root cause. Another way to debug on OBIEE side is by taking a copy of the union report and take the individual criterias as separate reports and check if the year is passed or not.
  • Since BI is creating two sqls but the join coditions between BI_DS_ELECTRIC_NO_GAS and BI_CALENDAR_VIEW are different, you may want to run the sql using any client tool like Toad and identify the correct join and then make sure you use the same join format in physical join between these two tables.
  • I see that there are two physical queries fired for this report and the difference I see in the two queries have different LA/SA start and end date filters that you may want to verify?