Authorization relevant Object as a mandatory prompt Issue in sap bi -webi reporting

[former_member428672]

Hello All,

We have few Auth relevant objects in BW for example company code, plant etc.

so company code is mandatory in couple of reports and other few report it is optional .

is it SAP Best Practise to keep Company code as a Mandatory Prompt wherever it is been used a prompt (as optional prompt ) if not does it make sense to have company code mandatory in few reports and optional in other report?

[kohesco · Accepted solution]

well the authorization info-object will always be active when used in query and assigned roles, whether the prompt is mandatory or optional. I guess it can be set as optional, in case a manager who is allowed to see all data just want to see data from 1 company code.

Great document is:

https://archive.sap.com/documents/docs/DOC-12062

[jerome_penaranda]

Hi,

in general it does not make sense to have mandatory variables on authorization-relevant infoobjects. If users, which are authorized for all data, want to select all data in the report, the easiest way to do this is to leave the variable empty -> no selection means "select all". This would not be possible with a "mandatory" variable.

In case you want the variable to be filled automatically with authorizations, you can use authorization-variables described in the WIKI-page:

https://wiki.scn.sap.com/wiki/x/CxLMFw

Please read the topics "Usage of variables filled by authorizations" and "Usage of authorization variables results in "no authorization" when multi-dimensional authorizations are assigned" in the WIKI-page, in case you decide to use authorization-variables.

best regards,

Jerome

[kohesco]

The option to set variable as mandatory or optional is a case by case matter, select all can be set by default to all company codes for instance

[former_member428672]

@Jerome -

thanks for the reply! we have custom solution implemented, and as per the user requirement we made it as mandatory for few reports. but as per the custom solution - when user click on refresh /f4 it gets the values back from custom dso (loads from ecc based on user auth) and gets filtered the data based on the user , so the user can only see the profit centre or sales org that he has authorised to.

Thanks again!

[jyothirmayee_s]

Hi,

I would say restrict Company Code at BEx query level rather giving an option to select.

Until and unless, you have same business requirement for everyone within Organization.

Thanks,

Jothi