Webi Bypassing BEx Authorization Variable with SAP Exit

[Former Member]

BEx query has Hierarchy Node Variable with Authorization as processing type. Its set as User Input ready

When the Webi report is refreshed, the LoVs appear as per the Authorization. However, if user doesn't select any value (pushes from right to left in variable screen) he gets NOT_AUTHORIZED error. Which is not intended, it should check the authorization in the background via SAP exit and populate the result. This is how it runs inBEx query.

However, in Webi it's giving NOT_AUTHORIZED error? This is how the product is designed to work or is it a bug.

I see several forum threads and SAP KBAs/notes but they are not answering my question. Could anyone please help.

I am ready to provide more details on this error.

Thanks,

Tilak

[IngoH]

Hi,

this is how authorization variable would work in any of the clients and not just Web Intelligence.

You created an authorization variable which is configured as "read for input", so the user is getting prompted.

So In Web Intelligence the LoV shows up.

if the user does not select a value, then you are not sending a value, so you basically asking for all data and you are not allowed to see all data and therefore you are getting the message "no authorization".

if you are making authorization variables as ready for input then the user needs to select the proper values - regardless of the BI tool.

if you want the authorization to be check in the background then the authorization variable should be configured to not have ready for input.

regards

Ingo Hilgefort

[Former Member]

Hi Ingo,

Sorry i forgot to specify that The authorization variable is set as an Optional.

So, if the user don't select any value then Webi should filter the data in the background as per the user's entitlement. That's what now it happens in BEx.

But why does this fail in Webi? Is Webi not able to pass the Authorization event to BEx if user don't select any?

Thanks,

Tilak

[IngoH]

Hello Tilak,

that is not how BI Authorizations in BW Work.

BI Authorizations are not acting as an automatic filter. That is the role of the Authorization Variable.

So when you define the variable as optional and do not provide a value - that means you basically asking for all the data.

so when you ask for all the data with BI Authorization specified you will get the "no authorization" value because it doesn't match up.

and in BEx it would happen exactly in the same way if you do the same workflow.

If you want the data to be filtered using an Authorization variable then either you remove the "ready for input" option or you specify the values when running the report.

regards

Ingo Hilgefort

[Former Member]

Hi Ingo,

In BEx it returns the relevant data filted as per the user's authorization even when he doesn't select any value from the prompt screen.

I was thinking, Webi should behave similar.

Thanks,

Tilak

[IngoH]

Hi Tilak,

the details on how it works are in my previous response.

regards

Ingo Hilgefort

[Former Member]

Hi Ingo,

Thanks for the clear response on Bex Auth variable. My scenario , Iam using BEx--BICS --BIWS--Dashboard. We have the Auth variable but if i remove ready for input, it is saying that it would effect all the other queries. How do i create a duplicate Auth variable and will it work with BIWS?

Thanks

[IngoH]

Hello Abdhi,

if you change a variable in BEx - yes that can have impact on other BEx queries as those might use the variable as well.

You could simple create a new BEx variable with the same settings and then change those settings to what you need.

regards

Ingo Hilgefort, SAP