Actually I bypass calling webservice by adding the intermediate table between HR system and BI, any change in HR service will update the table and we read them from that. We set session value in Administration tool and use it in prompt section by using SQL Result About "Reports" you are completely correct.

Hi Guys Actually I reach to this architect to use shared table between our HR system and BI and use session_variable to handle it. Any idea and notes about that ? regards

Dear Joel Dear Christian Dear Gianni Thank you so much for your reply I could summed up the solutions are use SSO as Joel mention (https://blogs.oracle.com/cealteam/obiee-12c%3a-configuring-kerberos-sso-for-obiee-12c ), using database authorizing as Gianni said…

Gianni, any suggestion for external authorization ?

Actually I needed some external resource and permission from my organization to handle with programming! But I think I should go through this solution

Joel, any suggestion how does handle externally security manager and integration with OBIEE SSO ?

The answer is 'Yes'. Imaging you are going to develop reports for board of director members ,so you create user manually in internal OBIEE LDAP, then some of them wanted to change their password ! And other same scenarios that need to create user manually in Realm and facing change password issue.

We should add "APPS_LIBRARY_FOLDER_LOCAL" property on xmlp-server-config.xml file

Thanks Christian for reply But I have seen so many installation video which install OBIEE 12c on Windows operation system. So NOT supported seems not surely cannot install 12c on Windows OS.Meanwhile I have installed WLS 12c and fmw infrastructure 12c on the same machine , Mostly I want to know how to debug that IS there…

Oracle Business Intelligence 12.2.1.0.0 Oracle BI Administrator Tools 12.2.1.0.0

I solved the problem, hope this post help every body else face this issue. Duplicate definition error in importing mete-data objects in Oracle BI administrator tools The problem was Data Source connection type. I changed connection type from ODBC 3.5 to OCI 10g/11g . But may you want to know how to fill "Data Source Name",…

Thanks Gianni, that tip was helpful and I solved my problem