Can BEX boolean formula give text value?

[Former Member]

The logic is:

If quantity > 4, then "Successful", otherwise "failed".

In BEX formula boolean:

(quantity > 4) * "Successful" + (quantity < 4) * "failed".

But somehow we can't find a way of adding the text wording "Successful" or "failed" into the BEX formula window. Any workaround?

Thanks and we will give you reward points!

[Former Member · Accepted solution]

Dear Kelvin,

Do you want to display "successful" or "failed" under a key figure name? That is not possible.

If you are intending to define a characteristic value based on a key figure value, it is not possible in Bex.

You can use excel feature for that.

If use of excel features is not fasible due to dynamic behaviour of workbook, then you can update a new field in your cube by writing field level routine in update rule/transformation.

Regards,

Anup

[Former Member · Accepted solution]

Dear Anup,

Yeh, we want to display "successful" or "failed" under a key figure column.

We know how to do this in backend, but we still want to do that in front end.

I think we can create a workbook and then create an iView based on the created workbook, and then run the workbook through our Portal, that would be doable?

Don't quite understand why you said "is not fasible due to dynamic behaviour of workbook"?

Thanks a lot!

[Former Member · Accepted solution]

Hi Kevin,

Instead of displaying text in the report column you can populate 1 or 0 using a formula or formula variable. Again if you are displaying the report on web you can use the concept of table interface which can replace 1 or 0 with the required text (n BW3.5).

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

[Former Member · Accepted solution]

hi Venkat,

The links you gave us just link to the general SAP BW help website which we can't find any clue to what you suggested by using the concept of table interface which can replace 1 or 0 with the required text (n BW3.5).

[Former Member · Accepted solution]

Hi Kevin,

I am sorry for that. In help, you can find the topics under BEx Web. The topics " Web Design API for Tables" and "Table Interface" under that.

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

[former_member184494 · Accepted solution]

Kevin,

A word of caution on the table interface - if you are looking at a BI7.0 template / query - then this option cannot be used... and if you do use the same - it would mean that these templates cannot be migrated.

Another option - populate your formulae with a 1 or 0 then have conditions with which you can highlight the same and maybe even exceptions / using report designer you can have traffic lights - that could be a substitute for displaying characters...??

My 0.02

Arun

[Former Member · Accepted solution]

hey all,

I think I am going to use workbook and then use macro and then create iView based on the workbook to let users run through Portal.

Thanks!