data selection

[Former Member]

Dear BW Experts,

I've a question on data selection in infopacks.

Is it a fact that routine / variables will override whatever I enter in the 'From Value' / 'To Value' selection fields in the infopack? that is hardcode it.

Is the 'Use conversion routine' check box to activate the use of routine in the selection? How to view the routine to edit? Can selection values (from, to) be controlled to allow strictly certain values only despite manual entering in the selection fields of the infopack?

Basically, can BW be secured like R/3 to field level for all things? How would you secure the data selection when anyone can enter anything in the selection?

Seeking your advice.

regards,

Pascal

[Former Member · Accepted solution]

0 just refers to the constant value under 'From ' and 3 refers to constant selection under'To' . I wanted to give an example for a range and ABAP routine for 2 info objects in the data selection.

[Former Member]

I want to add to what Aneesh wrote. If you have 2 info objects in the data selection tab then we can have the following scenario;

FROM TO TYPE

IO1 7 ( ABAP ROUTINE)

IO2 0 3

What Aneesh mentioned was applicable to one info object, if you want to restirct the load based on 2 different conditions applicable to 2 different info objects , that can be achieved , But for the same info object you can not have 2 options.

[Former Member]

Hi Aneesh, thanks for that.

What's the '0' value for? 7 is for routine, but what is '0' '3' for the 2nd IObj? Could you clarify a little, thanks.

Hope someone could throw a little hint on my posted queries:

1. So, any best way to control access to loading with infopacks when I can input any values to load?

2. If Olap variables are only for reporting, why is it a feature option for use in data selection, i.e input column: 'Type (Variable change to selection values with background processing)'? How can this input field be disabled from change after its set a routine?

3. My R/3 datasource does only supports 'Sel. Opts' value '0'. Does this mean vars / routines cannot be used and only manual entry to the infopack fields is possible for data selection?

Thanks in Advance! Cheers.

Pascal

[Former Member]

At any time, either from/to value or routine or variable can exist. The latest out of the three will exist and others will be deleted off.

Conversion routines are used to ease data entry. For e.g. date is YYYYMMDD but with conversion routine turned on, it is DD.MM.YYYY or MM/DD/YYYY based on user settings. Conversion routine comes from the InfoObject setting. The function modules for conversion routines are CONVERSION_ROUTINE_<Routine Name from InfoObject>_INPUT or _OUTPUT. INPUT come in when user makes an input, i.e. user entry value to internal value and output is the other way around.

When you select Routine in InfoPack, there is a magnifying lens button that becomes active. Click on that to edit routine.

Anyone with authorizations for the InfoSource will have auths to change InfoPack and in turn change selections. Control is not based on data extraction but based on access through queries, which are freely definable in BW.

[Former Member]

Dear Aneesh,

Thanks for your good reply. Points awarded!

So, any best way to control access to loading with infopacks when I can input any values to load?

If Olap variables are only for reporting, why is it a feature option for use in data selection, i.e input column: 'Type (Variable change to selection values with background processing)'? How can this input field be disabled from change after its set a routine?

My R/3 datasource does only supports 'Sel. Opts' value '0'. Does this mean vars / routines cannot be used and only manual entry to the infopack fields is possible for data selection?

Experts can you advice pls.

regards,

Pascal

Message was edited by: Pascal Gabin

Message was edited by: Pascal Gabin

[Former Member]

I'm very keen to find out the answer to Pascal's question too.

[Former Member]

Pascal,

In the source system, you can set which datasource can be extracted to which BW system in SBIW --> General Settings --> Auths

Apart from that authorizations of remote user that BW uses to log into R/3 can have restricted data access.

OLAP Variables can be used in InfoPacks. Once it is set, it cannot be disabled. A user can change it. In the admin workbench control is not that tight as it is assumed that anyone coming in with change auths knows what he/she is doing. You can give a user only display auths to an InfoPack (S_RS_ISOUR with activity as display).

Use of routine, OLAP variable or manual input on BW has no linking to R/3 settings. BW system determines the values for the routine or OLAP variable and passes it through a request IDOC to R/3. For R/3 they are all the same - it just receives and processes a reqeust for data from a datasource with restrictions to data.

Not very clear on what the end result that you are trying to achieve is? Is it to restrict changes to an InfoPack selection screen once set? Unfortunately, anyone who has access to change an InfoPack can change anything. Also without change authorizations, data extract cannot be scheduled.