Skip to Content
0
May 21, 2018 at 09:52 AM

BEx query output columns calculation in Analysis for office

540 Views Last edit May 23, 2018 at 11:15 AM 4 rev

Dear Experts,

I am ABAPer and new to BEx query. My requirement is given below.

BW team will write the BEx query and the output will shown in SAP Analysis for office(AO).

After getting the output from query in AO, there are few fields in output columns which are editable, now the user may edit the output columns, based on the values provided by user in ouptut columns, we need to calculate and display the result in another field or another output column.

Ex:

Here K21 and L21 are editable fields, if user eners the value in these fields we need apply calculation on these and show the output in M21 column.

For above values, K21 ( Full year forecast 2018) = 1000

L21( % Change 2019 ) = 10%

Calculated column M21( & Sales Net sales ) = K21 + L21%K21

= 1000 + 100 = 1100

Please provide solution for this requirement.

Thank you.

Best Regards,

Chinni

Attachments

5yp.png (20.5 kB)