Skip to Content
0
Former Member
Nov 04, 2017 at 06:11 PM

Webi associating object with many merged dimensions #Multivalue

636 Views

Hi WebI experts,

I searched in multiple forums to get the answer but I was not able to . Please help me how to overcome #Multivalue issue .

I have 2 queries .

Query 1 - 3 dimensions and 1 measure

Plant Material Category Stock

Query2 - 4 dimensions and 2 measure

Plant Material Month Date NetQty Price

I made both Plant and Material as merged dimensions. I am using cross tab (month,date in columns)

When I adding Category to Merged Plant and Material it is giving #Multivalue issue.

If i remove one merged dimension from output then it is working if I create variable(category) with detail. But I need both merged dimensions in output.

Category depends on both Plant and Material combination. So please help how to put category in the output.

Thank you.