not SUM but Database delegated measure in WebI

[former_member356315]

Hello,

I need some help with measures in WebI.

I used a bex query for this and WebI doesn't show the same data as in BW.

If you look at the screenshot the measure "Abweichung" on the right should not be culmulative, but constant. In this case the value is always "-5747,72" for every month and if I remove this dimension, it should not sum it up like for "kum." and "Plan".

The meausure "Abweichung" has SUM as aggregation level, whereas "kum." and "Plan" are

database delegated. How can I change the measure so that it stays constant?

Thanks in advance.

[amitrathi239]

is it possible to change the type to database delegated in Bex query?

if not try with create Dimension variable V Abweichung=[Abweichung]

After that use this variable in the table.=Max([V Abweichung]) in (Wretty object])

[former_member356315]

Thanks for your help.

I can't set the type to delegated in bex query, there are just some options for aggregation like sum, max, min, average etc. but nothing of these solve my problem.

I don't want to use a variable in WebI for this. I want to find a solution where I can use the measure from the query without modifying it in Webi. 😕

[amitrathi239]

in that case you need to look in the BEx query only.Have you tried with max function in BEx query?