Dear @Gianni Ceresa Can you please suggest the solution?

Dear @Gianni Ceresa , No value return Two methods used, both fail, Used the following functions ---> Method# 1 Fig.1, Applied filter in OBIEE where pV_year is equal to prompt selected year--- actually I wanted to show target of current year and target of the previous year for the same product Method # 2 Fig.2, To get the…

@Gianni Ceresa However I couldn't find the solution of my problem but it is clear now that it is view level , Please guide about the rule, Should I mark this question as correct?

Thanks

Answer

Dear @Gianni Ceresa, @Joel Acha and @Christian Berg Can you please help me?

Thanks for your efforts but this is not the solution of my problem

Dear @Joel Acha Earlier I tried AVG(measure BY month) also calculated manually almost 2 or 3 times but everytime calculation was wrong then I tried AVG(measure) even then value was wrong but when you posted the solution avg(measure by month) then I tried again and calculated and it is working fine ---- I had implemented…

Dear Gianni Thank you very much, problem has been resolved, infact Require fully qualified table names was not enable regards

Dear @Gianni Ceresa As I have already written that both schema has read access on each other but still I am facing same issue moreover I tried following two options * Single Connection pool with two Physical schema (DWH and DWH_Staging) -------- you have suggested this option * Two Connection Pools with single schema (One…