Skip to Content
0
Former Member
Mar 27, 2014 at 01:37 PM

WEBi reporting requirement

139 Views

Hello All,

I am stuck with one WEBi requirement. The requirement is as follows. I will try to make it simple.

I have one BEx query from which i am getting data Cost Center (0COSTCENTER) & Actuals which i am displaying in WEBi report.

For example BEx 1:

CC1 100

CC2 200

CC3 300

CC4 400

I have another BEx Query which shows data as Sales Organization and actuals .

For example BEx 2

SO 1000

Now in WEBi i want to do a calculation as follows using above BEx queries as follows :

CC1 100 (100/1000)*100

CC2 200 (200/1000)*100

CC3 300 (300/1000)*100

CC4 400 (400/1000)*100

I hope the above example is clear enough. The problem i am facing is how to use the amount from the second BEx query to use against each cost center amount from the first BEx query in WEBi .

Regards,

Ashutosh Singh