Hi Experts,
I am a BW Consultant working on Portal & Visual Composer (7.0)
As a Developer i got SAP_ALL & SAP_J2EE_ADMIN roles in BW and System Admin and VC role in Portal.
In Portal Created/Published iviews for BW Queries (Transaction) and Published them to a role (role1) in portal.
In Visual Composer i developed Dashboard reports on BW Queries ,made them public and deployed them to a portal role(role 1) in portal.
I assigned portal role to my self and tested the queries and dashboards in portal everything is working perfectly.
In VC i can see 3 different systems defined in Portal
I created a Test user (with profile of end user) in BW,Testuser is authorised to view all the reports in BW and All data in all data targets and in portal testuser is assigned with Role1 and VC Role.
(Note: In BW Testuser doesn't had J2EE_ADMIN role).
Portal:
When i login to portal as testuser and tries to execute the BW Queries (Transaction) and it working perfectly.
When i tried to execute Dashboard reports developed in Visual Composer it gives me an error
"Failed to connect backend system.Check your system definition and user priviliges"
In Visual Composer i logged in as testuser (as test user got VC role assigned) i can't see any list of avaliable systems under "Find Data"
When i modified testuser profile in BW and updated with SAP_J2EE_ADMIN then i can execute the dashboard report but at the same time testuser got more than what he should have like user admin,system admin...etc
I searched the sdn and find some similar threads ...but nothing was useful
Please update me what went wrong and how to fix this...
Thanks in advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.