Skip to Content
0

#Multivalue# error after merge - Webi

Jun 08, 2017 at 05:58 PM

99

avatar image

Hi guys

How do I avoid this multivalue error in merged dimensions...

Query one has 'member no','product' which could mean multiple values for product for each member

Quey 2 has 'member no', 'sales_person_code' and 'transaction date'.

Mere is done on member no but even if I turn product to detail object, I get #multivalue# error on products.

Any solutions ?

10 |10000 characters needed characters left characters exceeded

Hi,

Try a context variable IN , FOREACH or FORALL

=([Merged Memeber No] in ([Product])

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Jun 15, 2017 at 01:37 PM
0

Hi,

switch table property do not aggregate on

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded