BusinessObjects Board

WEBI to calc for each dimension but not show it?

building reports webintelligence
#1

Hi,

My company is switching to WEBI and I’m attempting to recreate the prior Access reports that we used to do.

Basically I have date, ID, Measure1, Measure2, and a Variable which is defined as maximum of Measure 2 less Measure 1 or 0.

Date and ID are dimensions and Measure1 and Measure2 are measures. The Variable is just a IF statement to compare Measure1 and Measure2 and to take the difference if Measure2 is greater, otherwise show 0.

What I want is to remove the ID column and not have it shown. However, I can’t seem to be able to do that without messing up the calculation. In the picture, I want the 10 shown as total but if I try to take out the ID column, the Variable calculates the subtotals so since the total of Measure2 is lower, it shows 0 when it should be 10.

Is there any way around this?
2020-08-27_20-28-51.jpg

Temujin (BOB member since 2020-08-27)

#2

you have to add the calculation-context ForEach ([ID]) to your formula,
without this it calculates correctly on base of the sum-values 430<500 → 0

https://blogs.sap.com/2014/12/19/all-you-need-to-know-about-in-foreach-forall-context-operators/

n8aktiv :de: (BOB member since 2018-12-29)