Sap Webi Multivalue Error

[Raz11]

Hi Experts,

I have multiple queries, and I linked all queries with the main one by ID
but I have duplicates when merge it into one sheet.

Any solution for this issue?

Regards.

[nachtaktiv]

start your table with main ID

[Raz11]

it's already start with main ID

[nachtaktiv · Accepted solution]

- your screenshot does not start with the ID 🤔
- be sure that your ID is a dimension and not a measure
- be sure that you use the merged-ID-object in your table  
- try with min() or max() or first() or last() to avoid Multivalue
- start building your table column by column to find the problematic data and fix this column at first

[Raz11]

it's already start with main ID

[Raz11]

It's already start with the main ID