Thanks or the updates. I will take these suggestions and will look into the issue again.

I just created a dummy user (without LDAP) in OBIEE 12c and OAS. --> By using the dummy username and password, I'm able to login the OBIEE 12c Analytics page. -->But I'm Not able to login into the Analytics page in OAS.

Yes. I installed new vanilla. We don't have any problem with Admin users.(They are able to login into the system and able to see the dashboards) The only problem with regular users.

Thanks for your reply. Yes, i'm looking for JDBC connection details. if possible can you please give the exact location of WLS Config.xml file. Thanks again.

Hi Christian, even these changes are also not working for me.

Thank yo so much Joel. Its working.

Thank you so much Gianni Ceresa and Christian Berg . Problem solved. created a new complex join between two tables.

when i am trying same method getting below error message Thanks

I don't have any Fiscal year and month columns in DB. We have only calendar date columns. Is there any work around or logic to convert Calendar year column into Fiscal Year column.