And even I have deleted Adminserver.lok file under tmp folder of Adminserver.

Hi Gianni Ceresa There was a problem in config.xml file. I corrected it. But after that am getting issue in starting managed server. Am getting this error booting as admin server, but servername, bi_server1, does not match the admin server name. For this I have set the environment variable by running ./setWLSEnv.cmd from…

Hi Gianni Ceresa Thanks for your fast response. I was doing host name update. Yeah I have changed hostname in the config file too. I was following this document. https://advansit.files.wordpress.com/2014/06/obiee-db-server-and-port-change-document.pdf After following this I have end up with this problem. I followed all…

Hi FTisiot Thank for your reply. To be honest I was knowing these steps. The problem am facing is how I can write a query in Init Block to join two dim tables. Am planning of Factless fact here. Don't know exactly. Let me check all the possible options and let you guys know the update on the same.

Hi Thomas Dodds Thanks for your reply. I am not asking about the prompt filtering here. The requirement is something like that. User is responsible to look at Departments with selected regions only.

Hi FTisiot As per your suggestion I have created a new role and a group for this user. After that in administrator tool I have opened that application role. Now can you tell me where exactly I have to specify the filter for the above requirement. If you can tell me with one example it will be of great helpful for me.

Hi FTisiot, Thanks for your reply * Create a table with all Department-Region combination for each user Achieving this as of now is bit difficult since all DW implementation is already completed and most of the reports are using these tables. So is there any way to achieve apart from this?

Hi Thomas, I got your point and even I have implemented till date like that only using permissions. But here the requirement/situation is different, like One particular user should have access to two departments with different regions(one department with all regions and one department with only one region). The user is…

Hi Thomas, No. I am using only one fact as of now for the requirement in the report. If you know how to implement the security on the above scenario please help me out with the steps. Suppose if I use more than one fact how will it impact the design?

Hi Christian, Thanks for your help. Please help me out with steps to achieve that. Am not aware of how to do implement with the method you mentioned here.

Hi Ceresa, Thanks for your reply. Can you please tell me the exact steps required to achieve this.