Jun 22, 2012 at 10:03 PM

Report of Security: teams to which a user belongs

27 Views

Hello experts,

I have installed SAP BPC 7.5 NW SP07 with Excel 2007. I need a report that show me all teams to which a user belongs.

By example. In the Admin Console->Security , I have configured that my user USER1 belongs team ENT001, ENT002, ENT003 y ENT008 and USER3 blelongs ENT002, ENT004, ENT008

I need a report with this structure

USER ENT001 ENT002 ENT003 ENT004 ENT005 ENT006 ENT007 ENT008

USER1 x x x

USER2 x x x

........

and so on.

I know that exist a report in Audit Reports - BPC Web - but this one, when I have exported to Excel doesnt show team´s name and the most important, I´d like to do it in a report, in Excel client.

And asking for more, member access profile and task access profile too.

Summary: user that teams belongs, that member access profiles belongs and task access profile too.

Thanks

Best regards

Gustavo