Skip to Content
0

not SUM but Database delegated measure in WebI

Feb 12 at 11:32 AM

26

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Feb 12 at 11:39 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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. :/

0

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

0