Skip to Content
0
Former Member
May 28, 2007 at 09:42 AM

Margin BPS-Reports

24 Views

Hi All,

In product margin report, i have the following coloumns,

1. Total Revenue consist of (Existing Business(Actual values) & Forcating business(planned values).

My understanding Total revenue - Cost of sales = Total Margin (Gross margin)

2. Gross margin (%) - Gross margin/Revenue *100 - (Gives in %)

These report has been created in excel.

If i want to do in BW & BPS

I presume i need to create this report in Query designer(BW) and then crate a layout in SEM-BPS where i enter planned values. After entering the planned values , where i can see the actual report , i understand it is recorded in infocube.

Pl could anyone advice me iam i right what iam doing, Kindly suggest me....

Best Regards

Imran