BEx Related Query

[Former Member]

Hi All,

I am new to BEX & I would like to create a new Key Figure "Total_GL_Amount" in Query Output with following expression:

(Account_type = 'S') * 0 + (Account_type <> 'S')* GL_Amount

Where Account_type is characteristic & GL_Amount is Key figure.

Please suggest what I have to do it.

[FCI · Accepted solution]

GL_Amount is a KF. It is then available for any calculated KF.

To make the Account_type available, just create a formula variable (type replacement path).

Regards,

Frederic

[Former Member · Accepted solution]

Thank you Frédéric Cincet....

I have one more doubt regarding Formula Variable.

Account_Type have Alphabetic values. Can Formula Variable return a char value like S, K, N, D etc. If not how I am going to write following expression in calculated KF.

(Account_type = 'S') * 0 + (Account_type <> 'S')* GL_Amount

[FCI · Accepted solution]

Yes, char types are supported by formula variable.

Note that Koen Hesters gave you another interesting possibility (use a restricted KF rather than a calculated one).

[Former Member · Accepted solution]

Hi Cincet,

I have a doubt that how we can create a expression in Restricted Keyfigure.

[FCI · Accepted solution]

Well, you can't. But the expression you want is equivalent to a restricted kf on gl_amount with all account types excluding the S.