I successfully integrated the EBS-SSO and the user are able to login into EBS and also to OBIEE without relogging in. But once the user comes to Dashboards the page gives View Display Errors.
Created equivalent Resposibility in OBIEE(Test_Role)
Provided access to One of the Dashboards in OBIEE
Provided access to role to the subject area
Still the user is able to see some pages with data without any issues and some of the pages give view display error .Any inputs to resovle the issue is high appreciated.. Thanks
View Display Error
Error getting drill information: SELECT "Purchasing Organization"."Purchasing Organization Name" saw_0, Fact."PO Amount" saw_1, Fact."Non-Agreement Purchase Amount" saw_2, Fact."Agreement Leakage Amount" saw_3, Fact."Best Price Leakage Impact" saw_4 FROM "Procurement and Spend - Purchase Orders" WHERE (Time."Year" = '2012')
Check for column and subject area from where it is giving results..I believe some subject area needs still permission in RPD.
Click on Subject area and add your App Role to it..Then check once again by logging out and loggin in.
Mark Correct if it answers else helpful.