BFC users last logon

[Olj]

Hello,

The customer asked for some report of SAP Financial Consolidation 10 and Intercompany 10

How to generate a report that shows user's last logons dates? Like in NetWeaver RSUSR200 transaction.

BFC  authenticated through BOE (BI).

[Marc_Kuipers · Accepted solution]

Hi Daulet,

This is more a question for the BOE forum.

Anyway, there is 'audit' functionality in BOE, there is a short overview here:

Auditing I: How to enable audits logging in BOE XI 3.1 « HOW TO Business Intelligence

Thanks

Marc

http://howtobi.wordpress.com/2010/10/18/how-to-enable-audits-logging-in-boe-xi-3-1/

Message was edited by: Marc Kuipers

[Olj · Accepted solution]

Thanks Marc,

I had found 2 ways to resolve this problem:

1. Run this script in Query Builder:

SELECT TOP 3000

SI_NAME

,SI_LASTLOGONTIME

FROM

CI_SystemObjects

WHERE

SI_KIND = 'User' ORDER BY

SI_NAME

2. Note -  https://service.sap.com/sap/support/notes/1357608

But this note for BOE XI 3.1,    we use BI 4.0 sp7 and I can't  make report form that note,  I can't  find "Public folders --> Auditor".  Can you help me?

[Marc_Kuipers · Accepted solution]

Hello Daulet,

Sorry, I am not that familiar with BOE

I suggest you post your previous update on

Thanks

Marc

[Former Member · Accepted solution]

Hi Daulet,

Audit DB struture and reports are changed in BI4.0.

Default audit reports  will not be deployed with the instaltion.

we need to deploy it manullay to have the login and logoff details and some other report details.

Please check the below thread to have the details

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/40711187-04e8-2d10-d190-851e20c7665a

http://scn.sap.com/community/bi-platform/blog/2013/01/07/sap-businessobjects-40-auditor-configuratio...

Message was edited by: David Metser

[Olj · Accepted solution]

Thanks Prasad...

[Former Member · Accepted solution]

Good to hear! Would you mind marking one as the answer so this thread is closed?