Skip to Content
0

get list of user who are using certain design studio application in BOBJ?

Jun 08, 2017 at 07:40 AM

75

avatar image

Hi CMC Experts,

We need to get the list of user who are using certain design studio application with time of execution and time users is active with dashboard.

We have 41. sp6

Regards

R S

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jun 08, 2017 at 09:40 AM
2

Hi R S - I searched and found Poovin's blog here: https://blogs.sap.com/2014/10/31/auditing-in-sap-design-studio-13/ - have you researched this in your CMC?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy Powlas,

We have configured the auditing and now also uploaded the universe. But my curiosity is more on Repository DB architecture.

Example I have this query, which result Latest Accessed Documents and alerts for the user.

SELECT SI_ID, SI_NAME, SI_RECENT_DOCUMENTS, SI_RECEIVED_ALERTNOTIFICATIONS
FROM CI_SYSTEMOBJECTS WHERE SI_KIND='USER'

Now this query can result me list of user and with last accessed documents. But now still it does not give what I need. I want to see the how frequent the dashboard is used by users.

Now as the DB architecture is black box can not fire the relevant query. I know changes in the above query will give me the my result but when I type like this.

SELECT SI_ID, SI_NAME, SI_RECENT_DOCUMENTS, SI_RECEIVED_ALERTNOTIFICATIONS FROM CI_SYSTEMOBJECTS WHERE SI_KIND='USER' and SI_KIND = 'AAD.AnalysisApplication'

the result is 0 record

And the record for first query is in the attachment.

Regards

Rajender Singh

result.png

result.png (41.9 kB)
0

Rajender - I am going to update this to go the the BI platform primary tag; it seems more of a question for that than Design Studio. I am not familiar with the Query Builder

0
Manikandan Elumalai Jun 14, 2017 at 08:19 PM
0

try to use OR instead of AND between your filters in WHERE condition.

SELECT SI_ID, SI_NAME, SI_RECENT_DOCUMENTS, SI_RECEIVED_ALERTNOTIFICATIONS FROM CI_SYSTEMOBJECTS WHERE SI_KIND='USER' OR SI_KIND = 'AAD.AnalysisApplication'

Share
10 |10000 characters needed characters left characters exceeded