HANA to Analysis for office 2.6 reporting user authorization error

[former_member211603]

Hi Friends,

We have totally new dataflow and reports. When we submitted Analysis for workbook report to users, for execution they got authorization error as no authorization are created or assigned to users and I need help regarding same.

All modeling is in HANA studio, Bex query designer and analysis for office 2.6, we are not using RSA1 in BW 7.4.

Data flow: In HANA studio we have HANA calculation views created on columnar tables -> Only one calculation view assigned to composite provider as union (there are no navigation attributes as it has only table fields) -> On Composite provider we built set of queries -> Analysis for office 2.6 report where all queries are displayed.

For checking user authorization error, I went into RSECADMIN and executed by user ID, one bex query and selected display log, but it does not generate any log. So not sure what error it is giving. Can you please suggest what authorizations need to be built from scratch. Since no display log was there, I did SU53 in same no authorization error screen and got below:

[TammyPowlas · Accepted solution]

Hello - the SU53 is not the best way to determine authorization error. Please have your BW security admin run an STAUTHTRACE on the workflow to determine missing authorizations.

[former_member211603]

Hi Tammy,

There is an issue with user authorizations. We have assigned relevant authorizations to user. Thank You.