cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BI measure with aggregation Delegated

slvedva
Explorer
0 Kudos
179

Hi experts

Need your help. I build report in SAP BO 4.3 SP4, as source I take the query and load data in BO.

For measurements I have aggregation - Delegated

slvedva_0-1727882389268.png

Under variable I create new measurement, which SUM this value --> =sum([total qty])

I created the chart, which show this qty base on months. Problem starts, when I start use the filters on top, if I select any filters, then the chart is empty. Where is the problem and how to correct this?

I tried change this aggregation "Delegated" to "SUM", but then the values is not correct.

slvedva_1-1727882632379.png

 

nachtaktiv
Participant
0 Kudos
first of all: are you on the latest SP4 patch level?

Accepted Solutions (0)

Answers (3)

Answers (3)

slvedva
Explorer
0 Kudos

@nachtaktiv yes, I checked data also in table, but when I select any filter from any field, then in table measurement column show Unavailable.

slvedva
Explorer
0 Kudos

@nachtaktiv yes, I am using the latest SP4 version.

nachtaktiv
Participant
0 Kudos
did you check the source? is there a view that is optimizing itself when removing columns, so the result will be different? did you check the result in a table instead of a chart?
slvedva
Explorer
0 Kudos

@nachtaktiv yes, I using the latest SP4 version.