User exit help?

[Former Member]

I need a user exit which will be executed before the variable pop up screen appears at BEX Reporting level. This issue is kind of related to SAP BI Reporting.

So for doing this I need a user exit at BEX Reporting level which will get executed and check a table.

All the Infoproviders which use company code are maintained in this table. This user exit should check that table and find if the Infoprovider which we are currently accessing is available in that table.

Exact requirement can be found below:

I have a situation where data is maintained in an Infocube. We have 2 reporting units like Company1, Company2. Company1 should not be able to see the data of the Company2 and vice versa. Reporting at BEX level is not done by us, client have their own people who will be taking care of reporting. All I need to do is provide concerned data to each company at the cube level itself. For this we are creating authorization for particular user at company code level. So for this we need to write a user exit which will execute and check if the infoprovider we are using is existing in that table. If existing it should pop up message to select the variable with authorization which is created on company code.

[brian_keenan]

Use transaction SMOD with RSR00001

This has FM EXIT_SAPLRRS0_001

This function module is called from the BEX query, and has the follow data to code with, from here it should be straight forward,

I_VNAM LIKE RSZGLOBV-VNAM Name of Variable to be Replaced

I_VARTYP LIKE RSZGLOBV-VARTYP Variable Type

I_IOBJNM LIKE RSZGLOBV-IOBJNM InfoObject that the Variable Refers to

I_S_COB_PRO TYPE RSD_S_COB_PRO InfoObject Properties

I_S_RKB1D TYPE RSR_S_RKB1D Query Reporting Attribute

I_PERIV TYPE RRO01_S_RKB1F-PERIV Query Definition Attribute

I_T_VAR_RANGE TYPE RRS0_T_VAR_RANGE

I_STEP TYPE I 0

[Former Member]

Hi,

What you have mentioned in previous post is related to Variable Exit.

Once we know about the variable name only, we can use that particular exit.

But in our Scenario, we dont know the Variable name and we want to force the user to use the particular variable in that report.

Here, user is having an Authorization to create their own report in BEX query and they are having a freedom to create their own variables.

What we are trying to do is we are trying to restrict the user to execute the report without the particular variable which we created as Authorization variable.

I hope you understood my requirement.