Does BOBJ support OR select statement against SAP BW

[Former Member]

Hello,

We are looking at BOBJ for reporting against SAP BW, and I was wondering if BOBJ supports select OR statements and select AND statements in the same report.

For example.

We have three select parameters:

Company Code

Document Type

Vendor

The business would like to run the following select statements:

Company Code = 1010 AND

Document Type = WE OR

Vendor = 123123

or from the same query, run the report this way:

Company Code = 1010 AND

Document Type = WE AND

Vendor = 123123

Is this possible? If yes, what options do we have.

[IngoH · Accepted solution]

Hi Bill,

there are several options to achieve this:

In the BI Query you have a parameter type that is called "selection option" which allows the end-user to create very complex selection.

In Crystal Reports you can create your own filter / parameters but you would have to pay attention to make sure that the parameters are being send down to the server.

in Web Intelligence / a Universe you could do the same like in CR.

Ingo

[Former Member · Accepted solution]

Hi Ingo,

Thanks for the quick reponse. I just want to confirm that these options are available for SAP BW source systems.

Thanks! Bill

[IngoH · Accepted solution]

Hi,

yes there are options in CR and WebI which means to create custom parameter / filter.

the important part here is to make sure the user is selecting from a list of technical values and not the description of the values because in case the user is sending in "United States of America" instead of "001" (as the key) this might result in a client side filtering

ingo