Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cell Restrictions in SAP Business objects WebInntelligence

Hi All,

I have the below requirement in Webi. Can any one please help me out how can I achieve this requirement in SAP WEBi.

I am using SAP BW back-end and connecting by BICS. I can not use Cell Definition functionality in BEx due to profit centers list is not constant.

Group and Amount values comes from BEx QueryWEBi Calculation
GroupAmount%Formula
Food Sales$ 270,657.0078.20%B3/B5
Liquor Sales$ 75,439.0021.80%B4/B5
Total Sales$ 346,096.00100.00%SUM(C3:C4)
Food Costs$ 71,072.0026.26%B6/B3
Liquor Costs$ 16,428.0021.78%B7/B4
Cost of Goods Sold$ 87,500.0025.28%B8/$B$5
Payroll-Admin$ 22,804.006.59%B9/$B$5
Payroll-Operating$ 76,542.0022.12%B10/$B$5
Total Direct Labor$ 99,346.0028.70%B11/$B$5
Total Prime Cost$ 186,846.0053.99%B12/$B$5
Payroll Related$ 16,388.004.74%B13/$B$5
Laundry & Linen$ 474.000.14%B14/$B$5
Advertising and Sales Promo$ 17,624.005.09%B15/$B$5
Supplies$ 7,203.002.08%B16/$B$5
Heat, Light, and Water$ 6,695.001.93%B17/$B$5
Maintenance$ 6,246.001.80%B18/$B$5
General Operating$ 4,997.001.44%B19/$B$5
Total Operating Expense$ 59,627.0017.23%B20/$B$5

Source data screen shot:

Expected Webi Report.

Tags:
replied

In your formula Actual is a measure object?

Please try following formula

=[actual]/nofilter([actual] where([gl sets] inlist("Food Sales";"Liquor Sales")))

Also please check the [Actual] measure projection on universe .. It should not be 'Database delegate'

If it is then change it to Sum .

Thanks,
Swapnil

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question