Skip to Content
avatar image
Former Member

not SUM but Database delegated measure in WebI

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.

cumulative.png (58.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 12 at 11:39 AM

    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])

    Add comment
    10|10000 characters needed characters exceeded