Error accessing Web Analysis data moved using LCM from another environment
Hello,
I exported cube/artifacts using the LCM to another environment and I have modified the Reporting and Analysis data source to connect to the correct database. I have also modified the Database table (HYA_ESS_DB) to connect to the Essbase server. I am able to connect to the Financial Reporting files without any issue but when I am opening any Web Analysis Grid report file I am not able to connect to the database. It is prompting me for the Database Login with username "system". Am I missing something here to modify the database connection?
Thanks,
Yash