cancel
Showing results for 
Search instead for 
Did you mean: 

How to extract list of current user list from BO 4.1

former_member546611
Participant
0 Kudos

HI,

We need to create an end user frendily like WEBI report to extract list of current user ID created in BO system.

1. Query builder - But not feasible to ask end users to use this method to extract list of up to date users lists.

2. AUdit DB - this will extarct list of users which are deleted and no longer exist in system

And as per my knowledge ,there is no way to query CMS DB and create a report direclty on it,atleast in BO 4.1 version.

Any suggestions

BO version used :4.1

Thanks!

Regards,

Hetal

Accepted Solutions (0)

Answers (2)

Answers (2)

omkarsambare
Employee
Employee

Hi,

This should help you to setup the CMS Data Access driver.

2369779 - How to unlock the CMS database with new data access driver for BI 4.2 SP3 [VIDEO] https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+B...

Regards,

Omkar

former_member693044
Discoverer
0 Kudos

if you click on that URL it says coming soon....what is this kind of service:(

denis_konovalov
Active Contributor
0 Kudos

displays page just fine for me.

bjorn_eriksson
Participant

Hi

IF you patch up to BI 4.2 SP3 and above, you will get a CMS Data Access driver.
You can then install predefined BI on BI universe, and build a webireport towards your CMC-data.

So, you need to upgrade your system 🙂

Good luck

/Björn