on 01-21-2020 7:06 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.