Skip to Content
avatar image
Former Member

How do i remove #MULTIVALUE ERROR

Hi All.

I have Three detailed variable (PK1, PK2,PK3) Created on merged dimension Number. These PK1, PK2,PK3 are coming from different queries. I am getting a #MULTIVALUE error under PK3.

For ex

Number PK1 PK2 PK3

111 Pack1 Pack2 pack3

112 Pack1 Pack2 pack3

113 Pack1 Pack2 #MULTIVALUE

I know the reason for MULTIVALUE : ie For Each number there are more than one records under PK3.

QUES: How can i remove the multivalue error and split in into two records

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers