#Multivalue# error after merge - Webi

[Former Member]

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 ?

[jyothirmayee_s]

Hi,

Try a context variable IN , FOREACH or FORALL

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

Thanks,

Jothi

[kohesco]

Hi,

switch table property do not aggregate on

Grtz

Koen