How to reverse engineer user-role mapping in OBIEE 11g to OBIEE 12C

Question

Fresh OBIEE 12c installation
Migrated  wls-users from existing OBIEE 11g Production to new OBIEE 12c Production 
Migrated RPD & Webcat from existsing OBIEE 11g Test to new OBIEE 12c Production

Then we have everything execpt to user-role mapping.
Since we have about 25 roles and 75 users we would like have  an easy path to get that from existing OBIEE 11g Production to new OBIEE 12c Production

Using the 11g GUI we can only examine one role at the time and display to users belonging to it in a 4 row windows on that page.

That makes it unusable to reverse engineer the current user-role mapping.

Is there a tool for that?
Or in which table(s) is that information present?
Or in which files is that information present?

Your feedback is much appreciated.

Thanks in advance,
Regards,
Srinaath KS

Gianni Ceresa · Answer

So you can now close the thread I guess ...

For now it's still " This question is Not Answered. " and by closing it you will help others with the same / similar needs.

Srinaath Kathirvelu Saroja-Oracle · Answer

Thanks to every one  for your you valuable time and feedback.

Tried the official OBIEE 11g to 12c migration process, but that didn't work.

We used wlst scripts to convert the user-role mapping

Regards,

Srinaath KS

Syedsalmancs110 · Answer

Hello Srinaath,

Did you use OBIEE 11g to 12c migration process? i.e. creation of 11g Export Bundle JAR file and then importing the same into your OBIEE 12c environment, because if you do so then Application Roles along with RPD and Catalog is migrated as well, with catalog groups converted to application roles from OBIEE 12.2.1.1.0 and above.

If your users are in External LDAP then you need to reconfigure the same in OBIEE 12c environment, for Embedded LDAP users you need to migrate them manually as you have already done.

Please refer to below mentioned link for more information on above stated points:

https://docs.oracle.com/middleware/12211/lcm/BIMIG/GUID-D0867450-1AEF-43DE-8144-7816F7105CB1.htm#BIMIG-GUID-D0867450-1AEF-43DE-8144-7816F7105CB1

Thanks and Regards,

Syed Hamd Salman