Bex Query Designer: Conditional Calculations

[#1]

HI

In BI Bex Query Designer, i want to implement the condition as:

If (On Order Qty < Min Qty) then its should Display 'Not On Order' as a column otherwise should display 'On Order'.

It allows me to put the condition in Calculated KF or Formula in the following format but doesn't allow me to write any characteristic like 'On Order' there.

<logic expression> * <expression1> + (NOT (<logic expression>)) * <expression2>

Pls. let me know if u have its solution.

Thanks...

[Former Member]

closing the thread. Thanks

[Former Member]

This can't be implemented directly in the query designer because a key figure can never hold/display a characteristic value.

You can achieve this through Virtual Characteristic. Please find the following link..

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/b04be008-86cc-2c10-4bad-e517ea3f4c80

[Former Member]

Hi Rakesh, Thanks no doubt its good article and made teh point to you accordingly.

Actually i don't know BADI so can't use the article u mentioned, Can you pls let me know any easier way to solve the issue.

Thanks...

[Former Member]

Hi Harpal,

To my knowledge, I am not aware of any other easy solution for this.

If the amount of data in the cube is less or you do a full load everyday then you can make the changes in the transformation for populating a field based on the Key figure value.

[Former Member]

Yes presently i was doing teh same way. Thanks

[Former Member]

Hi Harpal,

Why dont you display the same this with "1"and "0". You may out the exception as well with "Green" and "Red". In Key Figure heading you may write "1-> Order" and "2 --> "Not on order".

It will take less efforts and will sove the purpose. talk to your user if it works.

Thanks,

S

[Former Member]

Hi S

As u mentioned "In Key Figure heading you may write "1-> Order" and "2 --> "Not on order". it will only change the Column heading and will create 2 columns; one for Order and other for Not on Order.

i dont want this.

Thnx

[Former Member]

Hi,

It will create only one column with values 1 & 0.

On header of key figure you may specify what is 1 and what is 0.

You may highlight 1 and 0 with Red and Gren color.

I hope you got what I am trying to say.

It is a easy work around if user accepts the same.

Thanks,

S