BW Custome Report for BPC Security Roles

[former_member394086]

Hi Experts,

I have client requirement to develop repor for which input criteria will be

1. Environment

2. User

Radio Button

1. BPC Roles

2 BW Roles.

i can fetch all the details from table UJE_TEAM_AGR , UJE_PROFILE_AGR & UJE_USER_AGR and for BW roles AGR_USERS. But the biggest challenge is how to set reletion with user and APPSET_ID i.e. environment. There is no table in BPC which will have both user and environment field. Can someone help me if any such table is there where i will find both the fields.

Regards

Parag

[Former Member]

Hi Parag,

Please check the table UJE_USER_TEAM if it solves your purpose. This links user id, team id and Environment.

Bindu

[former_member186338]

Hi Bindu,

As far as I remember UJE_USER_TEAM is the table relevant only for BPC 7.5, but not for 10...

Vadim

[former_member230848]

Hi Experts,

I am also  facing the same issue ,my user is asking to create BPC roles in bw as per Environment & User,but how to configure these  setting while creating user roles in BPC to BW.

I am able to get BW roles  but it couldn't show BPC roles  with BW roles while selecting BPC report criteria.

Thank you

r's

Sun

[Former Member]

Thanks Vadim for the correction.

Hi Parag, Please have a look at the methods of classes like CL_UJE_TEAM, CL_UJE_USER etc., for the required links.

Bindu