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…

Hi @Joel Acha My mistake I could not explain my reply properly ---- We have two different applications, no link between these two applications * We have Oracle application running in our institute, Emp code is used for login, some parameters are linked with every employee, parameter vary employee to employee --- I can get…

Hi @Gianni Ceresa Actually no one is using OBIEE directly, We have an application (Emp Code is used for login to application), we use webutil to open OBIEE dashboard URL then auto nevigate which hides credentials immediately, we have some employee wise parameters which we can get if we have client terminal name ---- These…

Still working, I shall write the complete steps once completed

Hopefully, I shall update you till monday, currently working

Hi @Christian Berg Thanks for the help, may be I am doing something wrong that's why unable to resolve the issue, After reading documents I did as following --- please highlight where I am wrong and how to use JSON file * Write the command with datamodel.sh which open the file as shown in Fig.1, saved the file in directory…

Hi @Joel Acha Can you share the solution implemented for SSO and Non- SSO for help

As I was told, for OAM and OID separate license is required which some of our clients don't want that's why trying to add other options. Every Client has their own OBIEE environment.

Actually We have multiple clients at different locations with their own infrastructure, some clients may have different requirements that's why our management wants multiple options.

I have already written in this question about document shared by Mr. @Christian Berg about LDAP. This question is slightly different that's why I have posted but if you think I can delete

Thanks, This document is lengthy, needs some time to understand and implementation, I shall update soon